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-09-11T19:39:08.537' ,`MLSNumber` = '70383900' ,`ListAgentFullName` = 'Tiffany Wells' ,`ListOfficeName` = 'Doug Erdy Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.335230' ,`Longitude` = '-95.054901' ,`PhotoCount` = '24' ,`PostalCode` = '77327' ,`RoomCount` = '3' ,`ListPrice` = '299900.00' ,`Status` = 'Active' ,`StreetName` = 'Poppy Hills lane' ,`StreetNumber` = '20054' ,`StreetSuffix` = 'Lane' ,`City` = 'Cleveland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1734' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Impressive corner Cul-de-sac lot! LVP flooring in main living areas, Dark Espresso Cabinetry, Quartz countertops. Chefs island with Kohler SS Sink. Tray Ceilings. Designer tile. Custom backsplash. Large Primary with impressive walk-ins with custom built-ins. Large walk-in shower & soaking tub. Soft close cabinets. Wifi garage door opener. Full sod in front & back. Call to set up a private tour! Brand new 600+ ACRE MASTER-PLANNED COMMUNITY. State-of-the-art Community Center that will include a Grand Ball Room, Conference Room, Pro Golf Shop, and bistro-style restaurant which will wonderfully compliment the GOLF COURSE, POOL, DOG PARK, and WALKING TRAIL amenities.' ,`Acres` = '0.3016' ,`Area` = '52' ,`BuilderName` = 'Fountain Lovely Home' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'GRAND OAKS RESERVE, SEC 4, BLOCK 2, LOT 1, ACRES 0.3016' ,`LotDesciption` = 'Cul-De-Sac,Other' ,`LotSize` = '13138' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '100 - Cleveland' ,`SchoolElementary` = 'EASTSIDE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEVELAND HIGH SCHOOL' ,`SchoolMiddle` = 'CLEVELAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Grand Oaks Reserve Sec 4' ,`TaxAmount` = '964' ,`TaxRate` = '2.5563' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663709446' WHERE `Matrix_Unique_ID` = '208550428' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-11T18:19:42.553' ,`MLSNumber` = '35789219' ,`ListAgentFullName` = 'Tricia Turner' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.768281' ,`Longitude` = '-94.926633' ,`PhotoCount` = '33' ,`PostalCode` = '77521' ,`RoomCount` = '7' ,`ListPrice` = '225000.00' ,`Status` = 'Active' ,`StreetName` = 'Queenswood' ,`StreetNumber` = '4209' ,`StreetSuffix` = 'Street' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1647' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'CHARMING 1 story 3 bed | 2 bath home perfectly situated on a cul de sac street in the community of Kings Bend on an amazing 9,598 square-foot lot! Upon entering this lovely home, you\'re greeted by bright white walls and unique dark trim. Get ready to cozy up this winter around the incredible all-brick wood-burning fireplace, situated in the middle of the home separating the formal dining room and the massive family room! Wood-look laminate floors throughout and ceramic tile in the baths. The spacious primary retreat features recent plush neutral carpet, two closets, and an ensuite bathroom with double sinks. Two spacious secondary bedrooms are separated by a full bathroom. The chef in the family will love the unique kitchen with an island cooktop and plenty of white cabinets. Refrigerator, washer, and dryer all included. The massive backyard features a large covered patio great for entertaining family and friends! 2 car attached garage. NO MUD, NO HOA. Goose Creek CISD!' ,`Acres` = '0.2203' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 35 BLK 4 KINGS BEND SEC 2 R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9598' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'STEPHEN F. AUSTIN ELEMENTARY SCHOOL (GOOSE CREEK)' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (GOOSE CREEK)' ,`SchoolMiddle` = 'CEDAR BAYOU J H' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Kings Bend' ,`TaxAmount` = '4700' ,`TaxRate` = '2.97' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1975' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663709446' WHERE `Matrix_Unique_ID` = '209910364' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-11T18:51:27.073' ,`MLSNumber` = '17323657' ,`ListAgentFullName` = 'Fariborz Shojai' ,`ListOfficeName` = 'F S Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.750769' ,`Longitude` = '-95.488896' ,`PhotoCount` = '26' ,`PostalCode` = '77057' ,`RoomCount` = '6' ,`ListPrice` = '899987.00' ,`Status` = 'Active' ,`StreetName` = 'Potomac' ,`StreetNumber` = '1632' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4000' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Location. Location. Location. Galleria area. Potomac @ San Felipe, gated. Open floor plan with custom finishes, crown & base, custom cabinetry & hardwood floors throughout. First floor living with Study/Office. Gourmet Kitchen includes 48\" subzero Viking refrigerator, 48\'\' range, floor to ceiling cabinets, large island, walk-in pantry and mud room. All Bedrooms located on the second floor. Spacious master BR, M Bath & M Closet. JELD-WEN: French doors & windows make this home very quiet & well insulated. Three (3) separate AC units (16 seer Trane) for each floor would reduce electricity consumptions. Breath taking 3rd floor with skyline view: Loft/ Game room, wet bar, full bath & rooftop make this stunning home great for living & entertaining. This beautiful home has it all: OFFICE, YARD, WET BAR, LOFT & ROOFTOP. Zoned to Briargrove elementary. Seller is a professional real estate agent. Home is vacant, ready for immediate occupancy. ACCOMPANY.' ,`Acres` = '' ,`Area` = '22' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Galleria' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 4 BLK 1 POTOMAC GARDENS' ,`LotDesciption` = 'Corner' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BRIARGROVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WISDOM HIGH SCHOOL' ,`SchoolMiddle` = 'TANGLEWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Other Style' ,`Subdivision` = 'Potomac Gardens Subdivision' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663709447' WHERE `Matrix_Unique_ID` = '210430310' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-11T19:07:45.510' ,`MLSNumber` = '58700104' ,`ListAgentFullName` = 'Katie Forney' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.732107' ,`Longitude` = '-95.587473' ,`PhotoCount` = '18' ,`PostalCode` = '77082' ,`RoomCount` = '3' ,`ListPrice` = '420000.00' ,`Status` = 'Active' ,`StreetName` = 'Mcnabb' ,`StreetNumber` = '11913' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2024' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.0508' ,`Area` = '31' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Westchase Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 9 BLK 3 ROYAL OAKS SQUARE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2215' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2150' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '2 - Alief' ,`SchoolElementary` = 'OUTLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AISD DRAW' ,`SchoolMiddle` = 'O\'DONNELL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Royal Oaks Square' ,`TaxAmount` = '9342' ,`TaxRate` = '2.4411' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663709447' WHERE `Matrix_Unique_ID` = '211202713' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-11T18:50:47.637' ,`MLSNumber` = '34376508' ,`ListAgentFullName` = 'Marissa Stevens' ,`ListOfficeName` = 'RE/ImageProperties and Investm' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.977132' ,`Longitude` = '-95.403506' ,`PhotoCount` = '22' ,`PostalCode` = '77073' ,`RoomCount` = '5' ,`ListPrice` = '255000.00' ,`Status` = 'Active' ,`StreetName` = 'Tinway' ,`StreetNumber` = '19419' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1680' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful home located on the cul-de-sac near 45 and Beltway 8 a few minutes from the airport. New fresh paint and crown molding on the first floor. Great kitchen area with gas stove and granite counter tops. Nice back yard with patio, no back neighbors.' ,`Acres` = '0.1181' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Aldine Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 39 BLK 1 REMINGTON RANCH SEC 26' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '5145' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '830' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'HOYLAND ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ANDY DEKANEY H S' ,`SchoolMiddle` = 'DUEITT MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Back,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Remington Ranch' ,`TaxAmount` = '5277' ,`TaxRate` = '2.8804' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663709447' WHERE `Matrix_Unique_ID` = '211640589' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-11T19:07:00.880' ,`MLSNumber` = '44526625' ,`ListAgentFullName` = 'Alison Christensen' ,`ListOfficeName` = 'Sand N Sea Properties, LLC' ,`SellingAgentFullName` = 'Suzie Austin' ,`SellingOfficeName` = 'Keller Williams Premier RealtyKaty' ,`Latitude` = '29.201962' ,`Longitude` = '-94.938154' ,`PhotoCount` = '33' ,`PostalCode` = '77554' ,`RoomCount` = '7' ,`ListPrice` = '1300000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Pirates' ,`StreetNumber` = '4234' ,`StreetSuffix` = 'Drive' ,`City` = 'Galveston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2170' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'GORGEOUS BEACHFRONT HOME in popular Pirates Beach! Enjoy stunning 180 degree views of the Gulf from the expansive deck that has covered and open areas. Beautiful interior features vaulted ceilings, shiplap walls, stylish luxury vinyl plank flooring and fabulous furnishings which are included. Large island in the kitchen opens to the family room and dining area. Other kitchen features include pot filler, separate pantry, wine fridge, and hidden trashcan cabinet. Two guest bedrooms are on the main floor. A guest en-suite bedroom and primary bedroom are upstairs and share a deck. Primary bedroom has a coffee station/wet bar with a sink and mini-fridge. Soaking tub, separate walk-in shower and double sinks in the primary bathroom. This is beachfront living at its finest!' ,`Acres` = '0.1438' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'West End' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 121 HALL & JONES SUR LOT 3 BLK 3 PIRATES BEACH SEC 2' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot,Water View,Waterfront' ,`LotSize` = '6265' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '375' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Pirates Beach 2' ,`TaxAmount` = '21352' ,`TaxRate` = '2.0324' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663709447' WHERE `Matrix_Unique_ID` = '211849158' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-11T19:34:38.300' ,`MLSNumber` = '35883672' ,`ListAgentFullName` = 'Maritza Burt' ,`ListOfficeName` = 'RE/MAX Grand' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.751791' ,`Longitude` = '-95.495013' ,`PhotoCount` = '28' ,`PostalCode` = '77057' ,`RoomCount` = '13' ,`ListPrice` = '2495000.00' ,`Status` = 'Active' ,`StreetName` = 'Doliver' ,`StreetNumber` = '6260' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '5' ,`BathsHalf` = '2' ,`BedsTotal` = '5' ,`SqFtTotal` = '5330' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Recent build 2019. Showcase home with ideal floorpan for entertaining. Beautiful climate controlled wine room, wet bar w/ice maker, spacious kitchen with 2 dishwashers and 6 gas burner cooktop with griddle and full oven and a half, stunning study, elegant formal dining room and bedroom/flex room down. Control 4 system includes 5 main televisions, 6 exterior cameras, lighting, music and intercom system. Turf backyard, mosquito system, green egg and gas grill. Speakers in main areas plus master bedroom and game room. Custom designer window coverings and drapery throughout. North section of Briargrove. Great neighbors!' ,`Acres` = '0.1995' ,`Area` = '22' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Briargrove' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 415 BLK 20 BRIARGROVE SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8690' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Double Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BRIARGROVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WISDOM HIGH SCHOOL' ,`SchoolMiddle` = 'TANGLEWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Briargrove Sec 03' ,`TaxAmount` = '48540' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663709447' WHERE `Matrix_Unique_ID` = '211942985' --> 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','212094404','1663709447','212094404','2022-09-11T19:20:52.477','75434186','Salvador Caballero','ListWithFreedom.com','Sarah Nicely','Alpha Elite Realty','29.544068','-95.286463','31','77584','8','405000.00','Pending Continue to Show','Pine Mill','4010','Court','Pearland','3','1','4','2985','Single-Family','Beautiful home on corner lot of quiet cul-de-sac street in charming Pearland Farms! 4 bed / 3.5 bath. Spacious downstairs master suite invites you to relax and unwind, while the large kitchen with granite countertops and bar makes preparing family meals a snap! Three more bedrooms are perfect for kids, guests, or home office space. Large covered patio with amazing outdoor kitchen and media/bonus area upstairs let you entertain inside or out! Easy access to 288 & 35 for commuters but feels like a small-town community. MUST be seen — don\'t miss this one!','0.1989','5','','','','','No Disclosures','1','Gaslog Fireplace','1','Pearland','Central Gas','1','PEARLAND FARMS SEC 1 (A0508 F B DRAKE)(PEARLAND), BLOCK 1, L','Corner,Subdivision Lot','8664','Appraisal District','','525','0','','2','','0','','','','','Composition','42 - Pearland','MAGNOLIA ELEMENTARY SCHOOL (PEARLAND)','PEARLAND HIGH SCHOOL','PEARLAND JUNIOR HIGH SOUTH','Appointment Required','Seller','2','Traditional','Pearland Farms Sec 1','8672','2.5552','Public Sewer,Public Water','2011','Seller'); --> 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','212165563','1663709447','212165563','2022-09-11T19:53:42.483','23803714','Megan Latour','JLA Realty','','','30.666333','-95.012386','39','77351','6','439000.00','Active','Lake Shore','382','Drive','Livingston','2','0','3','1404','Single-Family','Remarkable views of Pine Island & Lake Livingston from this beautiful property & an incredible view of the sunset. The upstairs interior features beautiful wood throughout, 1 master retreat with en suite bathroom, spacious living area, and kitchen area. Downstairs you will find 2 bedrooms, a full bathroom, and a living area- tile throughout bottom floor. 1st & 2nd levels feature oversized 30x30 patios offering plenty of room for you and guests. Additional concrete parking, gorgeous stone columns matching the house, outdoor oven/fireplace with sink area & wrought iron gate and fencing complete the exterior of this property. This property is in close proximity to Lake Livingston State Park. Boat house & dock constructed by Mosley. Metal bulkhead. Boat house with boat slip/lift & dual jet ski slips/lifts. Don\'t miss this opportunity to be on the lake this summer!','0.1966','44','','','Washer Connections','','Sellers Disclosure','1','Freestanding,Wood Burning Fireplace','1','Lake Livingston Area','Central Electric','1','LAKE LIVINGSTON ESTATES SECTION 3 BLK 1 LOT 29-B','Waterfront','','Other','','232','0','','0','','0','','','Electric Cooktop','','Composition','103 - Livingston','LISD OPEN ENROLL','LIVINGSTON HIGH SCHOOL','LIVINGSTON JUNIOR HIGH SCHOOL','Appointment Required,Lockbox Left Side','Appraisal District','2','Ranch,Spanish','Lake Livingston Estates','5445','1.8745','Public Sewer,Public Water','1987','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','212292761','1663709447','212292761','2022-09-11T18:24:14.600','98778006','Wendy Gutierrez','Realty Associates','','','29.847853','-95.597866','25','77041','10','635000.00','Active','Cherry Creek Bend','12538','Lane','Houston','3','0','4','3265','Single-Family','Gorgeous updated 4-bedroom, 3-Bath home in a resort-like gated community. Open, bright floorplan, soaring ceilings, wood grain porcelain plank floors throughout the first floor. Formal dining & living or study. The kitchen and bathrooms updated with Quartz counters, kitchen open to bright family room. Family room w/fireplace and a wall of windows. Primary bedroom/bath downstairs with dual sinks, large walk-in closet, whirlpool tub and seamless shower. Primary bedroom overlooking the beautiful backyard with a Sparkling Pool, Spa and lush landscape. Secondary bedroom and full bath downstairs. Game room & 2 additional bedrooms on second floor share a Jack & Jill bath. Oversized garage with workshop. Expansion possibilities on second floor walk-in floored attic. Could make great bonus room! Lakes on Eldridge is a beautiful, gated community w/24hr man guard, clubhouse, tennis & volleyball, community pool, trails. New carpet, new double-pane windows, tankless water heater, new roof June 2021','0.2331','8','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Exclusions','1','Gaslog Fireplace','1','Eldridge North','Central Gas','1','LT 25 BLK 2 LAKES ON ELDRIDGE SEC 3 AMEND','Subdivision Lot,Wooded','10154','Appraisal District','','1800','0','','2','Electric Oven','1','Gunite,In Ground','','Electric Range','','Composition','13 - Cypress-Fairbanks','KIRK ELEMENTARY SCHOOL','CYPRESS RIDGE HIGH SCHOOL','TRUITT MIDDLE SCHOOL','Appointment Required','Appraisal District','2','Traditional','Lakes On Eldridge Sec 03 Amd','9785','2.471','Water District','1996','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','212304688','1663709447','212304688','2022-09-11T18:14:45.157','48796184','Jazmine Ibarra','HomeSmart','','','29.779069','-95.332507','19','77020','2','135000.00','Active','Rawley','3719','Street','Houston','1','0','2','841','Single-Family','Investor Handyman special. Cute small home in a great location, an up an coming in opportunity zone. New builds all around, close to everything in an area that is blowing up with progress and city improvements. No Mud, Low Taxes, No Flood. Great Home, Great Investment!','0.0815','2','','','','','Sellers Disclosure','','','','Denver Harbor','Window Unit','0','TRS 7A & 8B BLK 6 CHAPMANS SEC 3','Subdivision Lot','3552','Appraisal District','','','0','','0','','0','','','','','Composition','27 - Houston','ATHERTON ELEMENTARY SCHOOL (HOUSTON)','WHEATLEY HIGH SCHOOL','FLEMING MIDDLE SCHOOL','Accompany,Appointment Required,Leave Business Card,Lockbox Front','Appraisal District','1','Traditional','Chapmans Sec 03','1865','2.3307','Public Sewer,Public Water','1930','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','212351125','1663709447','212351125','2022-09-11T19:40:44.693','30214816','Jo Anne Armstrong','Blue Willow Properties','','','29.625312','-95.381663','20','77047','10','299000.00','Active','Skyview Star','12410','Court','Houston','2','1','3','2271','Single-Family','LOCATION, LOCATION, LOCATION!!! Convenient to the Med Center, West U, Midtown & Downtown Houston but located in a quiet subdivision on a cul-de-sac street. This home features an open living concept with an oversized island designed for entertaining and quick meals. The windows are covered with convenient shutters. The covered back patio is a great place to relax and unwind. The second floor includes a bonus room that could be used as a gameroom/extra living room/playroom, etc... along with all three bedrooms, primary bath, secondary bath and laundry room. Schedule your showing today!','0.1037','3','','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','','','Medical Center South','Central Gas','1','LT 6 BLK 1 SKYVIEW PARK SEC 10','Cul-De-Sac,Subdivision Lot','4516','Appraisal District','','400','0','','2','Gas Oven,Single Oven','0','','','Gas Range','','Composition','27 - Houston','LAW ELEMENTARY SCHOOL','WORTHING HIGH SCHOOL','THOMAS MIDDLE SCHOOL','Supra Keybox','Appraisal District','2','Traditional','Skyview Park Sec 10','5722','2.9307','Water District','2013','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','212385750','1663709447','212385750','2022-09-11T18:06:19.833','54426244','Gretchen Beausoleil','Pinnacle Realty Advisors','','','30.865397','-95.314682','34','77320','9','349000.00','Active','Chestnut','281','Bend','Huntsville','2','0','5','2280','Single-Family','Come sit on the large covered back deck and enjoy the wildlife from your waterfront home that is nestled in the mature trees of Lakeside Village Subdivision. This home comes furnished, so just pack your bags and start enjoying your new waterfront home - the fishing rods are waiting for you in boathouse. This well-kept large manufactured home sits on two lots, totaling almost an acre and was set on the property band new. This spacious (2280sq.ft.), open/split floor plan, includes large living room, family room with a fireplace, five-bedrooms, two-full baths. This home also features a sprinkler system (permitted by TRA) for the back yard, pier, dock, boathouse, whole house generator and a 2-story large storage shed. The long, angled driveway allows for privacy from the street. This is a waterfront home you will never want to leave. Lakeside Village Subdivision main boat ramp is right on the Trinity River and provides direct access to Lake Livingston.','0.8458','64','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gaslog Fireplace','1','Lake Livingston Area','Propane','1','LAKESIDE VILLAGE #3, LOT 490 & 491, HUD# PFS0861377, HUD#2 P','Water View,Waterfront','36843','Appraisal District','','196','0','','0','Freestanding Oven,Gas Oven','0','','','','','Aluminum','101 - Coldspring-Oakhurst Consolidated','JAMES STREET ELEMENTARY SCHOOL','COLDSPRING-OAKHURST HIGH SCHOOL','LINCOLN JUNIOR HIGH SCHOOL','Accompany,Appointment Required,Leave Business Card,Lockbox Back,Lockbox Front,Request Online Appointment','Appraisal District','1','Other Style','Lakeside Village #3','3526','1.6254','Aerobic,Public Water,Septic Tank','2004','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','212387341','1663709447','212387341','2022-09-11T18:04:24.877','86879329','Terry Burnaman','Terry Burnaman ','','','29.653229','-95.484111','19','77035','3','319000.00','Active','Burlinghall','5602','Drive','Houston','2','0','3','1885','Single-Family','Location, Location, Location! Recently remodeled home with updates and modern touches that included updated granite countertops throughout, tile tub and shower surrounds in the bathrooms, plumbing fixtures, flooring in the bathrooms, kitchen, breakfast area, utility room and foyer, interior and exterior paint and windows. Spacious den overlooking the covered patio along with both formals. It is convenient to the Med Center, museum district, Rice University, the Galleria, and a short commute to downtown! The Willow Waterhole is just a few blocks away for dog walking & biking. This neighborhood is easily accessible to all surrounding Freeways. NO FLOODING!!!','0.1928','20','','','','','Sellers Disclosure','1','','','Brays Oaks','Central Gas','0','LT 17 BLK 61 WESTBURY SEC 3 R/P','Subdivision Lot','8400','Appraisal District','','','0','','2','Double Oven,Electric Oven','0','','','Electric Cooktop','','Composition','27 - Houston','ANDERSON ELEMENTARY SCHOOL (HOUSTON)','WESTBURY HIGH SCHOOL','MEYERLAND MIDDLE SCHOOL','Appointment Required,Supra Keybox','Appraisal District','1','Traditional','Westbury Sec 03 R/P','6066','2.3307','Public Sewer,Public Water','1960','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','212408638','1663709448','212408638','2022-09-11T18:30:34.983','67446248','George Gallagher','Westwood Shores Real Estate','','','30.935357','-95.324578','21','75862','2','77500.00','Active','Mockingbird Lane','45','','Trinity','1','1','2','840','Single-Family','This is a Delightful 2 Bedroom, 1 & 1/2 Bath Manufactured Home that has been completely renovated in 2015 and never smoked in since Reno. Taken down to aluminum siding and studs and rooms reconfigured. \r\n(2015; 3/4\" plywood floors, new electrical wiring, boxes, switches, new insulation throughout, new drywall, vinyl floor, carpet in both bedrooms. Every light fixture, 2 ceiling fans, two toilets, two vanities, faucets, kitchen cabinets and counter tops & stove were purchased. In \"2021\" Kitchen ceiling reinforced with 2x4\'s (replacing 2x2\'s) and new drywall. 12/2021 Re-leveled, 2/2021 New Galvanized metal roof. \r\n8\'x32\' wooden deck with 2 entrances. (16\' under metal roof & 16\' uncovered)\r\nOutside Lights at doors, motion detector light on front. Electrical lights around front & side of home. Two car parking pad. Stove/Washer/dryer staying \r\nDeck great for entertaining/relaxing with your favorite beverage & watching the wildlife.','0.0808','42','','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','','','','Lake Livingston Area','No Heating','1','WESTWOOD SHORES SECTION 01, BLOCK 18 LOT 18 LABEL # TEX00220','In Golf Course Community','3520','Appraisal District','','2244','0','','0','Electric Oven','0','','','Electric Range','','Aluminum','63 - Trinity','LANSBERRY ELEMENTARY SCHOOL','TRINITY HIGH SCHOOL (HEB)','TRINITY JUNIOR HIGH SCHOOL','Accompany,Appointment Required,Controlled Access','Appraisal District','1','Other Style,Traditional','Westwood Shores','210','2.5863','Public Sewer,Water District','1975','Seller'); --> New record created successfully