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-12-22T08:59:25.077' ,`MLSNumber` = '67548585' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'KB Home Houston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.842644' ,`Longitude` = '-95.811419' ,`PhotoCount` = '7' ,`PostalCode` = '77493' ,`RoomCount` = '10' ,`ListPrice` = '318256.00' ,`Status` = 'Active' ,`StreetName` = 'Lally Brook' ,`StreetNumber` = '4519' ,`StreetSuffix` = 'Court' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1693' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**home is under construction.** Escape the hustle and bustle of the city to this lovely KB Home in Katy Manor, boasting a brick front, vinyl plank flooring, wrought iron spindles, and an open great room. Spend afternoons in the kitchen, equipped with Silestone countertops, tile backsplash, stainless steel Energy Star® appliances, and 42-in. cabinets. Unwind in the tranquil primary suite, featuring extended dual vanities and a shower with a Moen Genta® WaterSense Showerhead. Additional home features include faux wood blinds and a covered patio. Located minutes from I-610, Hwy. 35, and Hwy. 288, residents enjoy an easy commute to the Texas Medical Center, Westchase District, and Downtown Houston. Shopping, dining, and entertainment can be found nearby at The Galleria and Pearland Town Center. The home is close to various parks, outdoor recreation, and the NRG Stadium. Zoned to Houston ISD.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'KB Home' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 12 Block 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '465' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'MCELWAIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Katy Manor' ,`TaxAmount` = '' ,`TaxRate` = '3.556' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675094215' WHERE `Matrix_Unique_ID` = '207838004' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-22T08:54:16.957' ,`MLSNumber` = '53328447' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'KB Home Houston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.023548' ,`Longitude` = '-95.331489' ,`PhotoCount` = '6' ,`PostalCode` = '77338' ,`RoomCount` = '8' ,`ListPrice` = '264995.00' ,`Status` = 'Active' ,`StreetName` = 'Morning Fern' ,`StreetNumber` = '6118' ,`StreetSuffix` = 'Lane' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1360' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**Home is under construction** Feel at ease in this gorgeous KB Home on a spacious lot in Flagstone, boasting a brick front, vinyl plank flooring, and an open great room. Entertain your guests in the kitchen, complete with Silestone countertops, a mosaic backsplash, stainless steel Energy Star® appliances, and 42-in. cabinets. Spend evenings relaxing in the primary suite, featuring extended dual vanities and a shower with a Moen Gibson® WaterSense showerhead. Additional home features include faux wood blinds. Residents of Flagstone enjoy a multi-acre park, a playground, a covered pavilion, and open play spaces. Situated near the Hardy Tollway, I-45, and I-69, find nearby shopping, dining, and entertainment at the popular Deerbrook Mall, Bush Intercontinental Airport, and Cypresswood Golf Club. Schools are a part of Aldine ISD.' ,`Acres` = '' ,`Area` = '12' ,`BuilderName` = 'KB Home' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Aldine Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 21 Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'OGDEN ELEMENTARY SCHOOL (ALDINE)' ,`SchoolHigh` = 'NIMITZ HIGH SCHOOL (ALDINE)' ,`SchoolMiddle` = 'TEAGUE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Flagstone' ,`TaxAmount` = '' ,`TaxRate` = '3.37' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675094215' WHERE `Matrix_Unique_ID` = '207841366' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-22T08:58:36.423' ,`MLSNumber` = '30830481' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'KB Home Houston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.482009' ,`Longitude` = '-95.470549' ,`PhotoCount` = '6' ,`PostalCode` = '77583' ,`RoomCount` = '11' ,`ListPrice` = '344287.00' ,`Status` = 'Active' ,`StreetName` = 'Escondido' ,`StreetNumber` = '7227' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosharon' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2526' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**Home is under construction.** Enjoy every moment spent in this beautiful KB Home on a spacious lot in Glendale Lakes, boasting a brick front, extended entry, and open great room. Entertain guests in the kitchen, equipped with granite countertops, stainless steel Energy Star® appliances, and 30-in. cabinets. Relax in the tranquil primary suite featuring extended dual vanities, a 42-in. Kohler Master Windward® tub, and a separate shower. Additional home features include a covered patio. Community comforts of Glendale lakes include a Jr. Olympic-sized swimming pool, a park, a playground, and a clubhouse. Situated off FM-521, Hwy 288, and Beltway 8, commuters enjoy the ease of access to Downtown Houston, Pearland, Sugar Land, and the Texas Medical Center. Zoned to Fort Bend ISD.' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'KB Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 16 Block 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '550' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'HERITAGE ROSE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Glendale Lakes' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675094215' WHERE `Matrix_Unique_ID` = '209177834' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-22T08:32:44.050' ,`MLSNumber` = '15310179' ,`ListAgentFullName` = 'Deysi Garcia' ,`ListOfficeName` = 'Doug Erdy Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.806287' ,`Longitude` = '-95.043037' ,`PhotoCount` = '33' ,`PostalCode` = '77562' ,`RoomCount` = '5' ,`ListPrice` = '779999.00' ,`Status` = 'Active' ,`StreetName` = 'Steele' ,`StreetNumber` = '807' ,`StreetSuffix` = 'Road' ,`City` = 'Highlands' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '5200' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous Custom Designed Home, single story 5 bed 3 1/2 bath, an extra room can be use as Gym/office, plenty of space, tray ceiling on most areas, custom kitchen.\r\na large Covered back patio makes it perfect for family parties/gatherings, with an outside fireplace there is no excuse not to be enjoying any time of the year, this is a must see.\r\n\r\nContact me or your Preferred Agent for a Private Showing.' ,`Acres` = '0.817' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TBA' ,`LotDesciption` = 'Other' ,`LotSize` = '35582' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'HOPPER/HIGHLANDS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GOOSE CREEK MEMORIAL' ,`SchoolMiddle` = 'HIGHLANDS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'WILLOW GROVE' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675094215' WHERE `Matrix_Unique_ID` = '209603122' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-22T08:52:14.123' ,`MLSNumber` = '58250130' ,`ListAgentFullName` = 'Vicki Brown' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.090027' ,`Longitude` = '-95.506730' ,`PhotoCount` = '18' ,`PostalCode` = '77389' ,`RoomCount` = '0' ,`ListPrice` = '1709000.00' ,`Status` = 'Active' ,`StreetName` = 'Gosling' ,`StreetNumber` = '22332' ,`StreetSuffix` = 'Road' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '0' ,`SqFtTotal` = '1336' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'EASY ACCESS TO 99 WHICH GIVES EASY ACCESS TO I45 AND 249. OLDER HOME ON PROPERTY IS NOT FOR SHOWING AND WILL BE REMOVED ON COMPLETION OF SALE. GREEN HOUSES ON PROPERTY ISARE USED FOR GROWING ORCHIDS AND WILL BE DISMANTLED AND REMOVED UPON SALE OF PROPERTY UNLESS BUYERS WANT AND NEGOTIATED A SALE OF THEM. ADJOINGING 8.5 ACREAGE IS ALSO FOR SALE AT THIS TIME. BUYER WILL NEED TO PURCHASE SURVEY.' ,`Acres` = '2.937' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Real Estate Owned' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Spring/Klein' ,`HeatSystem` = 'Butane' ,`HOAMandatory` = '0' ,`Legal` = 'TRS 14C-1 & 14C-2 ABST 280 L GOSLING' ,`LotDesciption` = 'Wooded' ,`LotSize` = '127936' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'NORTHAMPTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN OAK HIGH SCHOOL' ,`SchoolMiddle` = 'HILDEBRANDT INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'NA' ,`TaxAmount` = '5464' ,`TaxRate` = '2.124' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '1933' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675094216' WHERE `Matrix_Unique_ID` = '212225684' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-22T08:54:59.167' ,`MLSNumber` = '29761179' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'KB Home Houston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.023117' ,`Longitude` = '-95.331539' ,`PhotoCount` = '6' ,`PostalCode` = '77338' ,`RoomCount` = '9' ,`ListPrice` = '299677.00' ,`Status` = 'Active' ,`StreetName` = 'Topaz Pines' ,`StreetNumber` = '6219' ,`StreetSuffix` = 'Trail' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1780' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**Home is under construction** You don’t want to miss this brilliant KB home in Flagstone, boasting a brick front, tile flooring, wrought iron spindles, and an open great room. Master new recipes in the kitchen, complete with granite countertops, tile backsplash, stainless steel Energy Star® appliances, 42-in. cabinets, and a breakfast bar. The spa-like primary suite features extended dual vanities, a 42-in. Kohler Master Windward® tub, and a separate shower. Additional home features include cable pre-wiring and a covered patio. Residents of Flagstone enjoy a multi-acre park, a playground, a covered pavilion, and open play spaces. Situated near the Hardy Tollway, I-45, and I-69, find nearby shopping, dining, and entertainment at the popular Deerbrook Mall, Bush Intercontinental Airport, and Cypresswood Golf Club. Nearby schools are a part of Aldine ISD.' ,`Acres` = '' ,`Area` = '12' ,`BuilderName` = 'KB Home' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Aldine Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 12 Block 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'OGDEN ELEMENTARY SCHOOL (ALDINE)' ,`SchoolHigh` = 'NIMITZ HIGH SCHOOL (ALDINE)' ,`SchoolMiddle` = 'TEAGUE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Flagstone' ,`TaxAmount` = '' ,`TaxRate` = '3.37' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675094216' WHERE `Matrix_Unique_ID` = '213240818' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-22T08:53:19.830' ,`MLSNumber` = '47790928' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'KB Home Houston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.023548' ,`Longitude` = '-95.331489' ,`PhotoCount` = '6' ,`PostalCode` = '77338' ,`RoomCount` = '8' ,`ListPrice` = '259995.00' ,`Status` = 'Active' ,`StreetName` = 'Morning Fern' ,`StreetNumber` = '6214' ,`StreetSuffix` = 'Lane' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1360' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**Home is under construction** Love every moment spent in this stunning KB Home in Flagstone, which features a beautiful brick front, vinyl plank flooring, and an open great room. Spend quality time in the kitchen, equipped with Silestone countertops, stainless steel Energy Star® appliances, and 42-in. cabinets. Seek comfort in the tranquil primary suite, boasting extended dual vanities and a tub with a Moen Seena® WaterSense showerhead. Residents of Flagstone enjoy a multi-acre park, a playground, a covered pavilion, and open play spaces. Situated near the Hardy Tollway, I-45, and I-69, you can find nearby shopping, dining, and entertainment at the popular Deerbrook Mall, Bush Intercontinental Airport, and Cypresswood Golf Club. Nearby schools are a part of Aldine ISD.' ,`Acres` = '' ,`Area` = '12' ,`BuilderName` = 'KB Home' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Aldine Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 9 Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'OGDEN ELEMENTARY SCHOOL (ALDINE)' ,`SchoolHigh` = 'NIMITZ HIGH SCHOOL (ALDINE)' ,`SchoolMiddle` = 'TEAGUE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Flagstone' ,`TaxAmount` = '' ,`TaxRate` = '3.37' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675094216' WHERE `Matrix_Unique_ID` = '213409621' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-22T08:47:47.060' ,`MLSNumber` = '25602878' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'KB Home Houston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.367896' ,`Longitude` = '-95.019965' ,`PhotoCount` = '6' ,`PostalCode` = '77568' ,`RoomCount` = '7' ,`ListPrice` = '261318.00' ,`Status` = 'Active' ,`StreetName` = 'Green Jay' ,`StreetNumber` = '1321' ,`StreetSuffix` = 'Lane' ,`City` = 'La Marque' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1491' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**This home is under construction.** Find total comfort in this incredible KB Home in Sunset Grove, boasting a brick front, vinyl plank flooring, and an open great room. Entertain guests in the kitchen, equipped with granite countertops, stainless steel Energy Star® appliances, 30-in. cabinets, and pendant lighting. Spend evenings relaxing in the primary suite, featuring extended dual vanities and a tub with a Moen Chateau® WaterSense Showerhead. Additional home features include a fully equipped security system and faux wood blinds. Sunset Grove offers a park, playground, and covered pavilion for residents. Situated between I-45 and Hwy 6, residents take advantage of easy access to Galveston and Downtown Houston. Popular dining, shopping, and entertainment can be found at the nearby Tanger® Outlets and Baybrook Mall. Zoned to Hitchcock ISD.' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = 'KB Home' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'La Marque' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 13 Block 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '26 - Hitchcock' ,`SchoolElementary` = 'HITCHCOCK PRIMARY/STEWART ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HITCHCOCK HIGH SCHOOL' ,`SchoolMiddle` = 'CROSBY MIDDLE SCHOOL (HITCHCOCK)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sunset Grove' ,`TaxAmount` = '' ,`TaxRate` = '3.227' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675094216' WHERE `Matrix_Unique_ID` = '214620779' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-22T08:03:04.000' ,`MLSNumber` = '52048793' ,`ListAgentFullName` = 'Josh Rodriguez' ,`ListOfficeName` = 'Fathom Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.811372' ,`Longitude` = '-95.023780' ,`PhotoCount` = '12' ,`PostalCode` = '77562' ,`RoomCount` = '4' ,`ListPrice` = '224900.00' ,`Status` = 'Active' ,`StreetName` = 'Tracy' ,`StreetNumber` = '2406' ,`StreetSuffix` = 'Lane' ,`City` = 'Highlands' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1734' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Awesome Investment, needs a little cosmetic updating in a small subdivision very secluded and private. This nice home features recent laminate wood flooring, crown molding, Open concept, Kitchen/dinning combo, spacious living room, Nice chefs kitchen with lots of cabinets, Granite counter tops, Nice lighting. All bedrooms upstairs Huge Master bedroom with a grand master closet and Master Bath which includes separate Bath and Shower. Good size backyard including a concrete pad for your patio area. Located in Highlands with easy access to I-10 and a few minutes from 330 Spur to Hwy 146. Come see this nice home today!' ,`Acres` = '0.1404' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 22 BLK 2 NOWLINGSHIRE ESTATES PAR R/P' ,`LotDesciption` = 'Cleared' ,`LotSize` = '6118' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'HOPPER/HIGHLANDS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GOOSE CREEK MEMORIAL' ,`SchoolMiddle` = 'HIGHLANDS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Nowlingshire Estates Pt Repl' ,`TaxAmount` = '3989' ,`TaxRate` = '2.235' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675094216' WHERE `Matrix_Unique_ID` = '214702248' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-22T08:52:59.893' ,`MLSNumber` = '86760565' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'KB Home Houston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.023548' ,`Longitude` = '-95.331489' ,`PhotoCount` = '6' ,`PostalCode` = '77338' ,`RoomCount` = '7' ,`ListPrice` = '252623.00' ,`Status` = 'Active' ,`StreetName` = 'Morning Fern' ,`StreetNumber` = '6150' ,`StreetSuffix` = 'Lane' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1234' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**Home is under construction** This fantastic KB Home in Flagstone could be your dream home, boasting a beautiful brick front and stone veneer, plus an open great room. Spend all day in the island kitchen, fully equipped with granite countertops, stainless steel Energy Star® appliances, and 42-in. cabinets. The tranquil primary suite features extended dual vanities and a tub with a Moen Seena® WaterSense showerhead. Residents of Flagstone enjoy a multi-acre park, a playground, a covered pavilion, and open play spaces. Situated near the Hardy Tollway, I-45, and I-69, find nearby shopping, dining, and entertainment at the popular Deerbrook Mall, Bush Intercontinental Airport, and Cypresswood Golf Club. Nearby schools are a part of Aldine ISD.' ,`Acres` = '' ,`Area` = '12' ,`BuilderName` = 'KB Home' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Aldine Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 13 Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'OGDEN ELEMENTARY SCHOOL (ALDINE)' ,`SchoolHigh` = 'NIMITZ HIGH SCHOOL (ALDINE)' ,`SchoolMiddle` = 'TEAGUE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Flagstone' ,`TaxAmount` = '' ,`TaxRate` = '3.37' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675094217' WHERE `Matrix_Unique_ID` = '215059189' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-22T07:11:05.290' ,`MLSNumber` = '29246541' ,`ListAgentFullName` = 'Lida Aria' ,`ListOfficeName` = 'Main Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.557276' ,`Longitude` = '-95.601780' ,`PhotoCount` = '50' ,`PostalCode` = '77479' ,`RoomCount` = '10' ,`ListPrice` = '439900.00' ,`Status` = 'Active' ,`StreetName` = 'BRATTON' ,`StreetNumber` = '4031' ,`StreetSuffix` = 'Street' ,`City` = 'Sugar Land' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2544' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '****OPEN HOUSE SATURDAY DEC 10 - BETWEEN 1-3 PM***Beautifully ONE STORY WITH 3 CAR GARAGE AND PLENTY YARD FOR POOL. ONE OF THE LARGEST AND PRIVATE lots IN THE NEIGHBORHOOD LOCATED IN the heart of Sugar Land! cul-de-sac street, no backyard neighbors, boat slab in the backyard next to the garage, never flooded, and almost an acre of land as the parcel size. You have first greeted an open floor plan with formal dining, study OR 4 TH BEDROOM with French doors, and a huge family room with vaulted ceilings and a wall of windows that let in tons of natural light—upgraded gourmet kitchen with SS appliances. Fantastic master retreat with oversized master bathroom w/ large walk-in his & her closets. Large secondary bedrooms. Come home and unwind on your beautiful patio w/ lush landscaping. you are zoned to ALL exemplary schools. Minutes away from many amenities. Easy access to major highways. Low tax rate and so much more!' ,`Acres` = '' ,`Area` = '29' ,`BuilderName` = 'PERRY HOMES' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 30 BLK 1 SEC 2 OXFORD' ,`LotDesciption` = 'Cul-De-Sac,Greenbelt,Subdivision Lot' ,`LotSize` = '17483' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '850' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'COMMONWEALTH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEMENTS HIGH SCHOOL' ,`SchoolMiddle` = 'FORT SETTLEMENT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'OXFORD/COMMONWEALTH' ,`TaxAmount` = '' ,`TaxRate` = '2.2' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1989' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675094217' WHERE `Matrix_Unique_ID` = '215107786' --> 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','215170753','1675094217','215170753','2022-12-22T08:53:51.763','75573224','Lance Loken','KB Home Houston','','','30.023548','-95.331489','6','77338','8','262470.00','Active','Topaz Pines','6211','Trail','Humble','2','0','3','1360','Single-Family','**Home is under construction** Fall in love with this stunning KB Home in Flagstone, which features a beautiful brick front and open great room. Spend all day in the kitchen, complete with Silestone countertops, stainless steel Energy Star® appliances, and 42-in. cabinets. The spa-like primary suite boasts extended dual vanities and a tub with a Moen Seena® WaterSense showerhead. Additional home features include full gutters and a covered patio. Residents of Flagstone enjoy a multi-acre park, a playground, a covered pavilion, and open play spaces. Situated near the Hardy Tollway, I-45, and I-69, find nearby shopping, dining, and entertainment at the popular Deerbrook Mall, Bush Intercontinental Airport, and Cypresswood Golf Club. Nearby schools are a part of Aldine ISD.','','12','KB Home','','Electric Dryer Connections,Washer Connections','','Mud','1','','','Aldine Area','Central Gas','1','Lot 14 Block 3','Subdivision Lot','','','','400','1','To Be Built/Under Construction','2','Single Oven','0','','','Freestanding Range,Gas Range','','Composition','1 - Aldine','OGDEN ELEMENTARY SCHOOL (ALDINE)','NIMITZ HIGH SCHOOL (ALDINE)','TEAGUE MIDDLE SCHOOL','Appointment Required','Builder','1','Traditional','Flagstone','','3.37','Public Sewer,Public Water,Water District','2023','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','215170990','1675094217','215170990','2022-12-22T08:55:25.937','2427779','Lance Loken','KB Home Houston','','','30.023117','-95.331539','6','77338','9','291380.00','Active','Topaz Pines','6215','Trail','Humble','2','1','3','1780','Single-Family','**Home is under construction** Enjoy every moment spent in this fantastic KB Home in Flagstone, boasting a brick front, vinyl plank flooring, wrought iron spindles, and an open great room. No recipe is a challenge in the kitchen, equipped with granite countertops, stainless steel Energy Star® appliances, 42-in. cabinets, and a breakfast bar. Take a well-deserved break in the kitchen, equipped with extended dual vanities, a 42-in. Kohler Master Windward® tub, and a separate shower. Additional home features include faux wood blinds. Residents of Flagstone enjoy a multi-acre park, a playground, a covered pavilion, and open play spaces. Situated near the Hardy Tollway, I-45, and I-69, find nearby shopping, dining, and entertainment at the popular Deerbrook Mall, Bush Intercontinental Airport, and Cypresswood Golf Club. Nearby schools are a part of Aldine ISD.','','12','KB Home','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud','1','','','Aldine Area','Central Gas','1','Lot 13 Block 3','Subdivision Lot','','','','400','1','To Be Built/Under Construction','2','Single Oven','0','','','Freestanding Range,Gas Range','','Composition','1 - Aldine','OGDEN ELEMENTARY SCHOOL (ALDINE)','NIMITZ HIGH SCHOOL (ALDINE)','TEAGUE MIDDLE SCHOOL','Appointment Required','Builder','2','Traditional','Flagstone','','3.37','Water District','2023','Builder'); --> New record created successfully