Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-24T14:08:11.553' ,`MLSNumber` = '10831050' ,`ListAgentFullName` = 'Delilah McKenna' ,`ListOfficeName` = 'McKenna Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.812015' ,`Longitude` = '-95.395001' ,`PhotoCount` = '25' ,`PostalCode` = '77008' ,`RoomCount` = '4' ,`ListPrice` = '491900.00' ,`Status` = 'Active' ,`StreetName` = '28th' ,`StreetNumber` = '328' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1074' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully preserved and restored 1940\'s Craftsman style Bungalow in Sunset Heights on 6000 sf lot. Original hardwood floors. Fully fenced yard (front and back). All new bath and updated kitchen. All new windows! Good closet space. Huge new walk-in shower. Custom, locally built, double vanities in the new bath. Recent brick walkway, stairs, and front porch. NEW HVAC in Nov 2022. Huge, fenced backyard is great for dogs and kids--or future additions, a pool, etc. Attached garage. Nice, quiet Sunset Heights location inside the loop and close to all the Heights food, drink, shopping, entertainment, grocery, etc. Nice screened-in porches (front and back) are a must in the south and are fantastic for entertaining and dining al fresco. You won\'t find another place quite like this one on the (very short) list of original single family houses available in this entire area. This is a beautiful, well-maintained property. Call or text with questions or to schedule a showing appointment.' ,`Acres` = '0.1377' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 13 & 14 BLK 18 SUNSET HEIGHTS' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Convection Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HELMS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Craftsman,Traditional' ,`Subdivision` = 'Sunset Heights' ,`TaxAmount` = '7943' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1940' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642060' WHERE `Matrix_Unique_ID` = '210244838' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-24T13:17:12.013' ,`MLSNumber` = '12019476' ,`ListAgentFullName` = 'Cody Empert' ,`ListOfficeName` = 'Coldwell Banker Ultimate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.090053' ,`Longitude` = '-95.358792' ,`PhotoCount` = '36' ,`PostalCode` = '77386' ,`RoomCount` = '15' ,`ListPrice` = '1199350.00' ,`Status` = 'Active' ,`StreetName` = 'Rondelet' ,`StreetNumber` = '4030' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4150' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come and check out this house before it goes off market!!!!!!!!This exquisitely built custom 5-bedroom, 4.5-bathroom house on a corner lot with just over an acre is located in the sought-after neighborhood of Bender’s Landing! As you enter the large wrought iron front doors, you will find yourself in the courtyard that is perfect for entertaining. Off the courtyard, separate from the main house, is a casita that can be used as a mother-in-law suite or a future pool house. The kitchen of the main house includes top-of-the-line Viking appliances accompanied by a large walk-in pantry. Animal lovers will also love the dog wash area in the laundry room. If you work at home, the spacious office is the perfect place to work. After work, you can walk into the oversized master bedroom that boasts his and hers closets or to the master bathroom to relax in your large soaking tub. Upstairs you will find three beautiful bedrooms, one with an en-suite bathroom and all with private balconies.' ,`Acres` = '1.0646' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'BENDERS LANDING 02, BLOCK 16, LOT 24' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '46376' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'ANN K. SNYDER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GRAND OAKS HIGH SCHOOL' ,`SchoolMiddle` = 'YORK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Spanish' ,`Subdivision` = 'Benders Landing' ,`TaxAmount` = '17618' ,`TaxRate` = '1.8487' ,`WaterSewer` = 'Aerobic,Public Water' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642060' WHERE `Matrix_Unique_ID` = '211391249' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-24T14:51:23.143' ,`MLSNumber` = '32017870' ,`ListAgentFullName` = 'Aaron Cruz' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.712881' ,`Longitude` = '-95.509063' ,`PhotoCount` = '25' ,`PostalCode` = '77036' ,`RoomCount` = '6' ,`ListPrice` = '289000.00' ,`Status` = 'Active' ,`StreetName` = 'Crystal' ,`StreetNumber` = '7159' ,`StreetSuffix` = 'Way' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1648' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Nestled in a gated community is 7129 Crystal Way. Built in 2001by Windwater homes. Features include gated backyard with green space and courtyard. Three bedrooms\r\nwith high ceilings, natural light and ceiling fans in all. Full bath downstairs with tub/shower, upstairs primary bath features two vanities, separate Jacuzzi tub and walk in\r\nshower. Two ac units with split thermostats for upstairs and down, 100 year terracotta roof, two car garage. Kitchen includes granite counter tops, four burner gas cook\r\ntop stove/grill in the island. Under cabinet lighting. ( All appliance included). Open concept from the kitchen is a formal dinning room. Living room equipped with with\r\nceiling fans and recessed lighting. Utility room is on second floor with washer and dryer. Manned security gate for all visitors' ,`Acres` = '0.0345' ,`Area` = '21' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Sharpstown Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 18 BLK 2 SQUARE R/P WINDWATER VILLAGE AT REGENCY' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '1504' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '310' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Other,Tile' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'PINEY POINT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WISDOM HIGH SCHOOL' ,`SchoolMiddle` = 'REVERE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Mediterranean' ,`Subdivision` = 'Windwater Village At Regency' ,`TaxAmount` = '5111' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642061' WHERE `Matrix_Unique_ID` = '212320546' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-24T14:25:44.960' ,`MLSNumber` = '31515471' ,`ListAgentFullName` = 'Celeste Slatter' ,`ListOfficeName` = 'Pinnacle Realty Advisors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.319733' ,`Longitude` = '-95.454152' ,`PhotoCount` = '49' ,`PostalCode` = '75835' ,`RoomCount` = '10' ,`ListPrice` = '334900.00' ,`Status` = 'Active' ,`StreetName` = 'Lamar' ,`StreetNumber` = '704' ,`StreetSuffix` = 'Avenue' ,`City` = 'Crockett' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3020' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully charming 100 year old historic home downtown Crockett with 3 bedrooms & 2 baths downstairs + finished BONUS space upstairs with half bathroom. Home sits on 1/2 acre with detached garage and has been completely remodeled and updated in 2016 to include: NEW electrical, plumbing, insulation added to attic and under home; back half of home leveled; NEW flooring in kitchen and downstairs bathrooms; NEW kitchen cabinets & butcher block counters + NEW appliances (fridge, gas stove, dishwasher & microwave); NEW lighting fixtures, plumbing fixtures, interior paint, tankless water heater, HVA/C & duct work; NEW side privacy fence. In 2017, upstairs was finished out to be usable space with NEW paint on walls and floors, NEW Mitsubishi mini-split A/C & Heating, NEW fixtures and plumbing installed in half bath. NEW covered back porch added in 2017. Existing home warranty will xfer to buyer at closing with full year of coverage. Check out the 360 VR tour!' ,`Acres` = '0.5' ,`Area` = '41' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Crockett Area' ,`HeatSystem` = 'Central Electric,Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'Lot 15, Block 3, City of Crockett, .407 Acre' ,`LotDesciption` = 'Other' ,`LotSize` = '21780' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '57 - Crockett' ,`SchoolElementary` = 'CROCKETT ELEMENTARY SCHOOL (CROCKETT)' ,`SchoolHigh` = 'CROCKETT HIGH SCHOOL (CROCKETT)' ,`SchoolMiddle` = 'CROCKETT JUNIOR HIGH SCHOOL (CROCKETT)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '1.5' ,`Style` = 'Traditional,Victorian' ,`Subdivision` = 'None' ,`TaxAmount` = '2458' ,`TaxRate` = '2.3627' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1922' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642061' WHERE `Matrix_Unique_ID` = '212735771' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-24T14:26:51.397' ,`MLSNumber` = '55856363' ,`ListAgentFullName` = 'Celeste Slatter' ,`ListOfficeName` = 'Pinnacle Realty Advisors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.949857' ,`Longitude` = '-95.264034' ,`PhotoCount` = '45' ,`PostalCode` = '75862' ,`RoomCount` = '8' ,`ListPrice` = '189900.00' ,`Status` = 'Active' ,`StreetName` = 'Walnut' ,`StreetNumber` = '304' ,`StreetSuffix` = 'Drive' ,`City` = 'Trinity' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1456' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 3 bedroom/2 bath home on interior lot in The Landing on Lake Livingston! Master bedroom has wood accent wall and spacious walk-in closet + ensuite bath with separate tub and shower. Home has been completely remodeled. In 2021, Exterior: NEW roof, NEW windows, NEW siding & skirting, NEW front steps, NEW aerobic septic system, NEW HVA/C. Interior: NEW laminate flooring, NEW carpet, NEW cabinets in kitchen, living room & both bathrooms, NEW quartz countertops in kitchen & both bathrooms, NEW paint, NEW lighting, NEW plumbing fixtures; NEW exterior doors. NEW gravel driveway 2022. Existing home warranty will transfer to buyer at closing with a full year of coverage. Subdivision amenities include boat launch & fishing pier, clubhouse, and park. Low HOA fees!' ,`Acres` = '0.1928' ,`Area` = '42' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 20, Block 2, The Landing Sec 4' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '8400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '125' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '63 - Trinity' ,`SchoolElementary` = 'LANSBERRY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TRINITY HIGH SCHOOL (HEB)' ,`SchoolMiddle` = 'TRINITY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'The Landing' ,`TaxAmount` = '839' ,`TaxRate` = '1.8863' ,`WaterSewer` = 'Aerobic,Public Water' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642061' WHERE `Matrix_Unique_ID` = '212743101' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-24T13:45:05.720' ,`MLSNumber` = '56396015' ,`ListAgentFullName` = 'Christina Brewster' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.717486' ,`Longitude` = '-95.032124' ,`PhotoCount` = '50' ,`PostalCode` = '77351' ,`RoomCount` = '3' ,`ListPrice` = '330000.00' ,`Status` = 'Active' ,`StreetName` = 'Mossy' ,`StreetNumber` = '208' ,`StreetSuffix` = 'Drive' ,`City` = 'Livingston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1596' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Three story, three bd, two bath home on 2 acres surrounded by mature trees that provide privacy to the property. Just minutes from the lake! Access to a private pavilion/boat ramp 2.4 miles from Lake Livingston & 1.3 miles to Tigerville Public Park & boat ramp. No mobile homes allowed in this section. Buyer\'s agent to verify dimensions & schools. Window sticker for the private (gated) pavilion/boat ramp is currently $25.00 annually. Schedule your tour today!' ,`Acres` = '' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = '97 THR 108,110,112,113' ,`LotDesciption` = 'Corner' ,`LotSize` = '91911' ,`LotSizeSource` = 'Unknown' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '230' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '103 - Livingston' ,`SchoolElementary` = 'LISD OPEN ENROLL' ,`SchoolHigh` = 'LIVINGSTON HIGH SCHOOL' ,`SchoolMiddle` = 'LIVINGSTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Right Side' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Lakeland Hideaway' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Aerobic' ,`YearBuilt` = '1996' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642061' WHERE `Matrix_Unique_ID` = '212867334' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-24T13:21:38.203' ,`MLSNumber` = '37220703' ,`ListAgentFullName` = 'Leonel Hidalgo' ,`ListOfficeName` = 'Mark Dimas Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.294944' ,`Longitude` = '-94.799583' ,`PhotoCount` = '48' ,`PostalCode` = '77550' ,`RoomCount` = '5' ,`ListPrice` = '354990.00' ,`Status` = 'Active' ,`StreetName` = 'Avenue M' ,`StreetNumber` = '3013' ,`StreetSuffix` = '' ,`City` = 'Galveston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1860' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Amazing BEACH HOUSE just 5 minutes from the beach, this is a gem is ready to become your family\'s vacation home or a great investment for Airbnb or any other rental!' ,`Acres` = '0.0355' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'East End' ,`HeatSystem` = 'Window Unit' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 628 M B MENARD SUR PT OF LOTS 4 & 5 (4-3) NW BLK 14 GAL' ,`LotDesciption` = 'Other' ,`LotSize` = '1548' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`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` = '2' ,`Style` = 'Other Style,Traditional' ,`Subdivision` = 'Galveston Outlots' ,`TaxAmount` = '1787' ,`TaxRate` = '2.0662' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1968' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1669642062' WHERE `Matrix_Unique_ID` = '213244342' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-24T13:56:30.167' ,`MLSNumber` = '56672719' ,`ListAgentFullName` = 'Miguel Canas' ,`ListOfficeName` = 'Texas United Realty' ,`SellingAgentFullName` = 'Jason Aguirre' ,`SellingOfficeName` = 'Fathom Realty' ,`Latitude` = '29.905253' ,`Longitude` = '-95.323324' ,`PhotoCount` = '20' ,`PostalCode` = '77039' ,`RoomCount` = '5' ,`ListPrice` = '230000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Vickery' ,`StreetNumber` = '12344' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1514' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Lovely Home!!! three BR 1.5 bath, inside you will find a spacious living room plus a formal living (Den) room, tile and carpet floor, all rooms are equipped with ceiling fan, two car attached garage plus a four car cover porch, the back yard has a ample space, fully fenced with a large swimming pool that needs some TLC, \" Pool is not in working condition\". Oversized lot great for future projects with no HOA restrictions. Nicely located quick access to 59, downtown Houston and only few minutes from George Bush IAH airport!! Property never flooded by owner. Don\'t miss out-call now!!' ,`Acres` = '0.3444' ,`Area` = '34' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Aldine Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TRS 1F 1K & 1N ABST 157 S BROOKS' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '15000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'OLESON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MACARTHUR HIGH SCHOOL (ALDINE)' ,`SchoolMiddle` = 'MEAD MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'S Brooks' ,`TaxAmount` = '3085' ,`TaxRate` = '2.1553' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1964' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642062' WHERE `Matrix_Unique_ID` = '214257925' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-24T13:24:18.257' ,`MLSNumber` = '27498203' ,`ListAgentFullName` = 'Kathy Shay Watson' ,`ListOfficeName` = 'Tower Point Realty' ,`SellingAgentFullName` = 'Kathy Shay Watson' ,`SellingOfficeName` = 'Tower Point Realty' ,`Latitude` = '29.936792' ,`Longitude` = '-95.615581' ,`PhotoCount` = '27' ,`PostalCode` = '77065' ,`RoomCount` = '3' ,`ListPrice` = '249900.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Foxburo' ,`StreetNumber` = '12842' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1538' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Rare opportunity to own a great home with NO restrictions and a detached 24x30 shop! This house sits on a large lot with mature trees. The large shop has a sink and electricity with room to turn into a guest house, office, entertainment area, and still have room for a pool! Zoned to Cy-Fair ISD and Adam Elementary is in the neighborhood just blocks away, low tax rate, no HOA and close to everything including shopping, dining, Telge Park nature trails. This property has unlimited potential.' ,`Acres` = '0.233' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '1960/Cypress' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 65 BLK 9 TOWER OAKS MEADOWS SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10150' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'ADAM ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CY-FAIR HIGH SCHOOL' ,`SchoolMiddle` = 'ARNOLD MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Tower Oaks Meadows Sec 03' ,`TaxAmount` = '4111' ,`TaxRate` = '2.381' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1976' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642062' WHERE `Matrix_Unique_ID` = '214470937' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-24T13:33:14.943' ,`MLSNumber` = '61170674' ,`ListAgentFullName` = 'Gabriel Mendoza' ,`ListOfficeName` = 'Orchard Brokerage' ,`SellingAgentFullName` = 'Beth Perque' ,`SellingOfficeName` = 'RE/MAX Integrity' ,`Latitude` = '29.919812' ,`Longitude` = '-95.167966' ,`PhotoCount` = '36' ,`PostalCode` = '77044' ,`RoomCount` = '16' ,`ListPrice` = '505000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Mopan Springs' ,`StreetNumber` = '14311' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3418' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Click the Virtual Tour link to view the 3D walkthrough. Gorgeous curb appeal awaits new owners! Over 3,400 + square feet of living space w/ an ideal floor plan. Floor to ceiling windows fill the family room w/ natural light. Granite countertops, beautiful backsplash, & ample cabinetry are just a few kitchen highlights. Guests can eat in the dining room, breakfast area, or at the kitchen island for a quick meal! Tucked away for privacy, the primary bedroom features a spa-like 5 piece en-suite bath & walk-in closet. Upstairs, the loft can be turned into an extra living space, game room, or play area – the option is yours. The media room is great for hosting movie nights. Relax outside in your own oasis & take a dip in the heated pool that has different colored lights. Entertaining outside comes easy w/ the outdoor kitchen & covered patio. Spend more time in nature at Dwight D. Eisenhower Park or on Lake Houston. This is an opportunity not to be missed!' ,`Acres` = '0.1997' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Summerwood/Lakeshore' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 15 BLK 4 SUMMERWOOD SEC 28' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8700' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'SUMMERWOOD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'WOODCREEK MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Summerwood Sec 28' ,`TaxAmount` = '10511' ,`TaxRate` = '2.7932' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642062' WHERE `Matrix_Unique_ID` = '214531093' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-24T13:15:14.080' ,`MLSNumber` = '68590570' ,`ListAgentFullName` = 'Sonya Garmon' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = 'Jeffrey Forshee' ,`SellingOfficeName` = 'eXp Realty, LLC' ,`Latitude` = '29.629264' ,`Longitude` = '-95.475961' ,`PhotoCount` = '42' ,`PostalCode` = '77085' ,`RoomCount` = '8' ,`ListPrice` = '265200.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Wesley Oaks' ,`StreetNumber` = '13506' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2032' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Washer, dryer, and fridge included!! NO BACK NEIGHBOORS!!!! New complete HVAC system in March 2022.\r\nInterior and exterior painting, laminate flooring, ceramic tile in bathroom, and a new front door in July 2020.\r\nGreat location!!! Quick access to the Medical Center, 610, Beltway 8 and Westpark Tollway. NEVER FLOODED!! No high water during any of the major storms. Home still owned by the original homeowner. Access to playground and a fitness area with exercise equipment. Walking distance from an elementary school. Nearby walking and biking trails. 10 minutes from NRG Stadium and Arena' ,`Acres` = '0.1793' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Five Corners' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 6 BLK 7 CORINTHIAN POINTE SEC 3 AMEND' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7809' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HINES-CALDWELL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MADISON HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LAWSON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Corinthian Pointe Sec 03 Amd' ,`TaxAmount` = '4971' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642063' WHERE `Matrix_Unique_ID` = '214619504' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-24T13:51:06.320' ,`MLSNumber` = '43885365' ,`ListAgentFullName` = 'Maria Landivar' ,`ListOfficeName` = 'Keller Williams Realty - Memor' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.448320' ,`Longitude` = '-95.088552' ,`PhotoCount` = '23' ,`PostalCode` = '77539' ,`RoomCount` = '6' ,`ListPrice` = '260000.00' ,`Status` = 'Active' ,`StreetName` = 'Hunters' ,`StreetNumber` = '524' ,`StreetSuffix` = 'Lane' ,`City` = 'Dickinson' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1336' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Cozy house with 3 bedrooms, 2 complete baths. Spacious Kitchen with nice cabinets and granite countertops, dishwaher, microwave. This house has nice light fixtures and ceilings fans. Bathroom with Tub and nice vanities.\r\nTitle flooring and carpet in the Bedrooms. Covered patio with a huge swimming pool and big backyard to enjoy with the family and friends.\r\nDon\'t miss the apportunity to visit this nice property!' ,`Acres` = '0.1928' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 19 PERRY & AUSTIN SUR LOT 12 BLK 5 DOVE MEADOWS' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Enclosed' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'CALDER ROAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'LOBIT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Dove Meadow' ,`TaxAmount` = '5081' ,`TaxRate` = '2.4697' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1988' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642063' WHERE `Matrix_Unique_ID` = '214669030' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-24T13:26:09.793' ,`MLSNumber` = '43871515' ,`ListAgentFullName` = 'Gabriel Mendoza' ,`ListOfficeName` = 'Orchard Brokerage' ,`SellingAgentFullName` = 'Shah Mitu Haleem' ,`SellingOfficeName` = 'REALM Real Estate Professional' ,`Latitude` = '29.768332' ,`Longitude` = '-95.859001' ,`PhotoCount` = '30' ,`PostalCode` = '77494' ,`RoomCount` = '16' ,`ListPrice` = '540000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Moon Portrait' ,`StreetNumber` = '28219' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3408' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Click the Virtual Tour link to view the 3D walkthrough. Your dream home awaits with high ceilings, floor to ceiling windows, and gorgeous curb appeal. This residence has over 3400 square feet of living space with an ideal floor plan. White cabinetry, granite countertops, beautiful backsplash, an island with bar seating are a few kitchen highlights. The family room is bursting with natural light and the fireplace is the perfect to keep guests warm during the upcoming winter months. The primary bedroom features a massive walk-in closet and a 5 piece en-suite bath that has a spa-like standing shower, built-in vanity, and a soaking tub. Entertaining comes easy with the recreation and media room located on the second floor. Take the fun outside, where the private backyard is a blank slate to make it your own! Spend the day in Houston with quick access to I-10. Property is located within Katy ISD. Welcome home to your new oasis! 5 years of structural warranty & central ac and heat remaining.' ,`Acres` = '0.2004' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'TRAILS OF KATY SEC 3, BLOCK 2, LOT 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8730' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'BRYANT ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'WOODCREEK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Trails Of Katy Sec 3' ,`TaxAmount` = '11970' ,`TaxRate` = '3.2845' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642063' WHERE `Matrix_Unique_ID` = '214890080' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-24T13:43:40.797' ,`MLSNumber` = '8773867' ,`ListAgentFullName` = 'Tanovia Cossey' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.836489' ,`Longitude` = '-95.318040' ,`PhotoCount` = '7' ,`PostalCode` = '77016' ,`RoomCount` = '4' ,`ListPrice` = '120000.00' ,`Status` = 'Active' ,`StreetName` = 'Jones' ,`StreetNumber` = '4917' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1421' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Investment property, fixer upper, sold as is. Buyer to provide survey. Room dimensions approx. Please verify.' ,`Acres` = '0.1263' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LT 5 BLK 8 FOREST LAWN' ,`LotDesciption` = 'Other' ,`LotSize` = '5500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition,Other' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'COOK ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'KASHMERE HIGH SCHOOL' ,`SchoolMiddle` = 'KEY MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Forest Lawn' ,`TaxAmount` = '1691' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1945' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642063' WHERE `Matrix_Unique_ID` = '214919712' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214987351','1669642064','214987351','2022-11-24T13:21:27.457','16652712','Brandon Walsh','eXp Realty, LLC','','','29.544815','-95.185500','48','77546','8','320000.00','Active','Heritage Country','4731','Lane','Friendswood','2','1','3','2045','Single-Family','A pleasant two story 3 bedroom 2-and-a-half-bathroom home that is move-in ready just in time for the holidays. Location is perfect with easy access to I-45, walking distance to Clear Brook High school, and Baybrook Mall is just a couple minutes away for entertainment. This home has an inviting entryway that opens to the office, formal dining room and the living room. The office comes with built-in shelving with lighting. Formal dining room is currently a workout/zen room to help bring in the good vibes. The kitchen has granite countertops with a butcherblock countertop for the island. The spacious living room invites a ton of natural lighting from the updated low-e double pane windows. The upstairs has two secondary bedrooms and the primary bedroom. The primary bathroom has a huge shower with 2 rain-glass windows and a large closet. The pool and the covered patio in the backyard are perfect for entertaining or birthday parties.','0.1494','7','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','HOA First Right of Refusal,Mud,Sellers Disclosure','1','Gas Connections,Wood Burning Fireplace','1','Friendswood','Central Gas','1','LT 2 BLK 2 HERITAGE PARK SEC 8 R/P','Subdivision Lot','6510','Appraisal District','','352','0','','2','Electric Oven','1','Gunite,In Ground','','Gas Cooktop','','Composition','9 - Clear Creek','WEDGEWOOD ELEMENTARY SCHOOL','CLEAR BROOK HIGH SCHOOL','BROOKSIDE INTERMEDIATE SCHOOL','Appointment Required,Lockbox Front,Supra Keybox','Appraisal District','2','Traditional','Heritage Park Sec 08 R/P','5735','2.166','Public Sewer,Public Water','1989','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215068627','1669642064','215068627','2022-11-24T13:03:28.700','53793625','Nina Kaczorowski','eXp Realty, LLC','','','30.674340','-96.346268','36','77802','3','229900.00','Active','Allen Ridge','2700','Drive','Bryan','2','0','3','1198','Single-Family','Charming 3 bedroom 2 bath located off of quiet street in established Bryan neighborhood. Covered back deck overlooks a large, easy to maintain, backyard.','0.3175','61','','','','','Sellers Disclosure','','','','','Central Gas','0','ALLEN RIDGE PH 1, BLOCK 1, LOT 7','Subdivision Lot','13830','Appraisal District','','','0','','2','','0','','','','','Composition','148 - Bryan','MITCHELL ELEMENTARY SCHOOL (BRYAN)','JAMES EARL RUDDER HIGH SCHOOL','ARTHUR L. DAVILA MIDDLE SCHOOL','Accompany,Appointment Required,Leave Business Card,Lockbox Front','Appraisal District','1','Traditional','Allen Ridge Ph 01','4165','2.193','Public Sewer,Public Water','1993','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215076260','1669642064','215076260','2022-11-24T13:06:50.513','80863337','Richard Fenyes','Rocket, Realtors','Stephan Loston','Coldwell Banker Realty','29.777133','-95.332952','41','77020','5','375000.00','Option Pending','Capron','1708','Street','Houston','2','1','3','2043','Single-Family','Extremely well-built feature-rich home well appointed with many upgrades.This luxurious modern home greets w/elevated ceilings & LED recessed lighting packages throughout the entire home,beautiful porcelain tile, the stairwell is an abosolute show-stopper w/solid red oak wood treads & white painted risers all well lit by unique stairwell lighting that will make the modern rectangular custom-designer wrought iron staircase glow brilliantly;super gorgeous.Many upgrades within this home.The oversized quartz island kitchen(in-island farm sink/faucet)is superb & well lit including undermount cabinetry lighting,42\"cabinetry w/SOFT-CLOSE feature ,matte gold hardware pulls that accent &contrast off the white paint for stunning appearance.Home is prewired for alarm,speakers &TVs(extra heavy-duty framing to hang).The Primary bedroom & bath invites with trayed ceiling,LED lighting,primary closet includes soft close drawers & organizational system.Garage includes epoxy floor,opener and 8\' entry','0.0631','2','DXP Capital, LLC','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','No Disclosures','1','','','Denver Harbor','Central Gas','0','LT 1 BLK 1 CAPRON ESTATES','Subdivision Lot','2750','Appraisal District','','','1','Never Lived In','2','Convection Oven,Electric Oven','0','','','Gas Range','','Composition','27 - Houston','ATHERTON ELEMENTARY SCHOOL (HOUSTON)','WHEATLEY HIGH SCHOOL','FLEMING MIDDLE SCHOOL','Accompany,Appointment Required,Controlled Access,Lockbox Back,Supra Keybox,Temporarily No Showings','Appraisal District','2','Contemporary/Modern,Traditional','Capron Estates','5391','2.3307','Public Sewer,Public Water','2022','Builder'); --> New record created successfully