Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)<br>Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)<br>Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)<br>Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)<br>Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)<br>Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)<br>Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)<br>Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)<br>Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)<br>Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)<br>Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)<br>Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)<br>Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)<br>Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)<br>Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)<br>Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)<br>Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)<br>Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)<br>Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)<br>Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)<br>Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)<br>Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)<br>Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)<br>Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)<br>Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)<br>Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)<br>Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)<br>Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)<br>Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)<br>Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)<br>Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)<br>Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)<br>Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)<br>Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)<br>Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)<br>Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)<br>Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)<br>Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)<br>Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)<br>Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)<br>Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)<br>Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)<br>Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)<br>Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)<br>Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)<br>Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)<br>Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)<br>Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)<br>Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)<br>Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)<br>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)<br>Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)<br>Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)<br>Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)<br>Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)<br>Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)<br>Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)<br>Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)<br>Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)<br>Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)<br>Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)<br>Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)<br>Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)<br>Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)<br>Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)<br>Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)<br>Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)<br>Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-13T08:41:02.543' ,`MLSNumber` = '29851687' ,`ListAgentFullName` = 'Jessica Armstrong' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.540772' ,`Longitude` = '-96.700553' ,`PhotoCount` = '23' ,`PostalCode` = '77836' ,`RoomCount` = '4' ,`ListPrice` = '399000.00' ,`Status` = 'Active' ,`StreetName` = 'Sunny St' ,`StreetNumber` = '105' ,`StreetSuffix` = '' ,`City` = 'Caldwell' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1050' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Investment opportunity for both residential and commercial!!! This +/- 1.59 Acres is located in the fast growing city of Caldwell, TX. Property has HWY 36 road frontage in a high traffic area close to the major intersection of HWY 21 and HWY 36. Features include a 2 bed/1 bath house and 2,000 Sq Ft shop along HWY 36 both being used as income producing. Many possibilities for a commercial business with a residential side income. Caldwell: To Austin: 83 miles, To Houston: 107 miles, To San Antonio: 142 miles To Dallas: 193 miles.' ,`Acres` = '1.59' ,`Area` = '59' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'See Remarks' ,`LotDesciption` = 'Cleared,Other' ,`LotSize` = '69260' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '209 - Caldwell' ,`SchoolElementary` = 'CALDWELL ELEMENTARY SCHOOL (CALDWELL)' ,`SchoolHigh` = 'CALDWELL HIGH SCHOOL' ,`SchoolMiddle` = 'CALDWELL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'N/A' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675090550' WHERE `Matrix_Unique_ID` = '205283355'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-13T08:17:55.463' ,`MLSNumber` = '34201703' ,`ListAgentFullName` = 'April Maki' ,`ListOfficeName` = 'Gehan Homes Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.563495' ,`Longitude` = '-95.021311' ,`PhotoCount` = '38' ,`PostalCode` = '77586' ,`RoomCount` = '6' ,`ListPrice` = '459990.00' ,`Status` = 'Active' ,`StreetName` = 'Harbourtown' ,`StreetNumber` = '1322' ,`StreetSuffix` = 'Court' ,`City` = 'Seabrook' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1857' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BRAND NEW 3-story Coastal Grey Exterior! This 1,857 SF home includes 3 beds, 2.5 baths, and study/flex space! The open concept is perfect for entertaining in the spacious family room, breakfast, & kitchen. The kitchen includes stainless steel appliances while offering ample storage & plenty of space to prepare meals on the oversized chef’s kitchen island, upgraded cabinetry, white & black modern tones, walk-in pantry all while overlooking your family & breakfast room. The second floor a includes a study/flex, with a half bath for your guests. The third floor includes two spacious bedrooms with a shared FULL bath & a utility room off the hallway. The private owner’s retreat offers a walk-in shower, his & hers closets & comforting garden tub. This home has a wonderful patio to enjoy the fresh smell of the water breeze. Old Seabrook Village is on the banks of the Seabrook Lagoon with waters fed by Galveston Bay & just two miles from the 60-acre themed Kemah Boardwalk.' ,`Acres` = '' ,`Area` = '7' ,`BuilderName` = 'Gehan Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Clear Lake Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 2 Block 1 Section A' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4189' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'BAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'SEABROOK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Call Occupant,No Supra Keybox,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Traditional' ,`Subdivision` = 'Old Seabrook Village' ,`TaxAmount` = '' ,`TaxRate` = '2.2' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675090550' WHERE `Matrix_Unique_ID` = '209013519'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-13T08:22:45.880' ,`MLSNumber` = '73778799' ,`ListAgentFullName` = 'April Maki' ,`ListOfficeName` = 'Gehan Homes Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.563495' ,`Longitude` = '-95.021311' ,`PhotoCount` = '50' ,`PostalCode` = '77586' ,`RoomCount` = '7' ,`ListPrice` = '499990.00' ,`Status` = 'Active' ,`StreetName` = 'Ashley' ,`StreetNumber` = '1513' ,`StreetSuffix` = 'Court' ,`City` = 'Seabrook' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2107' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BRAND NEW 3-story home you have been looking for featuring 2,107 sq ft of living space, 4 beds, 3 full baths, study/flex space & situated on a large cul-de-sac lot! The open concept living is perfect for entertaining in the spacious family room, breakfast, kitchen, & large chef’s kitchen Island. The gourmet kitchen has stainless steel appliances while offering ample storage & plenty of space to prepare meals on the oversized kitchen island overlooking your family & breakfast room. The second floor includes the family room, breakfast, OPEN kitchen with white/grey tones with an inviting study & secondary room with a full bath. The third floor includes two spacious bedrooms with a shared FULL bath, the utility room is connected to the large walk-in closet & a private owner’s retreat with dual vanities & walk-in shower. Old Seabrook Village is on the banks of the Seabrook Lagoon with waters fed by Galveston Bay & just two miles from the 60-acre themed Kemah Boardwalk.' ,`Acres` = '' ,`Area` = '7' ,`BuilderName` = 'Gehan Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Clear Lake Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 4 Block 1 Section A' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '8770' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'BAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'SEABROOK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Call Occupant,No Supra Keybox,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Traditional' ,`Subdivision` = 'Old Seabrook Village' ,`TaxAmount` = '' ,`TaxRate` = '2.2' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675090551' WHERE `Matrix_Unique_ID` = '209014091'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-13T08:42:24.630' ,`MLSNumber` = '88681115' ,`ListAgentFullName` = 'Abayomi Sanusi' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.616676' ,`Longitude` = '-95.570840' ,`PhotoCount` = '9' ,`PostalCode` = '77477' ,`RoomCount` = '5' ,`ListPrice` = '350000.00' ,`Status` = 'Active' ,`StreetName` = 'Boardwalk' ,`StreetNumber` = '219' ,`StreetSuffix` = 'Parkway' ,`City` = 'Stafford' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2470' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'COMPLETELY UPDATED! DESIRABLE HOME IN STAFFORD\'S PROMENADE COMMUNITY. EASIER CONNECTIONS TO MAJOR HIGHWAYS. THE BELTWAY, SOUTHWEST FREEWAY AND HIGHWAY 90. 4 BEDROOMS AND 3 FULL BATHROOMS.. MINUTES AWAY FROM THE MEDICAL CENTER.' ,`Acres` = '0.1648' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Stafford Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'THE PROMENADE AT STAFFORD RUN SEC 2, BLOCK 2, LOT 19' ,`LotDesciption` = 'Cleared,Other' ,`LotSize` = '7177' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '550' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '50 - Stafford' ,`SchoolElementary` = 'STAFFORD ELEMENTARY SCHOOL (STAFFORD MSD)' ,`SchoolHigh` = 'STAFFORD HIGH SCHOOL' ,`SchoolMiddle` = 'STAFFORD INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Lockbox Right Side,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'The Promenade At Stafford Run Sec 2' ,`TaxAmount` = '4857' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1997' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675090551' WHERE `Matrix_Unique_ID` = '209357712'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-13T08:22:17.957' ,`MLSNumber` = '49268807' ,`ListAgentFullName` = 'April Maki' ,`ListOfficeName` = 'Gehan Homes Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.564191' ,`Longitude` = '-95.022389' ,`PhotoCount` = '41' ,`PostalCode` = '77586' ,`RoomCount` = '6' ,`ListPrice` = '469990.00' ,`Status` = 'Active' ,`StreetName` = 'Ashley' ,`StreetNumber` = '1509' ,`StreetSuffix` = 'Court' ,`City` = 'Seabrook' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1857' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BRAND NEW 3-story Coastal Blue Exterior! This 1,857 SF home includes 3 beds, 2.5 baths, and study/flex space! The open concept is perfect for entertaining in the spacious family room, breakfast, and kitchen. The kitchen includes stainless steel appliances while offering ample storage & plenty of space to prepare meals on the oversized chef’s kitchen island, upgraded cabinetry, white and grey tones, walk-in pantry all while overlooking your family & breakfast room. The second floor also includes an inviting study/flex, with a half bathroom for your guests. The third floor includes two spacious bedrooms with a shared FULL bath, a utility room off the hallway and a private owner’s retreat with a walk-in shower, his and hers closets, and comforting garden tub. This home has a wonderful patio to enjoy the fresh smell of the water breeze. Old Seabrook Village is on the banks of the Seabrook Lagoon with waters fed by Galveston Bay & just two miles from the 60-acre themed Kemah Boardwalk.' ,`Acres` = '' ,`Area` = '7' ,`BuilderName` = 'Gehan Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Clear Lake Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 3 Block 1 Section A' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '5873' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'BAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'SEABROOK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Call Occupant,No Supra Keybox,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Traditional' ,`Subdivision` = 'Old Seabrook Village' ,`TaxAmount` = '' ,`TaxRate` = '2.2' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675090551' WHERE `Matrix_Unique_ID` = '209830170'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-13T08:04:38.530' ,`MLSNumber` = '59279030' ,`ListAgentFullName` = 'Anne Vickery' ,`ListOfficeName` = 'Anne Vickery & Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.146750' ,`Longitude` = '-95.215257' ,`PhotoCount` = '47' ,`PostalCode` = '77357' ,`RoomCount` = '9' ,`ListPrice` = '2538000.00' ,`Status` = 'Active' ,`StreetName` = 'Loop 494' ,`StreetNumber` = '20688' ,`StreetSuffix` = '' ,`City` = 'New Caney' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1846' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '9.49 Acres of Land... Charming one story brick home, with 2 car detached garage. Home features combination Living/Dining Room with a colorful accent wall and tray ceiling. Spacious Family Room includes decorative ceiling beams, wood-burning stove with brick surround, French doors leading to a back patio and adjoining covered patio. Eat-In Galley kitchen, breakfast bar, double ovens, lots of cabinets w/built-in china hutch & parquet flooring. Primary bedroom with \"En Suite\" equipped with shower/bathtub combination. Property offers excellent frontage on high traffic Loop 494. Easy access to Antique Lane, FM 1485 & I-69 (Hwy 59). Utilities available through New Caney MUD. \r\nIdeally suited for Residential, Townhomes, Multi-Family and Commercial Development.' ,`Acres` = '9.49' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Porter/New Caney East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'A0392 MCNAUGHTON FINDLEY, TRACT 31, ACRES 9.600' ,`LotDesciption` = 'Cleared' ,`LotSize` = '413384' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'OAKLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NEW CANEY HIGH SCHOOL' ,`SchoolMiddle` = 'KEEFER CROSSING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'MCNAUGHTON FINDLEY' ,`TaxAmount` = '8570' ,`TaxRate` = '2.6739' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1986' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675090551' WHERE `Matrix_Unique_ID` = '211583299'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-13T08:21:50.220' ,`MLSNumber` = '3201586' ,`ListAgentFullName` = 'April Maki' ,`ListOfficeName` = 'Gehan Homes Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.563495' ,`Longitude` = '-95.021311' ,`PhotoCount` = '4' ,`PostalCode` = '77586' ,`RoomCount` = '6' ,`ListPrice` = '549990.00' ,`Status` = 'Active' ,`StreetName` = 'Ashley' ,`StreetNumber` = '1505' ,`StreetSuffix` = 'Court' ,`City` = 'Seabrook' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2402' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BRAND NEW 3-story Coastal Modern Home! MUST SEE! This 2,402 SF home includes 3 beds, 2.5 baths & a spacious flex space! With the open-concept high ceilings & natural light this home is such a perfect fit for your family! The kitchen includes stainless steel appliances while offering ample storage & plenty of space to prepare meals on the oversized chef’s kitchen island, upgraded cabinetry, light colored selections, walk-in pantry all while overlooking your family & breakfast room. The second floor also includes a large flex space for whatever you desire with a half bath for your guests. The third floor includes two spacious beds with a shared FULL bath, a utility room & a private owner’s retreat with a spacious walk-in closet, dual vanities, & an oversized walk-in shower! This home has a wonderful patio to enjoy the nice sized corner lot! Old Seabrook Village is on the banks of the Seabrook Lagoon with waters fed by Galveston Bay. Est completion January 2023.' ,`Acres` = '' ,`Area` = '7' ,`BuilderName` = 'Gehan Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Clear Lake Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 2 Block 1 Section A' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '6415' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'BAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'SEABROOK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Call Occupant,No Supra Keybox,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Traditional' ,`Subdivision` = 'Old Seabrook Village' ,`TaxAmount` = '' ,`TaxRate` = '2.2' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675090552' WHERE `Matrix_Unique_ID` = '214331781'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-13T08:19:10.670' ,`MLSNumber` = '63066748' ,`ListAgentFullName` = 'April Maki' ,`ListOfficeName` = 'Gehan Homes Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.563495' ,`Longitude` = '-95.021311' ,`PhotoCount` = '4' ,`PostalCode` = '77586' ,`RoomCount` = '5' ,`ListPrice` = '474990.00' ,`Status` = 'Active' ,`StreetName` = 'Harbourtown' ,`StreetNumber` = '1342' ,`StreetSuffix` = 'Court' ,`City` = 'Seabrook' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1659' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BRAND NEW 2-story Coastal Home. This 1,659 SF home includes 3 beds, 2.5 baths. The open concept is perfect for entertaining in the spacious family room, breakfast, and kitchen. Your entire home sits on the second floor in this Coastal Series plan. High ceilings and natural light make this home such a perfect fit for your family! The kitchen includes stainless steel appliances while offering ample storage & plenty of space to prepare meals on the oversized chef’s kitchen island, upgraded cabinetry, a perfectly sized walk-in pantry, and light-colored selections. Walk down the hall to find your pocket office, large utility room, and half bath and your two spacious bedrooms with a shared FULL bath. The private owner’s retreat sits at the back of the home with a spacious walk-in shower, dual vanities, and an oversized walk-in closet! Old Seabrook Village is on the banks of the Seabrook Lagoon with waters fed by Galveston Bay. Est Completion January 2023!' ,`Acres` = '' ,`Area` = '7' ,`BuilderName` = 'Gehan Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Clear Lake Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 7 Block 1 Section A' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '3419' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'BAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'SEABROOK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Call Occupant,No Supra Keybox,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Old Seabrook Village' ,`TaxAmount` = '' ,`TaxRate` = '2.2' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675090552' WHERE `Matrix_Unique_ID` = '214357258'  --> Updated record success<br />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','215526270','1675090552','215526270','2022-12-13T07:50:42.707','71098947','Justin Dickey','Keller Williams Professionals','','','30.219760','-95.160655','35','77372','9','277490.00','Active','Babe Ruth','26012','Drive','Splendora','2','0','3','1668','Single-Family','Brand new 1 story 3 bedroom 2 bath 2 car garage. Colina Home features granite kitchen countertops, recessed lighting. high ceilings, Ceramic Tile flooring throughout the home, 2\" blinds throughout the home, Stainless Steel Appliances including 5 burner gas range and dishwasher, 42\" upper cabinets, Large single bowl under-mount kitchen sink. Ceramic tile backsplash in kitchen & bathrooms. Masterbath features a large garden tub with separate shower, large walk-in closet. 10-year warranty on frame and foundation, 25-year warranty on roof, and 30-year warranty on Hardi Plank. Covered back patio and extreme energy efficiencies to reduce cost. This Home is Move in ready December 2022. Call to schedule a showing now','','40','Colina Homes','','Electric Dryer Connections','','No Disclosures','1','','','Cleveland Area','Central Gas','1','Lot 13 Blk 2 Section 4','Subdivision Lot,Wooded','8717','Survey','','360','1','To Be Built/Under Construction','2','','0','','','Gas Range','','Composition','47 - Splendora','PEACH CREEK ELEMENTARY SCHOOL','SPLENDORA HIGH SCHOOL','SPLENDORA JUNIOR HIGH','Accompany','Builder','1','Traditional','Splendora Fields','','2.48','Public Sewer,Public Water','2022','Builder');  --> New record created successfully<br />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','215526451','1675090552','215526451','2022-12-13T07:51:57.380','10196039','Justin Dickey','Keller Williams Professionals','','','30.219657','-95.158068','50','77372','9','318886.00','Active','Cooperstown','26182','Way','Splendora','2','1','4','2340','Single-Family','BRAND NEW beautiful 2 story 4 bedroom 3 bath with a large living room, spacious kitchen, formal dining room and 2 car garage. Colina Home Features 42\" kitchen cabinets, gorgeous granite kitchen countertops, kitchen includes recess lighting, high ceilings, Ceramic Tile (wood look) flooring throughout the home. 2\" blinds throughout, stainless steel appliances including 5 burner gas range, microwave, and dishwasher. Large single bowl under-mount kitchen sink. Ceramic tile backsplash in kitchen and bathrooms. Master bath features a large double sized shower with bench seat, dual marble vanities, large walk in closet. 10 year warranty on frame and foundation, 25 year warranty on roof and 30 year warranty on Hardi plank. covered back patio and extreme energy efficiencies to reduce cost. This home is will be move in ready December 2022.\r\nPHOTOS ARE REPRESENTATIVE','','40','Colina Homes','','Electric Dryer Connections','','Mud','1','','','Cleveland Area','Central Gas','1','Lot 18 block 1 Section 4','Subdivision Lot','13011','Survey','','360','1','To Be Built/Under Construction','2','','0','','','Gas Range','','Composition','47 - Splendora','PEACH CREEK ELEMENTARY SCHOOL','SPLENDORA HIGH SCHOOL','SPLENDORA JUNIOR HIGH','Accompany','Builder','2','Traditional','Splendora Fields','','2.48','Public Sewer,Public Water','2022','Builder');  --> New record created successfully<br />