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-15T08:59:29.457' ,`MLSNumber` = '36159537' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Long Lake LTD' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.210371' ,`Longitude` = '-95.426846' ,`PhotoCount` = '17' ,`PostalCode` = '77385' ,`RoomCount` = '13' ,`ListPrice` = '429990.00' ,`Status` = 'Active' ,`StreetName` = 'Climbing Tree' ,`StreetNumber` = '9874' ,`StreetSuffix` = 'Street' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2700' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home is under construction. Create unforgettable moments in this Lake Ridge Builders home in Montgomery Creek Ranch. Nestled on a cul-de-sac street and lacking back neighbors, this 3-sided brick home boasts a premium elevation, no back neighbors, tile flooring, wrought iron spindles, faux wood blinds, and a covered patio. Cook up new cuisines in the kitchen, equipped with granite countertops, tile backsplash, stainless steel appliances, and 42” cabinets. The serene primary suite features dual vanities, a 42” tub, and a separate shower. The community of Montgomery Creek Ranch is only a short distance away from a variety of shopping, dining, and entertainment options at The Woodlands Mall, Cynthia Woods Mitchell Pavilion, and Market Street. Students are zoned to the highly acclaimed Conroe ISD. Call now to arrange your private showing!' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'Lake Ridge Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 16 Block 1' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '266' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'SUCHMA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'OAK RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'IRONS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Montgomery Creek Ranch' ,`TaxAmount` = '' ,`TaxRate` = '2.75' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663698903' WHERE `Matrix_Unique_ID` = '206348222' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T08:58:56.057' ,`MLSNumber` = '67306686' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Long Lake LTD' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.210371' ,`Longitude` = '-95.426846' ,`PhotoCount` = '28' ,`PostalCode` = '77385' ,`RoomCount` = '9' ,`ListPrice` = '339990.00' ,`Status` = 'Active' ,`StreetName` = 'Brambling' ,`StreetNumber` = '2219' ,`StreetSuffix` = 'Lane' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1400' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home is under construction. Settle into this charming Foxwood Builders home in Montgomery Creek Ranch. Situated on a cul-de-sac street, this 3-sided brick home boasts faux wood blinds, dual vanities in the primary suite paired with an oversized shower, and a covered patio. Whip up meals for guests in the island kitchen, equipped with upgraded granite countertops, tile backsplash, stainless steel appliances, and 30” cabinets. The community of Montgomery Creek Ranch is only a short distance away from a variety of shopping, dining, and entertainment options at The Woodlands Mall, Cynthia Woods Mitchell Pavilion, and Market Street. Students are zoned to the acclaimed Conroe ISD. Call now to arrange your private showing!' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'Foxwood Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 9 Block 2' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '266' ,`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` = '11 - Conroe' ,`SchoolElementary` = 'SUCHMA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'OAK RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'IRONS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Montgomery Creek Ranch' ,`TaxAmount` = '' ,`TaxRate` = '2.75' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663698903' WHERE `Matrix_Unique_ID` = '206693821' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T09:03:39.547' ,`MLSNumber` = '17850564' ,`ListAgentFullName` = 'Jodi Kallus' ,`ListOfficeName` = 'Summit, Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.614604' ,`Longitude` = '-95.366575' ,`PhotoCount` = '16' ,`PostalCode` = '77047' ,`RoomCount` = '4' ,`ListPrice` = '195000.00' ,`Status` = 'Active' ,`StreetName` = 'Murdock' ,`StreetNumber` = '3525' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '672' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Act Fast to have Your Piece of this Rapidly Growing Part of Town Before Prices Go up More. Lots of New Development in the Area and on the Street. This 2 Bedroom, 1 Bath Home sits on a Huge Lot. With Some Tender Loving Care this House can be a Home, a Rental or a Tear Down to Maximize your Income Potential with Multiple Homes or Duplexes. The Possibilities are Endless. Perfect Location for those Commuting to Medical Center or Downtown Houston. Don\'t Let this Opportunity Pass you By.' ,`Acres` = '0.2459' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Medical Center South' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LT 26 BLK 3 HOLLOWAY HEIGHTS SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10710' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LAW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WORTHING HIGH SCHOOL' ,`SchoolMiddle` = 'THOMAS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Holloway Heights 1' ,`TaxAmount` = '780' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663698903' WHERE `Matrix_Unique_ID` = '206761228' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T09:18:03.840' ,`MLSNumber` = '50519908' ,`ListAgentFullName` = 'Raul Gonzalez' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.962590' ,`Longitude` = '-95.272180' ,`PhotoCount` = '30' ,`PostalCode` = '77541' ,`RoomCount` = '4' ,`ListPrice` = '710000.00' ,`Status` = 'Active' ,`StreetName` = 'Yucca' ,`StreetNumber` = '111' ,`StreetSuffix` = 'Avenue' ,`City` = 'Surfside Beach' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1792' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This rare find offers gorgeous unobstructed views of the beach, and ocean from two levels of balconies! Downstairs you will notice a private outdoor shower, as well as a storage shed. Oceanfront location allows for beach days within minutes of your front door. The beach is less than 50 steps away via the street, so no need to trek through sand dunes! Upon entry you be welcomed into a foyer with built in cabinetry that blends very tastefully into the layout. To your right there is a beautiful staircase that leads to the dining, living, and kitchen areas. This level of the home is a dream for entertaining guests with it\'s open concept, and abundance of natural light. There is one bedroom, and bathroom on the second floor. The remaining rooms are past the foyer on the first floor, along with an indoor laundry area. Great opportunity for a vacation rental, or full time residence. Rental history is available upon request. CALL TODAY TO SCHEDULE YOUR APPOINTMENT!!' ,`Acres` = '0.0803' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Surfside' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'YUCCA (A0009 B T ARCHER DIV 1 (B C I C)(SURFSIDE) LOT 20' ,`LotDesciption` = 'Cleared,Water View,Waterfront' ,`LotSize` = '3498' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'FLEMING ELEMENTARY SCHOOL (BRAZOSPORT)' ,`SchoolHigh` = 'BRAZOSPORT HIGH SCHOOL' ,`SchoolMiddle` = 'FREEPORT INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Yucca' ,`TaxAmount` = '11539' ,`TaxRate` = '2.33297' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663698903' WHERE `Matrix_Unique_ID` = '207421767' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T08:56:06.787' ,`MLSNumber` = '54659172' ,`ListAgentFullName` = 'Norma Smalley' ,`ListOfficeName` = 'Cobb Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.446139' ,`Longitude` = '-94.656333' ,`PhotoCount` = '43' ,`PostalCode` = '77650' ,`RoomCount` = '5' ,`ListPrice` = '590000.00' ,`Status` = 'Active' ,`StreetName` = 'Gulfview' ,`StreetNumber` = '970' ,`StreetSuffix` = 'Drive' ,`City` = 'Crystal Beach' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1858' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Seller is negotiable! A gorgeous beach getaway. This home boasts a large, open living space with lots of natural light and high ceilings. Great for family and friends enjoying the beach. A bright kitchen with plenty of counter space. Three spacious bedrooms and two and a half bathrooms offer the perfect space for a family vacation. The outside of the home is just as accommodating with a cargo lift, a bar area, and multiple decks for outdoor entertainment! The lot is fully fenced with a gate across the driveway. The beach is just a short golf cart ride away. The roof was replaced in 2021. All room dimensions will need to be verified.' ,`Acres` = '0.1263' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Crystal Beach' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 179 J SHAW SUR LOT 320 EMERALD BEACH' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '5500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Emerald Beach' ,`TaxAmount` = '5122' ,`TaxRate` = '1.6103' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663698903' WHERE `Matrix_Unique_ID` = '210239651' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T09:43:56.570' ,`MLSNumber` = '16160486' ,`ListAgentFullName` = 'Dayna Simmons' ,`ListOfficeName` = 'Dayna Simmons Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.103180' ,`Longitude` = '-94.153516' ,`PhotoCount` = '27' ,`PostalCode` = '77706' ,`RoomCount` = '11' ,`ListPrice` = '479900.00' ,`Status` = 'Active' ,`StreetName` = 'Summerwood St' ,`StreetNumber` = '280' ,`StreetSuffix` = '' ,`City` = 'Beaumont' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '4239' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning home situated in sought after West End Beaumont. This property’s central location near local restaurants, shopping centers, and hospitals makes it the perfect place to call home. Guests are greeted with a cobble stone circle driveway and beautiful exterior. Step inside and marvel at the high ceilings adorned with crown molding, unique wallpaper, and solid wood doors throughout. Natural light pours in through the abundance of large windows with views of the backyard and courtyards. Elegant rooms create comfortable retreats from the exquisite master suite to the enchanting back patio. From the whole-house generator to the common area swimming pool and tennis court, this home has all the bells and whistles. Call us today to make this house your home.' ,`Acres` = '0.2336' ,`Area` = '51' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'SUMMERWOOD SEC 2 L9 & 10 BLK3 TR 2 UND 1.57/30TH INT IN COMM' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10175' ,`LotSizeSource` = 'Unknown' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1800' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '143 - Beaumont' ,`SchoolElementary` = 'REGINAL-HOWELL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WEST BROOK HIGH SCHOOL' ,`SchoolMiddle` = 'MARSHALL MIDDLE SCHOOL (BEAUMONT)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Summerwood' ,`TaxAmount` = '14508' ,`TaxRate` = '2.645' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663698903' WHERE `Matrix_Unique_ID` = '210493409' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T09:03:43.387' ,`MLSNumber` = '34070115' ,`ListAgentFullName` = 'Linda Riddle' ,`ListOfficeName` = 'Team Riddle Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.496773' ,`Longitude` = '-95.540827' ,`PhotoCount` = '46' ,`PostalCode` = '77459' ,`RoomCount` = '14' ,`ListPrice` = '599989.00' ,`Status` = 'Active' ,`StreetName` = 'Saint Charles' ,`StreetNumber` = '3306' ,`StreetSuffix` = 'Court' ,`City` = 'Missouri City' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4190' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this Amazing Highland Home located in the Golf Course Community of Sienna! Sitting on the 13th Green this Home is Spectacular, Greeted with Beautiful Hardwood Flooring, Plantation Shutters, & Custom Paint, Family Room with lots of Windows, Stone Fireplace and Custom Built-in Cabinets and Bar, Gourmet Kitchen with Upgraded Granite, Cabinets, and Appliances, GAS Stove-top & Warming Drawer!LG Breakfast Area & Breakfast Bar, Formal Dining Room, Living Room, FIRST Floor guest suite with Shower (Handicap accessible) Primary Bedroom Suite & Spa-like Bath, Oversized Shower,Tub & Upgraded Counters,5 1/4\" Baseboards, 8 Ft doors on 1st Floor, Large Secondary bedrooms & Bathrooms on 2nd floor, Media RM, Game RM with an extended Balcony with the most Amazing view! The Backyard Space offers an Extended Patio, Built-in Prep Station with sink, Counters and Storage, GAS Ready, Lush Landscaping, and a Beautiful View of the Golf Course! Call us TODAY, Walking Distance to CAMP SIENNA! LETS PLAY' ,`Acres` = '0.1883' ,`Area` = '38' ,`BuilderName` = 'Highland' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Levee District,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SIENNA VILLAGE OF WATERS LAKE SEC 26-B, BLOCK 2, LOT 18' ,`LotDesciption` = 'In Golf Course Community,On Golf Course,Subdivision Lot' ,`LotSize` = '8203' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1307' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'SCANLAN OAKS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Leave Business Card,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sienna' ,`TaxAmount` = '10982' ,`TaxRate` = '2.6079' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663698903' WHERE `Matrix_Unique_ID` = '210805821' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T09:48:00.470' ,`MLSNumber` = '69468069' ,`ListAgentFullName` = 'Elpidia Orantes' ,`ListOfficeName` = 'Keller Williams Platinum' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.774835' ,`Longitude` = '-95.424778' ,`PhotoCount` = '8' ,`PostalCode` = '77007' ,`RoomCount` = '4' ,`ListPrice` = '385000.00' ,`Status` = 'Active' ,`StreetName` = 'Tyne' ,`StreetNumber` = '6126' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1430' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NO SHOWINGS!!! This property is Being sold as is. Lot value only. Sale cash or investors only.' ,`Acres` = '0.092' ,`Area` = '16' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Rice Military/Washington Corridor' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = 'TR 13 BLK 9 ADAM CLAY SEC 2' ,`LotDesciption` = 'Corner' ,`LotSize` = '4008' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'MEMORIAL ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'No Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Adam Clay Sec 02' ,`TaxAmount` = '7150' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1927' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663698903' WHERE `Matrix_Unique_ID` = '210884398' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T09:18:13.323' ,`MLSNumber` = '35911367' ,`ListAgentFullName` = 'Donna Pinon' ,`ListOfficeName` = 'White Ivy Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.892839' ,`Longitude` = '-95.345635' ,`PhotoCount` = '50' ,`PostalCode` = '75862' ,`RoomCount` = '9' ,`ListPrice` = '199900.00' ,`Status` = 'Active' ,`StreetName` = 'Hackberry' ,`StreetNumber` = '284' ,`StreetSuffix` = 'Street' ,`City` = 'Trinity' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1920' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Trinity River Home! This four bedroom / three bath brick home is on a double lot overlooking the Trinity River. If you\'re looking for a property with plenty of room, this might be the one for you. The property is just under a half-acre in size and has some frontage along the water. Boasting a park-like atmosphere with mature trees, this property gently slopes down to the river\'s edge; the hilltop views are lovely. The home features a very open floor plan on the ground floor. The formal living offers a wood-burning fireplace; the den has an area for kitchenette; both open onto covered patios overlooking the water. There is 1 bedroom & full bath on the main floor; additional 3 bedrooms and 2 full baths are upstairs. Right next door is the subdivision park so no worries about neighbors building too close there. Subdivision swimming pool and boat ramp are conveniently located nearby.' ,`Acres` = '0.4866' ,`Area` = '42' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '1' ,`Legal` = 'PINECREST ESTATES SECTION A, BLOCK 15 LOT 34, 35' ,`LotDesciption` = 'Subdivision Lot,Water View,Waterfront' ,`LotSize` = '21196' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '63 - Trinity' ,`SchoolElementary` = 'LANSBERRY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TRINITY HIGH SCHOOL (HEB)' ,`SchoolMiddle` = 'TRINITY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Ranch' ,`Subdivision` = 'Pinecrest Estate Sec A' ,`TaxAmount` = '2484' ,`TaxRate` = '1.8863' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663698904' WHERE `Matrix_Unique_ID` = '210918799' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T09:44:00.190' ,`MLSNumber` = '64759500' ,`ListAgentFullName` = 'Christopher Raines' ,`ListOfficeName` = 'Texas Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.748021' ,`Longitude` = '-95.830811' ,`PhotoCount` = '32' ,`PostalCode` = '77494' ,`RoomCount` = '9' ,`ListPrice` = '699999.00' ,`Status` = 'Active' ,`StreetName` = 'Willow' ,`StreetNumber` = '26602' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2854' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NO RESTRICTIONS, COMMERCIAL OR RESIDENTIAL, Gorgeous 1.5 story ranch style home in the heart of the 77494, area of great growth and development... NO HOA! NO MUD! LOW TAXES!... Remodeled exterior and interior doors, windows, floors, SS appliances, paint, light fixtures, hardware, gutters, exterior stucco, A/C 2015. Extra large balcony with exterior spiral staircase. 2 car garage with attached extra large carport and bathroom. Beautiful large oak and pecan trees.' ,`Acres` = '1.028' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = '0157 JAS CONNER, TRACT 3 (PT), ACRES 1.028, (TR 20, 21)' ,`LotDesciption` = 'Other' ,`LotSize` = '44780' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'WOODCREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMPKINS HIGH SCHOOL' ,`SchoolMiddle` = 'TAYS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Jas Conner' ,`TaxAmount` = '9614' ,`TaxRate` = '1.9045' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1976' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663698904' WHERE `Matrix_Unique_ID` = '210987479' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T09:45:08.250' ,`MLSNumber` = '28472932' ,`ListAgentFullName` = 'Jonathan Williamson' ,`ListOfficeName` = 'Martha Turner Sotheby\'s International Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.767548' ,`Longitude` = '-95.334539' ,`PhotoCount` = '32' ,`PostalCode` = '77020' ,`RoomCount` = '6' ,`ListPrice` = '429000.00' ,`Status` = 'Active' ,`StreetName` = 'Cage' ,`StreetNumber` = '612' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2168' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Blocks from the hottest new multi-use development on the East Side, the East River Project. This home has multiple balconies, a 2-car garage with finished walls, and extra storage space. Abundant street parking. Current short-term rental inside a 3-home gated enclave. All three homes are also for sale as an income-producing investment.' ,`Acres` = '' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Denver Harbor' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 3 BLK 1 CAGE STREET COURT' ,`LotDesciption` = 'Patio Lot,Subdivision Lot' ,`LotSize` = '1833' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BRUCE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WHEATLEY HIGH SCHOOL' ,`SchoolMiddle` = 'MCREYNOLDS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Cage Street Court' ,`TaxAmount` = '7505' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663698904' WHERE `Matrix_Unique_ID` = '211011151' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T09:16:15.347' ,`MLSNumber` = '29514039' ,`ListAgentFullName` = 'Stephen Shepheard' ,`ListOfficeName` = 'RE/MAX Leading Edge' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.197430' ,`Longitude` = '-94.947402' ,`PhotoCount` = '50' ,`PostalCode` = '77554' ,`RoomCount` = '10' ,`ListPrice` = '2249000.00' ,`Status` = 'Active' ,`StreetName` = 'Swashbuckle' ,`StreetNumber` = '4215' ,`StreetSuffix` = '' ,`City` = 'Galveston' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4768' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully maintained, custom built home 3 rows from the beach, built by Alta Vista! Details abound from Brazilian hardwood decks, to circular stairway & enormous rooms, each with a water view. Hardwood floors (2009) flow thru the 1st floor living areas with Travertine (2017) in the kitchen. Chef\'s kitchen offers stainless appliances to include a Thermador double oven gas range w/pot filler above, warming drawer, built-in microwave & side by side refrigerator/freezer. Wet bar W/wine chiller & ice-maker in Dining Room. Bonus rooms include office/study with wall of built-ins, 2nd living room with wet bar & pool table & 2nd floor office area. 5th bedroom (currently used for exercise) has a closet plumbed for 5th bathroom. Elevator to all 3 levels. Exterior painted & recessed lighting replaced & solar panel system installed 2021. See attached list of all recent repairs/improvements. See links for all pictures & 3D Matterport tour of home. All furnishings convey except 2 safes in garage.' ,`Acres` = '0.3283' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'West End' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 121 PAGE 41 LOT 9 BLK 1 PIRATES BEACH SEC 10' ,`LotDesciption` = 'Water View' ,`LotSize` = '14300' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '395' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Pirates Beach Sec 10 91' ,`TaxAmount` = '26456' ,`TaxRate` = '2.0324' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663698904' WHERE `Matrix_Unique_ID` = '211020276' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T09:15:33.150' ,`MLSNumber` = '13783396' ,`ListAgentFullName` = 'Stephen Shepheard' ,`ListOfficeName` = 'RE/MAX Leading Edge' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.296330' ,`Longitude` = '-94.785209' ,`PhotoCount` = '9' ,`PostalCode` = '77550' ,`RoomCount` = '5' ,`ListPrice` = '375000.00' ,`Status` = 'Active' ,`StreetName` = 'Avenue N 1/2' ,`StreetNumber` = '1818' ,`StreetSuffix` = '' ,`City` = 'Galveston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '3618' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Classical Galveston-raised home with dormers and Amazing Bones! This home has original, large windows with lots of light, high ceilings and large rooms. This would make an incredible 4 bedroom-potentially 3 bath family home upstairs, with two 1 Bedroom-1 Bath apartments downstairs. Yes, It Needs Wiring, Plumbing, Structural Adjustment, New Siding, New Kitchens & Baths; however, once done, this could be historically glorious. Do Not Enter this Home/Property without an appointment and Must Be Accompanied By a Licensed Realtor. With renovations that were started, parts of this building are Not Safe. Adults Only with proper footwear and Exercise Extreme Caution. No Exceptions! Home Was Not Built in 1960, believed to be a 1900 Storm Survivor. Cash Sale!' ,`Acres` = '0.1185' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'East End' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 628 M B MENARD SUR LOT 12 NW BLK 45 GALVESTON OUTLOTS' ,`LotDesciption` = 'Other' ,`LotSize` = '5160' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`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,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Other Style' ,`Subdivision` = 'Galveston Outlots' ,`TaxAmount` = '5000' ,`TaxRate` = '2.0662' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663698904' WHERE `Matrix_Unique_ID` = '211101153' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T09:59:54.523' ,`MLSNumber` = '10895157' ,`ListAgentFullName` = 'Miguel Cruz' ,`ListOfficeName` = 'RE/MAX Prestige' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.978502' ,`Longitude` = '-95.458924' ,`PhotoCount` = '41' ,`PostalCode` = '77014' ,`RoomCount` = '7' ,`ListPrice` = '299990.00' ,`Status` = 'Active' ,`StreetName` = 'Cobbdale' ,`StreetNumber` = '2402' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1890' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This is a great home with lots of space and tons of upgrades, you won\'t be disappointed. Features: 3/2/2, plus a study with a closet that could easily be turned into a fourth bedroom, and master bedroom is very spacious. Kitchen island, granite on all counter tops, mini fridge in island, House has been pre-wired for an alarm system, smart features throughout home, Eve lights, door lock, thermostat and sprinkler system all can be controlled by phone. Gas burning fireplace, ceiling fans, walk-in-closet, double sinks, jet garden tub and separate shower. Out side you have a covered patio with built-in speakers that you can kick back and relax' ,`Acres` = '0.1473' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '1960/Cypress Creek South' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 28 BLK 4 SILVERGLEN NORTH SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6416' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '583' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'DELORAS E THOMPSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTFIELD HIGH SCHOOL' ,`SchoolMiddle` = 'STELLE CLAUGHTON MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Silverglen North Sec 05' ,`TaxAmount` = '5661' ,`TaxRate` = '2.8867' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663698904' WHERE `Matrix_Unique_ID` = '211173758' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T09:51:38.113' ,`MLSNumber` = '71828709' ,`ListAgentFullName` = 'David Montalvo' ,`ListOfficeName` = 'Homelister, Inc' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.107045' ,`Longitude` = '-96.232576' ,`PhotoCount` = '13' ,`PostalCode` = '77426' ,`RoomCount` = '5' ,`ListPrice` = '725000.00' ,`Status` = 'Active' ,`StreetName` = 'Fm 1371' ,`StreetNumber` = '11750' ,`StreetSuffix` = '' ,`City` = 'Chappell Hill' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2111' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful and spacious 3 bedroom and 21/2 bath house on over 6.5 acres with a large pond. Easy access to 290 yet still very much a ranch style/country home.' ,`Acres` = '6.888' ,`Area` = '58' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'A0071 KUYKENDALL, GIBSON, TRACT 162, ACRES 1.00' ,`LotDesciption` = 'Other' ,`LotSize` = '' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '137 - Brenham' ,`SchoolElementary` = 'BISD DRAW' ,`SchoolHigh` = 'BRENHAM HIGH SCHOOL' ,`SchoolMiddle` = 'BRENHAM JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Call Occupant' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'None' ,`TaxAmount` = '2592' ,`TaxRate` = '1.5429' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '1984' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663698904' WHERE `Matrix_Unique_ID` = '211305248' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T09:31:22.300' ,`MLSNumber` = '29890833' ,`ListAgentFullName` = 'Edward McClintick' ,`ListOfficeName` = 'Joseph Walter Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.049796' ,`Longitude` = '-94.091409' ,`PhotoCount` = '8' ,`PostalCode` = '77705' ,`RoomCount` = '9' ,`ListPrice` = '105000.00' ,`Status` = 'Active' ,`StreetName` = 'Fonville' ,`StreetNumber` = '3745' ,`StreetSuffix` = 'Avenue' ,`City` = 'Beaumont' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2030' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'AMAZING INVESTMENT OPPORTUNITY!! 1,040 SQFT LIVING SQFT 0.25 ACRES LOT SIZE!!!!' ,`Acres` = '0.3214' ,`Area` = '51' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'JEF CHAISON 2ND L4 & 5 B54' ,`LotDesciption` = 'Other' ,`LotSize` = '14000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '143 - Beaumont' ,`SchoolElementary` = 'PIETZSCH-MACARTHUR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BEAUMONT UNITED HIGH SCHOOL' ,`SchoolMiddle` = 'KING MIDDLE SCHOOL (BEAUMONT)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Other Style' ,`Subdivision` = 'Jef Chaison Add 02' ,`TaxAmount` = '1770' ,`TaxRate` = '2.645' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '1962' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663698905' WHERE `Matrix_Unique_ID` = '211423558' --> Updated record success