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-08T14:01:24.710' ,`MLSNumber` = '6227801' ,`ListAgentFullName` = 'Deanna Parsons' ,`ListOfficeName` = 'Hill & Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.194294' ,`Longitude` = '-95.096460' ,`PhotoCount` = '13' ,`PostalCode` = '77327' ,`RoomCount` = '5' ,`ListPrice` = '174900.00' ,`Status` = 'Active' ,`StreetName` = 'Plum Grove' ,`StreetNumber` = '9365' ,`StreetSuffix` = 'Road' ,`City` = 'Cleveland' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2768' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'OVER THREE ACRES!! This one has a nice big shop and a blank slate for you! Large living area. Big backyard. Measurements are approximate, please measure if important.' ,`Acres` = '3.1836' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Real Estate Owned' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = '000208 A HOLHOUSEN, TRACT 203, ACRES 3.1836' ,`LotDesciption` = 'Cleared' ,`LotSize` = '138678' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '100 - Cleveland' ,`SchoolElementary` = 'COTTONWOOD SCHOOL (CLEVELAND)' ,`SchoolHigh` = 'CLEVELAND HIGH SCHOOL' ,`SchoolMiddle` = 'CLEVELAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'A Holhousen' ,`TaxAmount` = '4254' ,`TaxRate` = '2.2178' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663695945' WHERE `Matrix_Unique_ID` = '204881347' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-08T15:20:12.687' ,`MLSNumber` = '71148648' ,`ListAgentFullName` = 'Albert Johnson' ,`ListOfficeName` = 'Keller Williams Realty -SW' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.914178' ,`Longitude` = '-93.895624' ,`PhotoCount` = '6' ,`PostalCode` = '77642' ,`RoomCount` = '3' ,`ListPrice` = '35000.00' ,`Status` = 'Active' ,`StreetName` = 'Procter' ,`StreetNumber` = '5153' ,`StreetSuffix` = 'Street' ,`City` = 'Port Arthur' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1540' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '' ,`Area` = '51' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 15 BLK 12 LAKEVIEW' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '236 - Port Arthur' ,`SchoolElementary` = 'TRAVIS ELEMENTARY SCHOOL (PORT ARTHUR)' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (PORT ARTHUR)' ,`SchoolMiddle` = 'JEFFERSON MIDDLE SCHOOL (PORT ARTHUR)' ,`ShowInstructions` = 'No Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Del Mar Terrace' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1962' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663695945' WHERE `Matrix_Unique_ID` = '206791266' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-08T14:09:01.217' ,`MLSNumber` = '19301807' ,`ListAgentFullName` = 'Andrea Dadinis' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.781062' ,`Longitude` = '-95.242107' ,`PhotoCount` = '17' ,`PostalCode` = '77013' ,`RoomCount` = '5' ,`ListPrice` = '279000.00' ,`Status` = 'Active' ,`StreetName` = 'Rainy Meadow' ,`StreetNumber` = '484' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1510' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful home in established neighborhood Songwood. Recently remodeled, move in ready home next door to beautiful Herman Brown Park. Three bedroom, two bathroom, brick home centrally located. Over 10,000 sq ft lot with well maintained home. Granite counter tops throughout, tile throughout and large bonus room being used as media room. 2 storage sheds, large covered patio and rain water collection system. Enjoy your covered patio and large backyard year round.' ,`Acres` = '0.2491' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northeast Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 26 BLK 11 SONGWOOD SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10850' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '20' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WHITTIER ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'FURR HIGH SCHOOL' ,`SchoolMiddle` = 'HOLLAND MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Temporarily No Showings' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Songwood 5' ,`TaxAmount` = '3212' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1965' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663695945' WHERE `Matrix_Unique_ID` = '207857108' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-08T14:17:05.300' ,`MLSNumber` = '52643547' ,`ListAgentFullName` = 'Debra Spurr' ,`ListOfficeName` = 'Grace Team Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.498971' ,`Longitude` = '-94.992512' ,`PhotoCount` = '18' ,`PostalCode` = '77518' ,`RoomCount` = '5' ,`ListPrice` = '475000.00' ,`Status` = 'Active' ,`StreetName` = 'Avenue D' ,`StreetNumber` = '1901' ,`StreetSuffix` = '' ,`City` = 'Bacliff' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '4650' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'GREAT BARNDOMINIUM BUILD OUT POTENTIAL AND INCOME PRODUCING PROPERTY! You won\'t want to miss this property on a corner lot in Bacliff. This property sets just off of Hwy. 146 and just blocks away from Galveston Bay. Property consists of a two bedroom, two bath, living room and kitchen upstairs apartment, with an expansive income producing warehouse/workshop, and RV/Boat storage. This multipurpose property could also be built out as a large, lovely barndominium. The workshop has one set of sliding garage doors and one large roller door, two lofts, one office, laundry room and bathroom, car/boat lift. **ROOF REPLACED/2022; DOUBLE PANED LOW E WINDOWS IN LIVING QUARTER REPLACED 2022! Lease option available!' ,`Acres` = '0.1435' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Bacliff/San Leon' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 164 E PAYNE SUR LOTS 47 & 48 BLK 131 CLIFTON BY THE' ,`LotDesciption` = 'Corner' ,`LotSize` = '6250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '8' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'KENNETH E. LITTLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'DUNBAR MIDDLE SCHOOL (DICKINSON)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Barndominium,Split Level' ,`Subdivision` = 'Clifton By The Sea' ,`TaxAmount` = '419' ,`TaxRate` = '2.2342' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663695945' WHERE `Matrix_Unique_ID` = '208409523' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-08T14:09:00.263' ,`MLSNumber` = '83312630' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'Empire Communities' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.678410' ,`Longitude` = '-95.901026' ,`PhotoCount` = '13' ,`PostalCode` = '77441' ,`RoomCount` = '9' ,`ListPrice` = '689421.00' ,`Status` = 'Active' ,`StreetName` = 'Creekbend' ,`StreetNumber` = '4826' ,`StreetSuffix` = 'Drive' ,`City` = 'Fulshear' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3408' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'September Completion! This brick & stucco one-story has 4 bedrooms, 3.5 baths, game room, and a 3-car garage. This home features a large covered front porch, a grand gallery entrance, and a secluded private study. The open living area has high ceilings throughout, gourmet kitchen with a large island and walk-in pantry, spacious family dining area, and great room with fireplace. The owners’ suite has a beautiful bow window, separate vanities in the bathroom, freestanding tub, and massive walk-in closet. Enjoy entertaining family and friends in the game room, or sitting outside on the covered back patio. One of this home’s most notable features is the 3 full-size garage bays – you don’t have to navigate a tandem garage once you move in here!' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Empire Communities' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fulshear/South Brookshire/Simonton' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 14, Block 2, Section 15' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '10288' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'HUGGINS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Fulbrook at Fulshear Creek' ,`TaxAmount` = '' ,`TaxRate` = '2.99' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663695945' WHERE `Matrix_Unique_ID` = '208775728' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-08T14:17:13.180' ,`MLSNumber` = '38089324' ,`ListAgentFullName` = 'Nimesh Patel' ,`ListOfficeName` = 'RE/MAX Fine Properties' ,`SellingAgentFullName` = 'Robin Rash' ,`SellingOfficeName` = 'Middleton Group Realty' ,`Latitude` = '29.482365' ,`Longitude` = '-95.467315' ,`PhotoCount` = '33' ,`PostalCode` = '77583' ,`RoomCount` = '6' ,`ListPrice` = '299700.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Mariquita' ,`StreetNumber` = '1242' ,`StreetSuffix` = 'Lane' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1584' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home to Glendale Lakes! This Wren floor plan offers 3 spacious Bedrooms and 2 Bathrooms. This open design floor plan is ready for August move-in! A modern Kitchen featuring 42’’ shaker Kitchen flat panel cabinetry, Quartz countertops with ceramic tile backsplash, high quality Frigidaire appliances and Kitchen island. Relaxing bathrooms with double sinks, separate tub and shower in the Primary Bath, ceramic tile surround with tub in Secondary Baths and Quartz countertops. Energy efficiency features: 16 SEER carrier AC system with programmable thermostat, 40 gallon gas water heater. Full sod front and back landscape package included, Rear Patio, Brick fronts with stone accents per elevation and many more. If you are looking for a great community with easy access to outstanding shopping, dining, and majors freeways, in one of the best school districts, look no further! Set up your appointment today!' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'Saratoga Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 14 Block 1 Section GL-9 Glendale Lakes' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5000' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '550' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'HERITAGE ROSE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Glendale Lakes' ,`TaxAmount` = '' ,`TaxRate` = '3.14' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663695945' WHERE `Matrix_Unique_ID` = '209187762' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-08T14:46:50.963' ,`MLSNumber` = '38476949' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'LennarVillageBldr-JaredTurner' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.887123' ,`Longitude` = '-95.834658' ,`PhotoCount` = '9' ,`PostalCode` = '77493' ,`RoomCount` = '5' ,`ListPrice` = '262990.00' ,`Status` = 'Active' ,`StreetName` = 'Winward Creek' ,`StreetNumber` = '26922' ,`StreetSuffix` = 'Trail' ,`City` = 'Katy' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1043' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW! Lennar Homes Cottage Series, \'\'Grove\'\' Plan with Elevation \'\'C\" in Beautiful Winward! This new home is laid out on a single floor for maximum comfort and convenience. It features an open-plan layout that connects the family room, dining room and modern kitchen. The owner’s suite and the secondary bedroom both feature walk-in closets. A laundry room and two-car garage complete the floorplan.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Lennar' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SEC 0007 BLK 001 LOT 018' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'MCELWAIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Winward' ,`TaxAmount` = '' ,`TaxRate` = '3.48' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663695946' WHERE `Matrix_Unique_ID` = '209455431' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-08T15:11:36.127' ,`MLSNumber` = '68125528' ,`ListAgentFullName` = 'Kimberly Handley' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.460224' ,`Longitude` = '-94.617397' ,`PhotoCount` = '50' ,`PostalCode` = '77650' ,`RoomCount` = '6' ,`ListPrice` = '799000.00' ,`Status` = 'Active' ,`StreetName` = 'Martinique' ,`StreetNumber` = '2308' ,`StreetSuffix` = '' ,`City` = 'Crystal Beach' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1760' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully furnished, steps away from the beach and ready for its new family. This 3 bedroom, 2.5 bath home offers light & bright coastal interior featuring high vaulted ceiling with rustic wood beam in the living area with whitewashed shiplap walls and wood blinds throughout. Kitchen boasts a large island with plenty of seating, abundance of cabinets, granite countertops, wine fridge, and stainless-steel appliances. This open concept floorplan is great for entertaining and boasts its Southern Coastal Charm. Split floorplan provides privacy for the master suite and stunning master bath! Large, covered deck allows ample room for multiple seating areas, entertaining and simply enjoying the peek a boo views and sounds of the gulf. Downstairs offers 1 car garage, outdoor shower and ample space for outdoor entertaining and family gatherings. This home would make an excellent rental or an amazing vacation home for the whole family. Great location close to shopping and eateries.' ,`Acres` = '0.161' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Crystal Beach' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 65 FRANKS B SUR LOT 27 BLK 1 SANDPIPER BEACH' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '7013' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`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` = 'Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sandpiper Beach' ,`TaxAmount` = '7169' ,`TaxRate` = '1.6103' ,`WaterSewer` = 'Septic Tank,Water District' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663695946' WHERE `Matrix_Unique_ID` = '210340490' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-08T14:40:29.400' ,`MLSNumber` = '42281933' ,`ListAgentFullName` = 'Grace Guillen-Trevino' ,`ListOfficeName` = 'Executive Texas Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.168861' ,`Longitude` = '-95.160481' ,`PhotoCount` = '26' ,`PostalCode` = '77357' ,`RoomCount` = '4' ,`ListPrice` = '345000.00' ,`Status` = 'Active' ,`StreetName` = 'Northampton' ,`StreetNumber` = '25568' ,`StreetSuffix` = '' ,`City` = 'New Caney' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2768' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great half acre property in New Caney!! Minutes from new Valley Ranch shopping and amusement parks. Country living not too far from the city!! This home boast commercial appliances and big bedrooms. Come out and take a look. You won\'t be disappointed!!' ,`Acres` = '0.4591' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Porter/New Caney East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'S643201 - KINGS COLONY 01, BLOCK 22, LOT 23' ,`LotDesciption` = 'Wooded' ,`LotSize` = '22524' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'DOGWOOD ELEMENTARY SCHOOL (NEW CANEY)' ,`SchoolHigh` = 'NEW CANEY HIGH SCHOOL' ,`SchoolMiddle` = 'KEEFER CROSSING MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Ranch' ,`Subdivision` = 'Kings Colony 01' ,`TaxAmount` = '2731' ,`TaxRate` = '2.1331' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663695946' WHERE `Matrix_Unique_ID` = '210372858' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-08T15:49:47.477' ,`MLSNumber` = '46904466' ,`ListAgentFullName` = 'Noeme Arceneaux' ,`ListOfficeName` = 'Mega Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.952455' ,`Longitude` = '-95.361093' ,`PhotoCount` = '33' ,`PostalCode` = '77541' ,`RoomCount` = '3' ,`ListPrice` = '179000.00' ,`Status` = 'Active' ,`StreetName` = '4th' ,`StreetNumber` = '1114' ,`StreetSuffix` = 'Street' ,`City` = 'Freeport' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1064' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 1114 4h street, Freeport. This Cottage style home is waiting for its new Occupants to call it home. Walk into the front door and be greeted by a Beautiful Open floorplan with Laminate Floors though-out. The home offers Plenty of Windows for natural sunlight in all the rooms. The Kitchen offers beautiful QUARTZ countertops with a nice size Breakfast Bar. There are Two Bedrooms with a large Bonus room which could be a third bedroom, Office, playroom, huge closet, so many possibilities. Two full bathrooms also completely remodeled. The indoor Laundry/ Utility room is very spacious with the back door leading to a Wood Deck/Patio for entertaining or just sipping a nice beverage. The home offers large driveway that leads to a STORAGE BLDG (WOOD/METAL) to store all your Gadgets.' ,`Acres` = '0.16' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Freeport' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'FREEPORT BLK 127 LOT 12' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'VELASCO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRAZOSPORT HIGH SCHOOL' ,`SchoolMiddle` = 'FREEPORT INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'FREEPORT BLK 127 LOT 12' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1940' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663695946' WHERE `Matrix_Unique_ID` = '210498067' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-08T14:43:53.753' ,`MLSNumber` = '87642198' ,`ListAgentFullName` = 'Erik Frankson' ,`ListOfficeName` = 'Ward Real Estate, Inc' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.967584' ,`Longitude` = '-95.957300' ,`PhotoCount` = '24' ,`PostalCode` = '77414' ,`RoomCount` = '4' ,`ListPrice` = '649000.00' ,`Status` = 'Active' ,`StreetName` = 'Valhalla' ,`StreetNumber` = '55' ,`StreetSuffix` = '' ,`City` = 'Bay City' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3950' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This one has it all! A great layout starting with a large foyer, 2 fireplaces, 2 living rooms, a formal dining room, & big utility room. Kitchen features stainless steel appliances & granite countertops, walk-in pantry, & breakfast nook. Tons of storage throughout, there\'s even a closet under the stairs! Downstairs there\'s office with built-ins galore, a 1/2 bath for guests, & a nice primary suite with 2 walk-in closets. Beautiful staircase leads to 3 more bedrooms & 2 baths. Fabulous backyard is set up for entertaining with the sparkling pool, screened-in outdoor kitchen, & a putting green!' ,`Acres` = '0.6' ,`Area` = '54' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'VALHALLA S/D SEC 3, LOT 6 (LESS W 5\')' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '132 - Bay City' ,`SchoolElementary` = 'TENIE HOLMES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BAY CITY HIGH SCHOOL' ,`SchoolMiddle` = 'BAY CITY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Valhalla' ,`TaxAmount` = '9494' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663695946' WHERE `Matrix_Unique_ID` = '210558883' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-08T14:11:33.623' ,`MLSNumber` = '98696482' ,`ListAgentFullName` = 'Nasser Maaz' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.685910' ,`Longitude` = '-95.199945' ,`PhotoCount` = '11' ,`PostalCode` = '77502' ,`RoomCount` = '10' ,`ListPrice` = '249995.00' ,`Status` = 'Active' ,`StreetName` = 'Austin' ,`StreetNumber` = '1009' ,`StreetSuffix` = 'Avenue' ,`City` = 'Pasadena' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1450' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'House was completely reconstructed. Stripped down to the studs then rebuilt.' ,`Acres` = '0.1515' ,`Area` = '6' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Pasadena' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 5 BLK 1 SOUTH PASADENA VILLAS' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'SOUTH SHAVER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SAM RAYBURN HIGH SCHOOL' ,`SchoolMiddle` = 'SOUTHMORE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'South Pasadena Villas' ,`TaxAmount` = '3294' ,`TaxRate` = '2.6514' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1956' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663695946' WHERE `Matrix_Unique_ID` = '210570187' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-08T14:53:09.500' ,`MLSNumber` = '30742959' ,`ListAgentFullName` = 'Abraham Lozano' ,`ListOfficeName` = 'The Monarch Team, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.776447' ,`Longitude` = '-95.333235' ,`PhotoCount` = '25' ,`PostalCode` = '77020' ,`RoomCount` = '3' ,`ListPrice` = '570000.00' ,`Status` = 'Active' ,`StreetName` = 'Capron' ,`StreetNumber` = '1617' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2555' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to Capron Street! This new construction home has a multitude of features designed with you in mind. When you first enter your new home, you\'ll enjoy first floor living with a welcoming open concept; entry foyer; formal dining room with a bar wall then a spacious living room that meets the gorgeous kitchen. Custom built kitchen cabinets and sleek quartz counters. The breakfast room leads right out to the fenced yard. On the second floor your three spacious bedrooms and two bathroom (one en-suite master). This home provides a great opportunity to buy in a rapidly developing neighborhood - plus you\'re within minutes of entertainment spots, downtown, i-10 and many upcoming restaurants & bars opening each month! Call today for your private tour.' ,`Acres` = '0.101' ,`Area` = '2' ,`BuilderName` = 'STARP Home Builder' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Denver Harbor' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'TRS 9 & 10A BLK 1 CHAPMANS SEC 3' ,`LotDesciption` = 'Cleared' ,`LotSize` = '4400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`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` = '27 - Houston' ,`SchoolElementary` = 'ATHERTON ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WHEATLEY HIGH SCHOOL' ,`SchoolMiddle` = 'FLEMING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Chapmans Sec 03' ,`TaxAmount` = '1134' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663695946' WHERE `Matrix_Unique_ID` = '210784861' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-08T14:48:34.640' ,`MLSNumber` = '43311080' ,`ListAgentFullName` = 'Saul Silva' ,`ListOfficeName` = 'Century 21 Garlington & Assoc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.801787' ,`Longitude` = '-95.174403' ,`PhotoCount` = '50' ,`PostalCode` = '77015' ,`RoomCount` = '8' ,`ListPrice` = '399900.00' ,`Status` = 'Active' ,`StreetName` = 'Falling Tree' ,`StreetNumber` = '13923' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2908' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home this 4 bedroom 3 1/2 bath is a must see. Yes house is zoned to North Shore High School home of the mighty Mustangs more picture coming soon.' ,`Acres` = '' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 16 BLK 1 WOODFOREST NORTH SEC 8' ,`LotDesciption` = 'Cleared' ,`LotSize` = '11037' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '21 - Galena Park' ,`SchoolElementary` = 'HAVARD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTH SHORE SENIOR HIGH SCHOOL' ,`SchoolMiddle` = 'NORTH SHORE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodforest North Sec 08' ,`TaxAmount` = '7675' ,`TaxRate` = '2.9394' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663695947' WHERE `Matrix_Unique_ID` = '210785771' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-08T15:20:45.163' ,`MLSNumber` = '36589114' ,`ListAgentFullName` = 'Nicholas Moncada' ,`ListOfficeName` = 'Douglas Elliman Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.960489' ,`Longitude` = '-95.623625' ,`PhotoCount` = '46' ,`PostalCode` = '77429' ,`RoomCount` = '13' ,`ListPrice` = '425000.00' ,`Status` = 'Active' ,`StreetName` = 'Campsite' ,`StreetNumber` = '12602' ,`StreetSuffix` = 'Trail' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3178' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully updated home has primary down plus study and sunroom down and game room up. New roof, May 2022. New wood look tile floors down, June 2022. New 6-inch baseboards throughout, July 2022. New carpet up, July 2022. New toilets, sinks and quartz counter tops in baths and kitchen, July 2022. New kitchen appliances including double WIFI ovens, July 2022. New satin nickel faucets and hardware, July 2022. New decorator satin nickel lighting, July 2022. New interior and exterior paint, July 2022. New 2-inch blinds, July 2022. Hardie plank siding. Crown molding throughout. Oversized 3-car garage with workshop counter and cabinets. Sunroom has separate AC unit. Mature landscaping. Mature trees. Back yard has plenty of room for your custom pool design. Perfect for entertaining and is a must see!' ,`Acres` = '0.2925' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 13 BLK 12 Ravensway Sec 1' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '12740' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '683' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'MILLSAP ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CY-FAIR HIGH SCHOOL' ,`SchoolMiddle` = 'ARNOLD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Ravensway' ,`TaxAmount` = '6691' ,`TaxRate` = '2.5737' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '1975' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663695947' WHERE `Matrix_Unique_ID` = '210895159' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-08T15:08:32.477' ,`MLSNumber` = '55552600' ,`ListAgentFullName` = 'Cheryl Harkness' ,`ListOfficeName` = 'Southern Star Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.195031' ,`Longitude` = '-97.469590' ,`PhotoCount` = '15' ,`PostalCode` = '77994' ,`RoomCount` = '6' ,`ListPrice` = '299000.00' ,`Status` = 'Active' ,`StreetName` = 'US Highway 87' ,`StreetNumber` = '13249' ,`StreetSuffix` = 'Highway' ,`City` = 'Westhoff' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2406' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'CHARMING 1950 HOME ON 1.71 AC LOT ALONG US HWY 87. STORGE BUILDING AND CARPORT WILL REMAIN. THERE ARE 5 LOTS ON THIS PROPERTY AND ANOTHER SMALL .20 AC LOT ON THE CORNER OF CHEAPSIDE RD AND RAILROAD. ALL PROPERTY CAN BE USED AS RESIDENTIAL OR COMMERCIAL. APPROX 253 FT OF HWY FRONTAGE. ALL MEASUREMENTS ARE APPROX' ,`Acres` = '1.71' ,`Area` = '83' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = '7-12 9 BELLO SO 20 X 150 OF ALLEY' ,`LotDesciption` = 'Cleared,Corner' ,`LotSize` = '' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1025 - Westhoff' ,`SchoolElementary` = '' ,`SchoolHigh` = '' ,`SchoolMiddle` = 'WESTHOFF ELEMENTARY SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Back' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'NONE' ,`TaxAmount` = '1829' ,`TaxRate` = '1.7257' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663695947' WHERE `Matrix_Unique_ID` = '211179249' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-08T15:40:22.727' ,`MLSNumber` = '63097322' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'Empire Communities' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.509012' ,`Longitude` = '-95.410087' ,`PhotoCount` = '41' ,`PostalCode` = '77578' ,`RoomCount` = '7' ,`ListPrice` = '500000.00' ,`Status` = 'Active' ,`StreetName` = 'Broad Reach' ,`StreetNumber` = '2606' ,`StreetSuffix` = 'Road' ,`City` = 'Manvel' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2760' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'You will love this charming, gated community, where there are amenities galore. Located off of the 288 Corridor and C.R. 58, Newport Lake Estates offers the lifestyle you are looking for. This vibrant community has easy access to the Medical Center, Downtown Houston, and Galveston, Texas. The Atlin floorplan is the home that you have been looking for. This home features 4 bedrooms, 3 baths, and a 2-car garage. Convenient 2 bedrooms downstairs and spaces game room located upstairs. Charming farmhouse sink, white cabinets, and quartz countertops in the gourmet kitchen. The primary bedroom welcomes you with 5 large bay windows, enjoy a relaxing night in your owner\'s bath featuring double sinks, a huge walk-in closet, a separate tub, and a shower. Covered patio in backyard, perfect for entertaining. Estimated completion Spring 2022!' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Empire Communities' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 21 Block 5, Section 1' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '935' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'DON JETER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'RODEO PALMS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Newport Lake Estates' ,`TaxAmount` = '' ,`TaxRate` = '3.725' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663695947' WHERE `Matrix_Unique_ID` = '211184797' --> Updated record success