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` = '2023-01-16T10:47:13.453' ,`MLSNumber` = '73013162' ,`ListAgentFullName` = 'Nikola Knezevic' ,`ListOfficeName` = 'NB Elite Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.840199' ,`Longitude` = '-95.548488' ,`PhotoCount` = '17' ,`PostalCode` = '77041' ,`RoomCount` = '3' ,`ListPrice` = '249900.00' ,`Status` = 'Active' ,`StreetName` = 'Juniper Glen' ,`StreetNumber` = '10315' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1540' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Possibly THE BEST LOOKING HOME in the neighborhood considering the price...COMPLETELY REMODELED inside & out nice size three bedroom 2 bath home in popular Spring Branch neighborhood Westbranch...TOO MANY UPGRADES TO MENTION...All new: roof, siding, flooring, hardware, appliances, granite in kitchen and bathrooms, shower and tub, the list goes on and on...Must see for a picky buyer looking for a completely upgraded home...HURRY!' ,`Acres` = '0.1567' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Corporate Listing,Owner/Agent,Sellers Disclosure,Special Addendum' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 12 WESTBRANCH SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6825' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '271' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'KIRK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'TRUITT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Westbranch Sec 02' ,`TaxAmount` = '3242' ,`TaxRate` = '2.5842' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675172028' WHERE `Matrix_Unique_ID` = '206742697' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-16T09:15:29.150' ,`MLSNumber` = '87814508' ,`ListAgentFullName` = 'Teri Walter' ,`ListOfficeName` = 'K. Hovnanian of Houston II, LL' ,`SellingAgentFullName` = 'Casey York' ,`SellingOfficeName` = 'Discovered Homes Inv. Inc.' ,`Latitude` = '29.642633' ,`Longitude` = '-95.398358' ,`PhotoCount` = '26' ,`PostalCode` = '77045' ,`RoomCount` = '12' ,`ListPrice` = '468047.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Eastgrove Park' ,`StreetNumber` = '11907' ,`StreetSuffix` = 'Way' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2658' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Kirby Landing is a privately gated community with easy access to HWY 288 and conveniently located only minutes from Downtown Houston and The Medical Center. Amenities include a centralized walking trail and a gated fun area for four legged friends. \r\nThe Athena II is our largest plan and offers a spacious open concept design. Grand entry that leads you into the extended foyer with a valet, home office, a bedroom and a full bath. Second floor is the living area with a gourmet kitchen that flows into the great room. Beautiful maple cabinets, quartz countertops, farmhouse sink and walk-in pantry in kitchen. 2nd floor covered patio with storage just off dining room. Third floor has the oversized owner\'s suite and walk-in closet. Dual vanity sinks, separate tub and shower in owner\'s bath. One secondary bedroom with en-suite bath also upstairs.\r\nOur interior designs have chosen the perfect colors for this plan. Lots of extra closets in this home. Offered by: K. Hovnanian Houston III, L.L.C.' ,`Acres` = '' ,`Area` = '3' ,`BuilderName` = 'K. Hovnanian Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Five Corners' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '1/2/1' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '2714' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'REYNOLDS ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WORTHING HIGH SCHOOL' ,`SchoolMiddle` = 'ATTUCKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Kirby Landing' ,`TaxAmount` = '' ,`TaxRate` = '3.26' ,`WaterSewer` = 'Other Water/Sewer,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675172028' WHERE `Matrix_Unique_ID` = '208822191' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-16T10:26:59.480' ,`MLSNumber` = '46991988' ,`ListAgentFullName` = 'Kevin Best' ,`ListOfficeName` = 'San Antonio Portfolio KW RE' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.469911' ,`Longitude` = '-94.597565' ,`PhotoCount` = '28' ,`PostalCode` = '77650' ,`RoomCount` = '13' ,`ListPrice` = '899000.00' ,`Status` = 'Active' ,`StreetName` = 'Palm Ridge' ,`StreetNumber` = '922' ,`StreetSuffix` = 'Drive' ,`City` = 'Crystal Beach' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2300' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Incredible 4 bedroom, 3 1/2 bathroom home located in the ever popular Crystal Beach. Expansive covered main deck that faces the south, allowing for the perfect entertainment with spectacular views of the Gulf of Mexico. This home can comfortably sleep 14 and has a bonus area that can accommodate 2 more. There is an abundance of light, with exquisite finishes and design. Kitchen boasts granite countertops, farmhouse sink, SS appliances, breakfast bar, & custom cabinetry. Below the home is an extraordinary entertainment area with a Cabana bar, swing, and beach ambience creating that vacation retreat. This home is a jewel by the Gulf!' ,`Acres` = '0.232' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Crystal Beach' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 65 B FRANKS SUR LOTS 18 & 19 BLK 6 TIDELANDS ADDN' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '10099' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Tidelands' ,`TaxAmount` = '9608' ,`TaxRate` = '1.61' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675172029' WHERE `Matrix_Unique_ID` = '209394398' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-16T10:30:35.987' ,`MLSNumber` = '31830668' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.318615' ,`Longitude` = '-95.452286' ,`PhotoCount` = '18' ,`PostalCode` = '77583' ,`RoomCount` = '9' ,`ListPrice` = '539990.00' ,`Status` = 'Active' ,`StreetName` = 'Lakeland' ,`StreetNumber` = '1451' ,`StreetSuffix` = 'Circle' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '2768' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This spacious one-story home optimizes every square foot for luxurious living. This is the perfect home for entertaining with an open layout between the chef\'s kitchen opens to the dining room and the family room with a fireplace. A private study off of the family room maximizes the view of your huge backyard! Relax in your luxury master retreat that includes two large his and hers walk-in closets. Two spacious bedrooms each with walk-in closets located at the front of the home. The optional super shower in the master bath was added as well as the second-floor game room/half bath option! Wood flooring throughout the main living area plus many more upgrades throughout the home!' ,`Acres` = '1.001' ,`Area` = '5' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Rosharon' ,`HeatSystem` = 'Propane' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 31, Block 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '43560' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '475' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '5 - Angleton' ,`SchoolElementary` = 'FRONTIER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Other Style,Traditional' ,`Subdivision` = 'The Oaks at Suncreek Estates' ,`TaxAmount` = '' ,`TaxRate` = '1.986' ,`WaterSewer` = 'Aerobic,Public Water,Septic Tank' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675172029' WHERE `Matrix_Unique_ID` = '209588526' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-16T10:57:18.640' ,`MLSNumber` = '8287676' ,`ListAgentFullName` = 'James Selig' ,`ListOfficeName` = 'Keller Williams Realty - Memor' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.303178' ,`Longitude` = '-94.778688' ,`PhotoCount` = '14' ,`PostalCode` = '77550' ,`RoomCount` = '5' ,`ListPrice` = '340000.00' ,`Status` = 'Active' ,`StreetName` = 'Broadway' ,`StreetNumber` = '1115' ,`StreetSuffix` = 'Street' ,`City` = 'Galveston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1333' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'According to the Galveston Historical Foundation, this adorable larger than normal cottage was built in 1922 and moved from 623 Postoffice to its present location in the East End Historic District in 1999. The high ceilings, French doors, bay window, spacious rooms, and Victorian details provide that charm of yesteryear. One of the bedrooms is extra large and could be a great bunk room or a great spacious primary bedroom with space for sleeping and seating areas. The backyard is spacious and includes deck space, a wheelchair ramp, off street parking, and a pretty yard. The location is fabulous! Just a short stroll to the beach and UTMB and close to the activities downtown, this home could be a great permanent home or rental.' ,`Acres` = '0.1179' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'East End' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 628 M B MENARD SUR LOT 4 BLK 131 GALVESTON' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5136' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Victorian' ,`Subdivision` = 'Galveston Townsite' ,`TaxAmount` = '4505' ,`TaxRate` = '2.0662' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1922' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675172029' WHERE `Matrix_Unique_ID` = '209840866' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-16T10:06:33.107' ,`MLSNumber` = '27600428' ,`ListAgentFullName` = 'Maria Dieguez' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.066691' ,`Longitude` = '-95.976821' ,`PhotoCount` = '19' ,`PostalCode` = '77484' ,`RoomCount` = '3' ,`ListPrice` = '340000.00' ,`Status` = 'Active' ,`StreetName` = 'Ezekiel Smith' ,`StreetNumber` = '736' ,`StreetSuffix` = 'Street' ,`City` = 'Prairie View' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1567' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Do you dream to live in countryside?, this is the house, new construction, setting on almost !/2 acre lot, quiet community and close to U.S. 290, Northwest Freeway. House features 3 bed and 2 full baths, spacious kitchen with granite countertop, self-closing cabinets and drawers, gutters, spacious room and laundry with big sink. Back yard is huge, you can built a swimming pool, workshop, etc. Room measurements are approximate and has to verified. Ready to move-in.' ,`Acres` = '0.4225' ,`Area` = '26' ,`BuilderName` = 'Seller' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Waller' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'S721200 PRAIRIE VIEW ESTATES 2 BLK 12 LOT 195' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '18404' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'H T JONES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'WALLER JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Other Style,Traditional' ,`Subdivision` = 'Prairie View Estates 2' ,`TaxAmount` = '979' ,`TaxRate` = '2.7548' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1675172029' WHERE `Matrix_Unique_ID` = '209847712' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-16T10:18:44.337' ,`MLSNumber` = '33614423' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'KB Home Houston' ,`SellingAgentFullName` = ' Non-MLS Agent' ,`SellingOfficeName` = 'Non-MLS ' ,`Latitude` = '29.843790' ,`Longitude` = '-95.810976' ,`PhotoCount` = '6' ,`PostalCode` = '77493' ,`RoomCount` = '9' ,`ListPrice` = '379995.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Padbury Manor' ,`StreetNumber` = '4623' ,`StreetSuffix` = 'Court' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2130' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**home is under construction.** Fall in love with this beautiful KB Home in Katy Manor South, boasting a brick front, vinyl plank flooring, and an open great room. Try a new recipe in the kitchen, equipped with Silestone countertops, stainless steel Energy Star® appliances, 42-in. cabinets, pendant lighting, and undercabinet lighting. The serene primary suite features extended dual vanities and a shower with a Moen Gibson® WaterSense Showerhead. Additional home features include faux wood blinds and full gutters. The peaceful Katy Manor South community provides a splash pad, park, and playground. Situated near I-10 and the Grand Parkway, residents enjoy easy access to the Katy Mills Mall and the Energy Corridor. Zoned to the highly-acclaimed Katy ISD.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'KB Home' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 24 Block 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '465' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'MCELWAIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Katy Manor' ,`TaxAmount` = '' ,`TaxRate` = '3.556' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675172029' WHERE `Matrix_Unique_ID` = '210556624' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-16T09:02:51.183' ,`MLSNumber` = '74068893' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Long Lake LTD' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.458590' ,`Longitude` = '-95.472115' ,`PhotoCount` = '28' ,`PostalCode` = '77583' ,`RoomCount` = '9' ,`ListPrice` = '308990.00' ,`Status` = 'Active' ,`StreetName` = 'Upland Grove' ,`StreetNumber` = '426' ,`StreetSuffix` = 'Trail' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1378' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Feel at ease in this beautiful Pride Builders home in Huntington Place. Nestled on a spacious lot, this 3-sided brick home boasts a premium elevation, no back neighbors, tile flooring, faux wood blinds, a cast stone fireplace, and a covered patio. Master new recipes in the kitchen, equipped with granite countertops, tile backsplash, stainless steel appliances, 42” upper cabinets, and undercabinet lighting. With dual vanities, a 36” tub, and a separate shower, the primary suite is a wonderful place to relax. Amenities of Huntington Place include a community pool, recreation center, and abundant green spaces. Residents benefit from direct access to Hwy 288 and Hwy 6, making the drive to the Texas Medical Center a quick one. Numerous outdoor adventures and nature parks surround the area, along with a variety of shops and restaurants. This is your dream home – call now to learn more!' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'Pride Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 23 Block 1' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '523' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven,Single 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` = 'Huntington Place' ,`TaxAmount` = '' ,`TaxRate` = '3.25' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675172030' WHERE `Matrix_Unique_ID` = '210989590' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-16T10:15:05.473' ,`MLSNumber` = '34955634' ,`ListAgentFullName` = 'Matthew Guzman' ,`ListOfficeName` = 'RE/MAX Universal' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.082964' ,`Longitude` = '-95.543689' ,`PhotoCount` = '15' ,`PostalCode` = '77379' ,`RoomCount` = '11' ,`ListPrice` = '345377.00' ,`Status` = 'Active' ,`StreetName` = 'Grand Louis' ,`StreetNumber` = '7835' ,`StreetSuffix` = 'Way' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2487' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to your beautiful 2 Story, Silverstone 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, Living Room, Dining Room, & Half Bath downstairs. Upstairs you will find all Bedrooms including the oversized Owner’s Retreat, Game Room & a full Bath. Vinyl and Carpet throughout. Stainless Steel Appliances, and even a USB outlet. Fenced Backyard. COST & ENERGY EFFICIENCY FEATURES: Lennox 16 Seer HVAC System, Honeywell Thermostat, Pex Hot & Cold Water Lines, Rheem Whole House Tankless Gas Water Heater, Radiant Barrier, and Vinyl Double Pane Low E Windows that open to the inside of the home for cleaning. Shopping, Entertainment, and Dining are just minutes away with the Grand Parkway providing quick commutes to Tomball, Houston and The Woodlands. Easy access to TX 249 and I45. Klein ISD!' ,`Acres` = '' ,`Area` = '14' ,`BuilderName` = 'Anglia Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring/Klein/Tomball' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'NA' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '626' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'SCHULTZ ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN OAK HIGH SCHOOL' ,`SchoolMiddle` = 'KRIMMEL INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Willow Trace' ,`TaxAmount` = '' ,`TaxRate` = '2.87' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675172030' WHERE `Matrix_Unique_ID` = '211109149' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-16T10:35:13.533' ,`MLSNumber` = '58098536' ,`ListAgentFullName` = 'Gil McCollin' ,`ListOfficeName` = 'RE/MAX Universal Northwest' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.563467' ,`Longitude` = '-95.728810' ,`PhotoCount` = '49' ,`PostalCode` = '77469' ,`RoomCount` = '5' ,`ListPrice` = '599900.00' ,`Status` = 'Active' ,`StreetName` = 'Donna Temple' ,`StreetNumber` = '1930' ,`StreetSuffix` = 'Court' ,`City` = 'Richmond' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3758' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful two story open concept home with bright windows. Seller owner solar panels for reduced electrical utility costs. Open park directly in front of the home. Large primary bedroom with crown molding. Primary includes dual vanities, garden soaking tub and separate shower. Gourmet kitchen has granite counter tops, stainless steel appliances with dual ovens and a wonderful bold backsplash deign. The kitchen also highlights a gas cooktop with a pot filler. Open game room upstairs and a dedicated media room. A Jack and Jill bathroom on the second floor connects two of the bedrooms with separate vanities. Dual home with full kitchen, living area, bedroom and bath with separate private entrance. No front or rear neighbors. Large spacious back yard to accommodate a big pool and outdoor entertainment space. Kids playground short walking distance. Oversized 4 car garage. Ulta filtration 3 stage water filter system. The seller is the related nephew of the representing real estate agent.' ,`Acres` = '0.275' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'VERANDA SEC 7, BLOCK 1, LOT 12' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '12021' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1095' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'PHELAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR CONSOLIDATED HIGH SCHOOL' ,`SchoolMiddle` = 'WESSENDORF/LAMAR JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Veranda Sec 7' ,`TaxAmount` = '14155' ,`TaxRate` = '3.1798' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1675172030' WHERE `Matrix_Unique_ID` = '211210731' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-16T10:23:57.683' ,`MLSNumber` = '32814567' ,`ListAgentFullName` = 'Adam Olsen' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.399247' ,`Longitude` = '-95.549940' ,`PhotoCount` = '39' ,`PostalCode` = '77318' ,`RoomCount` = '7' ,`ListPrice` = '399900.00' ,`Status` = 'Active' ,`StreetName` = 'Lake Mist' ,`StreetNumber` = '10768' ,`StreetSuffix` = 'Lane' ,`City` = 'Willis' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1860' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Newly built by LevelTX, located on Lake Conroe, this stunning 3 bed, 2.5 bath 2-story home is sure to provide the most exquisite water views! Boasting 1,860 square feet of living space, this home features soaring high ceilings, elegant wood finishes, an oversized gourmet kitchen, game room, and generously sized bedrooms and utility room. The kitchen flaunts sleek modern cabinetry and pendant lighting, large island, granite countertops, a gas range, a walk-in pantry and opens up to the family and dining area creating a masterfully planned open concept. The primary boasts a private en-suite bath flaunting tile flooring, dual vanities, a separate shower + stand alone tub, and a massive walk-in closet. Exterior features include an attached 2-car garage, access to Lake Conroe, an area pool, and SO much more! Schedule a private tour today!' ,`Acres` = '0.126' ,`Area` = '39' ,`BuilderName` = 'Level TX' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S654502 - Lake Breeze 02, BLOCK 2, Lot 7' ,`LotDesciption` = 'Cleared,Subdivision Lot,Water View' ,`LotSize` = '5516' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'LAGWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERT P. BRABHAM MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Lake Breeze 02' ,`TaxAmount` = '1018' ,`TaxRate` = '2.5148' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675172030' WHERE `Matrix_Unique_ID` = '212251127' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-16T09:03:22.210' ,`MLSNumber` = '60675940' ,`ListAgentFullName` = 'Pat Bean' ,`ListOfficeName` = 'RE/MAX Suburbia' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.635675' ,`Longitude` = '-95.200221' ,`PhotoCount` = '27' ,`PostalCode` = '77504' ,`RoomCount` = '5' ,`ListPrice` = '297000.00' ,`Status` = 'Active' ,`StreetName` = 'Winding' ,`StreetNumber` = '733' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1812' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Two Homes, Workshop & Land! A diamond in the rough. The main home is 3 bedroom 1 bath indoor utility room, A very nice family room with beautiful built-ins, There are 3 additional areas attached to home that were workshops. There is a 25x40 metal shop (estimated) w/cement floor and electricity. The second home has 2 bedrooms 1 bath and a detached garage. Both homes need work but so much potential. There are Pecan, Oak and Sycamore trees on the property. Some tree\'s are 70+ years old.' ,`Acres` = '1.5997' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate,No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Southbelt/Ellington' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TRS 7B & 7C HIGHLAND ACRES' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '69682' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'YOUNG ELEMENTARY SCHOOL (PASADENA)' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (PASADENA)' ,`SchoolMiddle` = 'MILLER INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Highland Acres' ,`TaxAmount` = '5373' ,`TaxRate` = '2.6863' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1957' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675172031' WHERE `Matrix_Unique_ID` = '212521337' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-16T09:16:35.387' ,`MLSNumber` = '93297527' ,`ListAgentFullName` = 'Tanisha McCambry' ,`ListOfficeName` = 'MV Realty Of Texas LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.982233' ,`Longitude` = '-95.695789' ,`PhotoCount` = '20' ,`PostalCode` = '77429' ,`RoomCount` = '6' ,`ListPrice` = '320000.00' ,`Status` = 'Active' ,`StreetName` = 'Rose Hill Park' ,`StreetNumber` = '17947' ,`StreetSuffix` = 'Lane' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2030' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A MUST SEE WILL NOT LAST LONG! Convenient to Grand Parkway and 290, with access to shopping, restaurants and amenities! HUGE master bedroom with attached bath with dual vanities! 2 additional bedrooms plus a loft space upstairs. Downstairs is a private study, open concept kitchen, breakfast room and family room with fireplace. Outside in the backyard is a HUGE covered porch with two ceiling fans to keep the breeze blowing on those hot summer nights. Private backyard with no back neighbors!' ,`Acres` = '0.1377' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure,Tenant Occupied' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 21 BLK 6 CYPRESS MILL PARK SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'A ROBISON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS WOODS HIGH SCHOOL' ,`SchoolMiddle` = 'SPILLANE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Split Level' ,`Subdivision` = 'Cypress Mill Park Sec 02' ,`TaxAmount` = '6059' ,`TaxRate` = '2.761' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1675172031' WHERE `Matrix_Unique_ID` = '212846930' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-16T09:04:26.310' ,`MLSNumber` = '39414288' ,`ListAgentFullName` = 'Lisa Lang' ,`ListOfficeName` = 'State 28 Real Estate, PLLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.374053' ,`Longitude` = '-95.494068' ,`PhotoCount` = '22' ,`PostalCode` = '77304' ,`RoomCount` = '6' ,`ListPrice` = '224900.00' ,`Status` = 'Active' ,`StreetName` = 'Mid Pines' ,`StreetNumber` = '167' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '2' ,`SqFtTotal` = '1344' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A great 2 bedroom in City of Panorama Village, a block from golf course. Corner lot across from park. Vaulted ceiling in LR/DR area. Beautiful mirrored built-ins on either side of brick fireplace w/gas logs. Two Bedrooms w/walk-in closets & Hollywood Bath. Master bedroom has two closets. Separate utility room w/storage inside house. Private covered patio/deck. Panorama Village is conveniently located just minutes from I-45 w/amenities: 27-hole Golf Course, clubhouse, swimming pool, 3 parks, + Pavilion. NO HOA FEES !!! NO MUD TAX !!! MUST SEE !!!' ,`Acres` = '0.1492' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'Lot 167 Panorama Village' ,`LotDesciption` = 'Corner,In Golf Course Community' ,`LotSize` = '6500' ,`LotSizeSource` = 'Unknown' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'LAGWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERT P. BRABHAM MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Panorama Village' ,`TaxAmount` = '3015' ,`TaxRate` = '2.4982' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1976' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1675172031' WHERE `Matrix_Unique_ID` = '213080723' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-16T10:44:52.823' ,`MLSNumber` = '17595560' ,`ListAgentFullName` = 'Gabriela Hagler' ,`ListOfficeName` = 'AIM Commercial Brokerage' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.502006' ,`Longitude` = '-98.296249' ,`PhotoCount` = '30' ,`PostalCode` = '78109' ,`RoomCount` = '6' ,`ListPrice` = '265000.00' ,`Status` = 'Active' ,`StreetName` = 'Copper' ,`StreetNumber` = '7611' ,`StreetSuffix` = 'Lake' ,`City` = 'Converse' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1402' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'ATTENTION INVESTORS!!! TENANT OCCUPIED CASH FLOW RENTAL! Bright and inviting, open-concept 3/2/2 in the heart of Copperfield! Built to enjoy, this perfectly appointed home has a large patio (by builder) great for entertaining in style, plus chic bay window, vaulted ceilings, 6 panel (builder\'s gold package) premium doors, two-inch faux wood blinds throughout, pre-wire for security, radiant barrier, double pane windows, ceiling fans, and high SEER HVAC for energy efficiency. Come check out the awesome Primary Bedroom with walk-in closet and private ensuite featuring relaxing Garden Tub! What else could you ask for in an OPEN CONCEPT FLOORPLAN WITH EXCELLENT CURB APPEAL with ABUNDANT ENTERTAINING OPTIONS - INDOOR AND OUTDOOR, under 1500SF?! All within close proximity to main thoroughfares, with easy access to Loop 1604, and I-35, Randolph AFB, shopping and schools! *all information should be verified by buyer' ,`Acres` = '0.1291' ,`Area` = '83' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'CB 5069B (MEADOWS OF COPPERFIELD UT-4), BLOCK 14 LOT 25 PLAT' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5624' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '135' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '634 - Judson' ,`SchoolElementary` = 'RICARDO SALINAS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'JUDSON HIGH SCHOOL' ,`SchoolMiddle` = 'KITTY HAWK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Back,Lockbox Front,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Meadows Of Copperfield Ut-4' ,`TaxAmount` = '5094' ,`TaxRate` = '2.4938' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2009' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675172031' WHERE `Matrix_Unique_ID` = '213677653' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-16T10:12:29.073' ,`MLSNumber` = '93697271' ,`ListAgentFullName` = 'Dan McCarver' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.504033' ,`Longitude` = '-95.010331' ,`PhotoCount` = '50' ,`PostalCode` = '77573' ,`RoomCount` = '10' ,`ListPrice` = '834950.00' ,`Status` = 'Act