Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-16T07:47:49.900' ,`MLSNumber` = '12273010' ,`ListAgentFullName` = 'Joe Rothchild' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.642614' ,`Longitude` = '-95.761389' ,`PhotoCount` = '12' ,`PostalCode` = '77406' ,`RoomCount` = '13' ,`ListPrice` = '393990.00' ,`Status` = 'Active' ,`StreetName` = 'Aster Meadow' ,`StreetNumber` = '3214' ,`StreetSuffix` = 'Way' ,`City` = 'Richmond' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2453' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '2 Story, 4 Bedroom, 3 ½ Baths, Primary Bedroom Down, Gameroom Up, Dual Vanity in Primary Bath with Garden Tub and Separate Shower, Elongated Commodes in Primary, Hall and Powder Baths, 42” Upper Kitchen Cabinets, Granite Kitchen Countertops, Undermount Sink with Pull Out Faucet, Tile Kitchen Backsplash, Upgraded Carpet and Pad, Upgraded Plumbing and Light Fixtures, Upgraded Trim Package, 2” Window Covers, Garage Door Opener, Wrought Iron Stair Parts, Mahogany Front Door, Large Covered Patio plus more…AVAILABLE DECEMBER.' ,`Acres` = '' ,`Area` = '37' ,`BuilderName` = 'Devon Street Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 18 BLK 1 SEC 8' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6409' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'FROST ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'FOSTER HIGH SCHOOL' ,`SchoolMiddle` = 'WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'McCrary Meadows' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675171036' WHERE `Matrix_Unique_ID` = '213820869' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-16T07:57:33.607' ,`MLSNumber` = '23343445' ,`ListAgentFullName` = 'Joe Rothchild' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.638848' ,`Longitude` = '-95.763167' ,`PhotoCount` = '19' ,`PostalCode` = '77406' ,`RoomCount` = '14' ,`ListPrice` = '429990.00' ,`Status` = 'Active' ,`StreetName` = 'Autumn Russet' ,`StreetNumber` = '3434' ,`StreetSuffix` = 'Trail' ,`City` = 'Richmond' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2883' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '2 Story, 4 Bedroom, 3 ½ Bath, Backs up to Reserve, Kitchen, Breakfast, Study, Dining Room, Family Room, Game Room and Media Room Up, Primary Bedroom Down, Dual Sinks with Hi/Lo Vanity in Primary Bath with Garden Tub and Separate Shower, Study with French Doors, Wrought Iron Stair Parts, Stainless Steel Appliance Package, 42” Upper Kitchen Cabinets, 3”x6” Offset Tile Kitchen Backsplash, Recessed Can Lights in Kitchen, Luxury Vinyl Plank with Shoe Molding at Entry, Family Room, Dining Room, Study, Hall Bath and Primary Bath, Upgraded Carpet and Carpet Pad, Fireplace with Cast Stone Surround, Garage Door Opener, 2” Window Covers, Mahogany Front Door, Upgraded Plumbing Fixtures plus more…AVAILABLE NOW.' ,`Acres` = '' ,`Area` = '37' ,`BuilderName` = 'Devon Street Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 1 BLK 1 SEC 10' ,`LotDesciption` = 'Other,Subdivision Lot' ,`LotSize` = '6233' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'FROST ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'FOSTER HIGH SCHOOL' ,`SchoolMiddle` = 'WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'McCrary Meadows' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675171036' WHERE `Matrix_Unique_ID` = '213821071' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-16T08:56:08.903' ,`MLSNumber` = '98422656' ,`ListAgentFullName` = 'Michael Greiner' ,`ListOfficeName` = 'My Castle Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.300490' ,`Longitude` = '-95.307790' ,`PhotoCount` = '18' ,`PostalCode` = '77306' ,`RoomCount` = '6' ,`ListPrice` = '239990.00' ,`Status` = 'Active' ,`StreetName` = 'Taylorcrest' ,`StreetNumber` = '15544' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1811' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MAIN-FLOOR BEDROOM | VERSATILE LOFT. \r\nYou will love this BEAUTIFUL NEW 2 story home in the Crockett Reserve Community! The desirable 1802 Plan features a main floor guest suite means this plan offers private living space both upstairs and downstairs. Kitchen highlights include gorgeous cabinets, granite countertops, and stainless-steel appliances (includes range, microwave, and dishwasher). All other bedrooms, including the primary suite, are on the 2nd floor. In the primary suite, there is a private bath with dual vanity sinks and a walk-in closet. The other 2 bedrooms are well-sized and share another full-sized bath. You’ll also love the versatile loft space and a walk-in laundry room on the upper floor. This welcoming plan comes with a 2-car garage.' ,`Acres` = '' ,`Area` = '40' ,`BuilderName` = 'Century Complete Bld' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S356303 - Crockett Reserve 03, BLOCK 2, Lot 11' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '278' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'CREIGHTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CANEY CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MOORHEAD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Crockett Reserve' ,`TaxAmount` = '' ,`TaxRate` = '1.94' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675171036' WHERE `Matrix_Unique_ID` = '213840813' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-16T08:54:28.350' ,`MLSNumber` = '3423743' ,`ListAgentFullName` = 'Jennifer Blanchard' ,`ListOfficeName` = 'World Wide Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.857912' ,`Longitude` = '-95.428917' ,`PhotoCount` = '13' ,`PostalCode` = '77091' ,`RoomCount` = '4' ,`ListPrice` = '349900.00' ,`Status` = 'Active' ,`StreetName` = 'Wheatley' ,`StreetNumber` = '6414' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1920' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'UNDER-CONSTRUCTION! NO HOA! Gorgeous new construction by Invictus LLC. This beautiful two-story home has the living area & kitchen on the first floor & three bedrooms on the second floor. CORNER LOT WITH PRIVATE DRIVEWAY & FENCED. Upgraded finishes throughout including: smart home system, Quartz counter tops, GE stainless-steel appliances, upgraded cabinets with soft close drawers, and LED lighting. Enjoy this quiet historic community located minutes away from downtown and easy access to 610 loop & 290. *Please note that the majority of the photos in here are from a previous project by the same builder Estimated completion: December 2022' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = 'Invictus' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'TRS 19 & 20 BLK 3 HIGHLAND HEIGHTS' ,`LotDesciption` = 'Corner' ,`LotSize` = '2887' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HIGHLAND HEIGHTS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WASHINGTON HIGH SCHOOL' ,`SchoolMiddle` = 'WILLIAMS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Temporarily No Showings,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'HIGHLAND HEIGHTS' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675171037' WHERE `Matrix_Unique_ID` = '213889279' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-16T07:38:16.697' ,`MLSNumber` = '34434925' ,`ListAgentFullName` = 'Laura Vo' ,`ListOfficeName` = 'LV Realty & Services' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.825221' ,`Longitude` = '-95.795136' ,`PhotoCount` = '40' ,`PostalCode` = '77493' ,`RoomCount` = '4' ,`ListPrice` = '501000.00' ,`Status` = 'Active' ,`StreetName` = 'Gannan Lake' ,`StreetNumber` = '3518' ,`StreetSuffix` = 'Court' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2697' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fall in love with this gorgeous 1.5 story house that sits on private waterfront oasis with stunning views & a walk out pier. Featuring 4 bedrooms, an office, and 3 full baths. Dream up culinary creations in the chef’s kitchen. Spend a quiet evening relaxing in the spa-like primary bathroom, complete with dual vanities, a garden tub, and a separate glass-enclosed shower. This is the perfect house to entertain, the lake is an amenity to be savored and owner is free launch right into the water, fish in the fully stocked lake or just sit by the the tranquility of the water. There is much more you could want from this gorgeous home! Great location, home conveniently gives access to and is just minutes from the 99 & I10. Call us to schedule a preview of this lovely home.' ,`Acres` = '0.1492' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 16 BLK 1 MARCELLO LAKES SEC 2' ,`LotDesciption` = 'Subdivision Lot,Water View,Waterfront' ,`LotSize` = '6499' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'LEONARD ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Left Side,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Marcello Lakes' ,`TaxAmount` = '6041' ,`TaxRate` = '3.5333' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675171037' WHERE `Matrix_Unique_ID` = '214277709' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-16T07:51:25.380' ,`MLSNumber` = '44484284' ,`ListAgentFullName` = 'Joe Rothchild' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.641317' ,`Longitude` = '-95.760600' ,`PhotoCount` = '15' ,`PostalCode` = '77406' ,`RoomCount` = '9' ,`ListPrice` = '331990.00' ,`Status` = 'Active' ,`StreetName` = 'Avary River' ,`StreetNumber` = '3331' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1523' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '1 Story, 3 Bedroom, 2 Bath, Study with French Doors, 42” Upper Kitchen Cabinets, Granite Kitchen Countertops, Herringbone Tile Kitchen Backsplash, Dual Vanities with Garden Tub and Separate Shower in Primary Bath, Garage Door Opener, 2” Window Covers, Full Gutters, Upgraded Plumbing Fixtures, Recessed Can Lights in Kitchen, Upgraded Carpet and Pad, Luxury Vinyl Plank Flooring in Entry, Kitchen, Breakfast, Utility, Study, Family Room, Hallway and all Baths, Covered Back Patio…AVAILABLE NOW.' ,`Acres` = '' ,`Area` = '37' ,`BuilderName` = 'Devon Street Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 43 BLK 1 SEC 8' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'FROST ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'FOSTER HIGH SCHOOL' ,`SchoolMiddle` = 'WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'McCrary Meadows' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675171037' WHERE `Matrix_Unique_ID` = '214801719' --> 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','215334906','1675171037','215334906','2023-01-16T08:29:20.353','61198768','Ben Caballero','Highland Homes Realty','','','29.519772','-95.401961','26','77578','4','479500.00','Active','Prairie Gourd','5139','Meadow','Manvel','3','0','4','2299','Single-Family','MLS# 61198768 - Built by Highland Homes - Ready Now! ~ Stunning triple arch foyer, soaring 11ft ceilings, 8ft interior doors, huge picture windows and an open concept make this a home to remember. A kitchen designed for a Chef Walk-in pantry, built in appliances, quartz counter tops, large island with cabinet space galore! Unwind the day on your Texas Sized Patio! Tankless water heater, full sprinkler system!','','5','Highland Homes','','','','Mud','','','','Alvin North','Central Gas','1','Lot 10, Block 2','Subdivision Lot','7926','Survey','','1190','1','Never Lived In','2','','0','','','','','Composition','3 - Alvin','POMONA ELEMENTARY SCHOOL','MANVEL HIGH SCHOOL','RODEO PALMS JUNIOR HIGH SCHOOL','Appointment Required','Builder','1','Traditional','Pomona','','3.51','Public Water','2022','Builder'); --> 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','216228457','1675171037','216228457','2023-01-16T07:07:42.580','76168513','Ashleigh Morris','JLA Realty','','','30.140555','-94.910244','35','77535','10','425000.00','Active','Road 6618','419','','Dayton','2','0','3','2147','Single-Family','Gorgeous home nestled quietly in the back of Encino Estates. Property is 3/4 acre, fenced, with light foliage to preserve the wooded serenity. Lots of natural light throughout the entire home and high efficiency HVAC helps keep utility costs as low as possible. Home has water purification system. Open floor plan makes everyone feel included when hosting get togethers. Stunning study can be used as a home library, office, or extra bedroom. Huge backyard with storage shed/dog run, septic system, Propane for Stove and Heater only. Check out this stunning home that offers all the upgrades, without having to wait for construction.','0.689','52','First America','','Electric Dryer Connections,Washer Connections','','Exclusions,Sellers Disclosure','1','','1','Dayton','Propane','1','ENCINO ESTATES, SEC 3, BLOCK 1, LOT 16, ACRES .689','Subdivision Lot,Wooded','30013','Survey','','450','0','','2','Gas Oven','0','','','Gas Range','','Composition','74 - Dayton','STEPHEN F. AUSTIN ELEMENTARY SCHOOL (DAYTON)','DAYTON HIGH SCHOOL','WOODROW WILSON JUNIOR HIGH SCHOOL','Appointment Required,Leave Business Card,Lockbox Front','Appraisal District','1','Traditional','Encino Estates','6096','1.6575','Septic Tank','2021','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','216365945','1675171037','216365945','2023-01-16T07:37:47.480','69326198','Steven Koleno','Beycome Brokerage Realty, LLC','','','30.076719','-95.270056','15','77365','8','280000.00','Active','Red Bay Fir','19815','Court','Porter','2','0','3','1569','Single-Family','Build completed in July of 2021.Tile flooring, carpets in the bedroom. Open floor plan to enjoy the family or entertaining. 42\" Cabinets in the kitchen. Back patio to sit and relax after a goods days work. Master has walk in shower to wash the day off! Great new community that has a park and splash pads for the little ones. Easy commute to 99 for travel, great local restaurants and shopping.','0.1193','40','','','','','No Disclosures','','','','Porter/New Caney West','Central Gas','1','S747102 - NORTHPARK WOODS 02, BLOCK 1, LOT 71','Subdivision Lot','5195','Appraisal District','','','0','','2','','0','','','','','Composition','39 - New Caney','BROOKWOOD FOREST ELEMENTARY SCHOOL','PORTER HIGH SCHOOL (NEW CANEY)','WOODRIDGE FOREST MIDDLE SCHOOL','Lockbox Front,No Appointment Required,Vacant/Unoccupied','Appraisal District','1','Traditional','Northpark Woods 02','8677','3.6131','Water District','2021','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','216368072','1675171037','216368072','2023-01-16T07:43:25.287','10183586','Steven Koleno','Beycome Brokerage Realty, LLC','','','29.505485','-95.428721','17','77583','10','450000.00','Active','Tara Oaks','5401','Court','Rosharon','3','1','4','3020','Single-Family','Welcome home to this amazing four bedroom house that offers class and beauty with a zen like appeal. Drive into the exotic Lakes of Savannah subdivision past the spread of lakes and the community pool area to this home that sits on the corner in a cul de sac. Across from it is a lake for that evening walk. As you walk into the house, you are greeted by the spiral stairs and the formal dining to your right. On the other side of the entrance is the living area with built in shelves. The kitchen is separated by the granite island kitchen that boasts stainless steel appliances. Before you take a walk to the master bedroom, check out the huge backyard - ideal for entertainment. Take a peek in the master bedroom and brag on the size; the separate shower and the closet. Take a walk upstairs and behold the game room and the media room. The three rooms are sure to wow you. This one is a gem.','0.1529','5','','','','','No Disclosures','','','','Alvin North','Central Gas','1','SAVANNAH BEND SEC 2 (A0562 H T & B) BLK 2 LOT 1','Corner,Subdivision Lot','6660','Appraisal District','','670','0','','2','','0','','','','','Composition','3 - Alvin','SAVANNAH LAKES ELEMENTARY SCHOOL','MANVEL HIGH SCHOOL','MANVEL JUNIOR HIGH SCHOOL','Lockbox Front,No Appointment Required,Vacant/Unoccupied','Appraisal District','2','Traditional','Savannah Bend Sec 2','9755','2.9567','Public Sewer,Public Water','2012','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','216420926','1675171037','216420926','2023-01-16T07:40:59.773','53090926','Shary Luthe','Home Sweet Home Realty, LLC','','','30.731964','-95.211560','43','77364','4','275000.00','Active','Governor Hogg','342','Drive','Point Blank','3','0','4','2416','Single-Family','Welcome To Governor\'s Point- A Well Maintained Quiet Lake Community That Is Highly Desired Among The Locals! Governor\'s Point Provides Expansive Amenities With Extremely Low HOA Dues Including A Community Boat Launch, Fishing Piers, A Playground, Picnic Area And A Community Pool- WOW! This Beautiful Lake Home Features 4 Bedrooms, Including TWO Primary Bedroom Suites (One Upstairs And One Downstairs) And 3 Full Bathrooms With Covered Porches That Expand The Length Of The Home- Amazing! The Kitchen Is Massive And Overlooks The Living And Dining Area With Walls Of Windows. You Even Have A Wet Bar Area In The Upstairs Living Area! There Is Plenty Of Space For Storage With An Attached Garage And A Detached Workshop For Golf Cart Storage With An Oversized Carport For A Boat Or RV. All Interior Flooring, Roof, Exterior Staircase And Upper Landing Were Installed New In 2017! Come Make This Your Weekend Getaway Or Permanant Lake Residence! Furnishings Are Negotiable!','0.194','64','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','Lake Livingston Area','Central Electric','1','GOVERNORS POINT #2, BLOCK 11, LOT 17, ACRES .194','Subdivision Lot','8451','Appraisal District','','150','0','','1','Electric Oven','0','','','Electric Range','','Composition','101 - Coldspring-Oakhurst Consolidated','JAMES STREET ELEMENTARY SCHOOL','COLDSPRING-OAKHURST HIGH SCHOOL','LINCOLN JUNIOR HIGH SCHOOL','Appointment Required','Appraisal District','2','Colonial','Governors Point #2','3937','1.6254','Aerobic,Public Water','1978','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','216421003','1675171037','216421003','2023-01-16T07:45:03.940','65947592','Shary Luthe','Home Sweet Home Realty, LLC','','','30.348436','-95.307081','27','77303','4','250000.00','Active','Gordon','16811','Drive','Conroe','2','0','4','2176','Single-Family','Welcome To This Barely Lived In Home! This Generously Sized 4 Bedroom/ 2 Bath 2020 Double Wide Manufactured Home Sits On A Huge Third Acre Lot In The Growing Crockett Trace Estates! The Home Features A Split Plan And A Second Living Space For Plenty Of Room For The Entire Family! The Home Has It All-A Concrete Driveway, A Brand New Deck Area In The Backyard, Privacy Fencing, A Producing Garden That Includes A Watering System That Grows A Variety Of Produce Including Peppers, Corn, Tomatoes, Etc. Come Take A Look At This One- It Will Not Disappoint!','0.329','19','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','Conroe Northeast','Central Electric','1','S356208 - CROCKETT TRACE ESTATES 08, BLOCK 2, LOT 85, SERIAL','Cleared','14330','Appraisal District','','250','0','','0','Electric Oven','0','','','Electric Range','','Composition','11 - Conroe','AUSTIN ELEMENTARY SCHOOL (CONROE)','CANEY CREEK HIGH SCHOOL','MOORHEAD JUNIOR HIGH SCHOOL','Appointment Required,Lockbox Front','Appraisal District','1','Traditional','Crockett Trace Estates 08','1062','1.8488','Public Sewer,Public Water','2020','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','216421049','1675171038','216421049','2023-01-16T07:50:34.977','17069371','Shary Luthe','Home Sweet Home Realty, LLC','','','30.833871','-95.163124','47','77360','3','389000.00','Active','Emerald','330','Lane','Onalaska','2','0','3','1760','Single-Family','This Beautiful Custom Craftsman Style Home Has A Breathtaking WATERVIEW Of The Open Waters Of Lake Livingston! This 3 Bedroom/2 Bath Home Has An Acre And A Half Of Land- Creating Plenty Of Space Around You! There Is A Large Study Off The Living Area And An Oversized Two Car Garage. Snuggle Up In The Family Room By The Woodburning Fireplace. Enjoy Your Beautiful Sunsets On The Covered Porch Overlooking The Lake! Some Updates Have Been Made! Come Make This One Your Own Today!','1.5255','44','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','Wood Burning Fireplace','1','Lake Livingston Area','Central Electric','1','EMERALD BAY BLK 2 LOT 1 & 2','Cleared,Water View','66449','Appraisal District','','156','0','','2','Electric Oven','0','','','Electric Range','','Composition','104 - Onalaska','ONALASKA ELEMENTARY SCHOOL','ONALASKA JR/SR HIGH SCHOOL','ONALASKA JR/SR HIGH SCHOOL','Appointment Required,Lockbox Front','Appraisal District','2','Craftsman','Emerald Bay','3430','1.7215','Aerobic,Public Water','2001','Appraisal District'); --> New record created successfully