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-15T11:38:38.533' ,`MLSNumber` = '428413' ,`ListAgentFullName` = 'Rosalinda Frias' ,`ListOfficeName` = 'Manor, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.774651' ,`Longitude` = '-95.371372' ,`PhotoCount` = '24' ,`PostalCode` = '77007' ,`RoomCount` = '7' ,`ListPrice` = '619999.00' ,`Status` = 'Active' ,`StreetName` = 'Hickory' ,`StreetNumber` = '1905' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2265' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful new construction in the highly-desired Houston Height walking distance from parks and restaurants. The home features a spacious roof terrace with downtown view, private driveway 2 car garage. Elegant interior fixtures, stainless steel appliances, no carpet. Balcony is accessible from living area on second floor great for entertaining. LAST UNIT LEFT.' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = 'Greyden Building' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Washington East/Sabine' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 2 BLK 1 Shearn Heights' ,`LotDesciption` = 'Patio Lot' ,`LotSize` = '1600' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'CROCKETT ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Traditional' ,`Subdivision` = 'Shearn Heights' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675151830' WHERE `Matrix_Unique_ID` = '209020875' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-15T11:45:43.077' ,`MLSNumber` = '82597498' ,`ListAgentFullName` = 'Shirley Stewart' ,`ListOfficeName` = 'Keller Williams Realty - Clear Lake/ NASA' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.437511' ,`Longitude` = '-95.099628' ,`PhotoCount` = '45' ,`PostalCode` = '77539' ,`RoomCount` = '13' ,`ListPrice` = '789000.00' ,`Status` = 'Active' ,`StreetName` = 'Lovers Lane' ,`StreetNumber` = '4017' ,`StreetSuffix` = 'Lane' ,`City` = 'Dickinson' ,`BathsFull` = '5' ,`BathsHalf` = '0' ,`BedsTotal` = '6' ,`SqFtTotal` = '5374' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'SECLUDED COUNTRY SETTING with mature trees and a producing pear tree. Large oak and pine trees on park like setting yet close to all the convenience of city living. Spacious home with plenty of bedrooms and baths for the family to spread out and have their own space. Updated kitchen with soft close cabinets. Room for a pool table or a place to store your wine. Baths have been updated and primary bath with spa tub. Downstairs apartment with kitchenette and bath plus exterior door for private entrance. HOME HAS NEVER FLOODED!\r\nCOME AND ENJOY THE TRANQUIL SETTING OF THIS FANTASTIC HOME.\r\n2022 TAXES ARE INCORRECT. APPRASIAL DISTRICT IN PROCESS OF CORRECTING.' ,`Acres` = '1.781' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Dickinson' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 19 PAGE 12 PERRY & AUSTIN SUR TR 59 1.781 ACRS' ,`LotDesciption` = 'Cleared,Subdivision Lot,Wooded' ,`LotSize` = '77580' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'LOBIT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'LOBIT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Perry & Austin Upr League #59' ,`TaxAmount` = '9624' ,`TaxRate` = '2.5214' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1986' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675151831' WHERE `Matrix_Unique_ID` = '212585067' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-15T11:43:18.280' ,`MLSNumber` = '68930974' ,`ListAgentFullName` = 'Dawn Faust' ,`ListOfficeName` = 'Flat Fee Discount Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.114598' ,`Longitude` = '-95.703866' ,`PhotoCount` = '25' ,`PostalCode` = '77355' ,`RoomCount` = '10' ,`ListPrice` = '698500.00' ,`Status` = 'Active' ,`StreetName` = 'Mccall' ,`StreetNumber` = '15202' ,`StreetSuffix` = 'Park' ,`City` = 'Magnolia' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4160' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New roof 2020, new carpet, whole home water softener, central vacuum. Beautiful two story home that is perfectly nestled on a 1 acre lot with lush green grass in McCall Sound! When you enter the home you\'re greeted in an open foyer, a large dining room, great for entertaining. A formal living, family room with fireplace, home office, open kitchen with granite countertops, stainless steel appliances. Two primary bedrooms with two separate closets, open primary bath with dual vanities separate shower and tub.' ,`Acres` = '1' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tomball' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S694902 - MCCALL SOUND 02, BLOCK 2, LOT 1, ACRES 1' ,`LotDesciption` = 'Corner' ,`LotSize` = '43560' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'DECKER PRAIRIE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'TOMBALL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Mccall Sound 02' ,`TaxAmount` = '10518' ,`TaxRate` = '1.9215' ,`WaterSewer` = 'Aerobic,Public Water' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675151831' WHERE `Matrix_Unique_ID` = '213162945' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-15T11:13:30.650' ,`MLSNumber` = '50847284' ,`ListAgentFullName` = 'St John Okeke' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.833884' ,`Longitude` = '-95.794333' ,`PhotoCount` = '25' ,`PostalCode` = '77493' ,`RoomCount` = '13' ,`ListPrice` = '380000.00' ,`Status` = 'Active' ,`StreetName` = 'Prairie Glen' ,`StreetNumber` = '24211' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2635' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This energy-efficient home is built to impress with a formal dining in the Somerville\'s first floor flex space. A pocket office and spacious laundry room simplify work and chores. Upstairs, the game room will be your sports watching headquarters. Don\'t forget the amazing Katy school districts and this property has no neighbors behind you. Katy Pointe is located in a prime location in one of greater Houston’s hottest markets with easy access to the Grand Parkway, Katy Freeway, and a convenient commute to major employers. Known for their energy-efficient features, our homes help you live a healthier and quieter lifestyle while saving thousands of dollars on utility bills. Come see this beautiful home today!!!' ,`Acres` = '0.1319' ,`Area` = '25' ,`BuilderName` = 'MERITAGE HOMES' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 11 BLK 3 KATY POINTE SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5746' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '590' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'BETHKE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKDICK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Katy Point' ,`TaxAmount` = '9918' ,`TaxRate` = '3.4768' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675151831' WHERE `Matrix_Unique_ID` = '213511072' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-15T11:32:59.057' ,`MLSNumber` = '27390299' ,`ListAgentFullName` = 'Nicole Freer' ,`ListOfficeName` = 'NICOLE FREER GROUP' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.402040' ,`Longitude` = '-95.059551' ,`PhotoCount` = '25' ,`PostalCode` = '77568' ,`RoomCount` = '8' ,`ListPrice` = '374987.00' ,`Status` = 'Active' ,`StreetName` = 'Sweet Bay' ,`StreetNumber` = '2202' ,`StreetSuffix` = 'Drive' ,`City` = 'Texas City' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2522' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'ASHTON WOODS NEW CONSTRUCTION - Welcome home to 2202 Sweet Bay Drive in the community of Lago Mar and zoned to Dickinson ISD. The Jackson floorplan features 4 bedrooms, 2 full baths, and 1 half bath an attached 2 car garage and over 2,500 square feet of living space. Don\'t forget to step out back for a view of the backyard. You don\'t want to miss all this gorgeous home has to offer! Estimated completion is February 2023. Call to schedule your showing today! Days on market reflect the number of days the home has been under construction.' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = 'Ashton Woods' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lago Mar Section 5, Lot 1, Block 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5400' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1330' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'LOBIT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'LOBIT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lago Mar' ,`TaxAmount` = '' ,`TaxRate` = '3.55' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675151831' WHERE `Matrix_Unique_ID` = '214297397' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-15T11:00:06.477' ,`MLSNumber` = '60859643' ,`ListAgentFullName` = 'John Harcrow' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.365831' ,`Longitude` = '-96.122098' ,`PhotoCount` = '45' ,`PostalCode` = '77868' ,`RoomCount` = '6' ,`ListPrice` = '324900.00' ,`Status` = 'Active' ,`StreetName` = 'Three Wood Way' ,`StreetNumber` = '2405' ,`StreetSuffix` = '' ,`City` = 'Navasota' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1829' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '2-10 Home Builders Warranty on all High Road Homes! Come see the stunning (MOVE IN READY!)Destiny plan, brick & stone Elevation B on a highly sought-after Golf Course View Lot. This 3 bedroom 2 bath home w/ large covered back porch, stone covered entry & 3 car garage is a dream! The separate dining room in the Destiny plan is a stand-out feature or use it as an office! The interior features incl. an open living concept, spacious kitchen w/ GE Stainless Steel appliances, 42\" maple shaker cabinetry, granite counters & gas range. Ceiling fans in family room & ALL bedrooms! Insulated Vinyl Double pane windows, insulated exterior doors, 2-inch faux blinds, Pex plumbing, Tankless Water Heater, TAMKO® Heritage Laminated shingles, exterior 4-sided brick w/ Sherwin Williams exterior & interior paint, sod package w/ full sprinkler system & front yard landscaping package.16 Seer HVAC, R30 attic w/ LP Tech Shield, and R 13 Insulation. See attached Features Sheet for all builder offerings.' ,`Acres` = '' ,`Area` = '60' ,`BuilderName` = 'High Road Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Pecan Lakes Estates Phase 3 Sec 2, Block 8, Lot 9' ,`LotDesciption` = 'On Golf Course,Subdivision Lot' ,`LotSize` = '11329' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '129 - Navasota' ,`SchoolElementary` = 'BRULE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NAVASOTA HIGH SCHOOL' ,`SchoolMiddle` = 'NAVASOTA JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Pecan Lakes Estates' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675151832' WHERE `Matrix_Unique_ID` = '214721540' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-15T12:44:17.780' ,`MLSNumber` = '12342659' ,`ListAgentFullName` = 'Walter Cole' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.131099' ,`Longitude` = '-95.386145' ,`PhotoCount` = '31' ,`PostalCode` = '77386' ,`RoomCount` = '11' ,`ListPrice` = '359900.00' ,`Status` = 'Active' ,`StreetName` = 'Sunset Falls' ,`StreetNumber` = '30407' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2820' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'READY FOR IMMEDIATE MOVE IN! Welcome to the the gated community of Legends Ranch offering jogging trails, lakes, splash pad for little ones, pool and children\'s playground. This executive home offers four oversized bedrooms and three and a half baths. The chefs kitchen is open to the family room making it easy to entertain with family and guests. The kitchen offers Corian countertops, stainless appliances, gas cooking and a breakfast bar. You will also appreciate the large formal dining room, study with glass french doors and a large breakfast area. The home also features a gas fireplace,huge gameroom upstairs, primary bedroom downstairs with two closets, linoleum plank flooring in master bedroom, sprinkler system, recent roof, recent garage doors installed, and much more! This location offers easy access to Hardy toll road and highway 99.' ,`Acres` = '0.114' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S328305 - CANYON GATE AT LEGENDS RANCH 05, BLOCK 1, LOT 16' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '4968' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '990' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'BIRNHAM WOODS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GRAND OAKS HIGH SCHOOL' ,`SchoolMiddle` = 'YORK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Canyon Gate At Legends Ranch 0' ,`TaxAmount` = '8809' ,`TaxRate` = '2.5587' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675151832' WHERE `Matrix_Unique_ID` = '215086238' --> 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','215161135','1675151832','215161135','2023-01-15T12:45:59.753','18598585','Walter Cole','Coldwell Banker Realty','','','30.668199','-94.971599','49','77351','8','599900.00','Active','Fm 1988','2027','','Livingston','2','0','3','1779','Single-Family','38.72 (+/-) acre rustic ranch style brick home sitting just off FM 1988 S. This property has very close proximity to HWY 59 giving you easy access to historic downtown Livingstons shopping, grocery stores and restaurants. The ranch offers 3 bedrooms, 2 baths, dining room, large family room and gameroom. The kitchen is located off the family room making it perfect for entertaining. Out back you will enjoy a large 20x10 covered rear patio overlooking the wooded acreage. The property offers a fenced 10 acre pasture available for your horses or cattle to run plus 24 wooded acres just east of the pasture that goes all the way back to Long King Creek. These approx 38 acres are located from 2027 FM 1988 South where the home is located and goes East all the way to Long King Creek. The acreage hunts large from open pastures to deep cover woods and offers plenty of wildlife with the water supply from Long King Creek. This 38.72 +/- acres consists of 2 tracts. (15345 and 67758','38.72','44','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','Freestanding,Wood Burning Fireplace','1','Livingston Area','Central Electric','0','ABST 56 JOSEPH MORGAN SURVEY TRACT 88','Greenbelt,Wooded','1686643','Appraisal District','','','0','','2','','0','','','','','Composition','103 - Livingston','LISD OPEN ENROLL','LIVINGSTON HIGH SCHOOL','LIVINGSTON JUNIOR HIGH SCHOOL','Appointment Required,No Supra Keybox','Appraisal District','1','Ranch','JOSEPH MORGAN','3463','1.8745','Septic Tank,Well','1967','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','215170081','1675151832','215170081','2023-01-15T12:29:49.523','66048880','Cynthia Pyle','JLA Realty','','','30.204207','-95.706840','24','77354','4','175000.00','Active','LITTLE THORN LN','37803','','Magnolia','2','0','3','2432','Single-Family','Mobile Home on 1/2 acre corner lot. 3 bedrooms with Large Master. Kitchen w/island and lots of cabinet space. Covered front porch and covered side deck. Fenced back yard. 2 car carport. 18x14 She Shed/workshop. Washer/Dryer included.','','15','','','Electric Dryer Connections,Washer Connections','','Estate,Sellers Disclosure','1','','','Magnolia/1488 West','Central Electric','0','HAZY HOLLOW EAST EST 11, BLOCK 71, LOT 20, SERIAL # CLW02619','Corner','22215','Appraisal District','','','0','','0','','0','','','Electric Range','','Aluminum','36 - Magnolia','WILLIE E. WILLIAMS ELEMENTARY SCHOOL','MAGNOLIA WEST HIGH SCHOOL','MAGNOLIA JUNIOR HIGH SCHOOL','Accompany,Appointment Required,Controlled Access','Appraisal District','1','Other Style','Hazy Hollow East Est M/H','','','Public Water,Septic Tank','2007','Seller'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215428058','1675151832','215428058','2023-01-15T11:26:42.267','67723902','Heba Hassan','SKW Realty','','','29.667375','-95.575344','26','77099','6','299990.00','Active','Panther','11108','Court','Houston','2','1','4','2031','Single-Family','Beautiful home located in a gated community at Panther Oaks subdivision. The subdivision is surrounded with restaurants, entertainment, shopping, school, and much more. The beautiful baltic brown counter top with elegant walnut cabinets is the perfect combination that makes the kitchen stand out. The backyard of the house is totally remarkable, there is a covered detach patio with shinny finished floor for your outdoor needs. You can simply relax or having family/friends over and enjoyed the great outdoors. The master bedroom of the house comes with a shower and bathtub, white sink and counter with walnut cabinets. There is plenty of space in the house.','0.0939','28','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','Stafford Area','Central Electric','1','LT 16 BLK 1 PANTHER OAKS','Subdivision Lot','4090','Appraisal District','','750','0','','2','Electric Oven','0','','','Electric Range','','Composition','2 - Alief','SMITH ELEMENTARY SCHOOL (ALIEF)','AISD DRAW','OLLE MIDDLE SCHOOL','Appointment Required','Appraisal District','2','Traditional','Panther Oaks','4436','2.4411','Other Water/Sewer','2015','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','215478442','1675151832','215478442','2023-01-15T12:22:42.893','38958293','Roxana Blanco','Anne Vickery & Associates','','','30.055610','-95.635746','41','77377','8','795000.00','Active','Lowell','13811','Avenue','Tomball','3','1','4','3981','Single-Family','Acreage close to the city! Location and extras sets this Home apart from others. Come see this custom 1.5 story home in Boudreaux estates with 1.5 acres. Home has 11 rooms consisting of 4/5 bedrooms, 3.5 bath, open kitchen with large maple cabinets and high end appliances (Kitchenaid), built in bar, media room, upstairs room with a half bath, one oversized bedroom for kids to have a living room area or mother in law suite with a full bathroom, Master has a gorgeous view of the back yard with access to the patio, large screened in covered patio with hot tub, crown molding throughout, upgraded shutters and niches all around the home. Build in surround system, build in cameras with audio, and water softener are some of the additional features. Enjoy nature from your back yard, lots of trees on this property. Home has 2 powered buildings. An insulated building can be used for many things, gym, man cave, extra apartment, etc. Private parking with an automatic gate entering the driveway.','1.5','35','','','Electric Dryer Connections,Washer Connections','','Exclusions,Owner/Agent','1','Gas Connections','1','Tomball Southwest','Propane','1','LT 15 BOUDREAUX ESTATES SEC 1 U/R ABST 722 A SENECHAL','Corner','65340','Appraisal District','','115','0','','3','Double Oven,Electric Oven','0','','','Gas Cooktop','','Composition','53 - Tomball','ROSEHILL ELEMENTARY SCHOOL','TOMBALL HIGH SCHOOL','TOMBALL JUNIOR HIGH SCHOOL','Appointment Required,Leave Business Card,Request Online Appointment,Supra Keybox','Appraisal District','1','Traditional','Boudreaux Estates Sec 1','14887','2.0872','Aerobic,Public Water','2009','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','215641690','1675151832','215641690','2023-01-15T12:43:26.487','11400991','Walter Cole','Coldwell Banker Realty','','','30.139147','-95.490402','25','77380','9','349990.00','Active','Royal Oaks','3223','Drive','Spring','2','0','4','2022','Single-Family','This property owner spared no expense on this remodel with either materials or craftsmanship. The home has been updated with beautiful wood grain plank tile flooring throughout the entirety of the home. The kitchen is open to the living area making it ideal for entertaining family and friends. This kitchen features quartzite countertops and a matching backsplash as well as new stainless steel appliances, walk in pantry and farm sink. The kitchen cabinets are all new and include Soft-close cupboards and drawers . The oversized master suite offers a barn door welcoming you into the completely remodeled master bath featuring a marble standing shower, dual sinks and large walk in closet. Bedrooms 2 and 3 share the hallway jack and jill bath that provides a tub and shower combination including triple mirrors with dual sinks. Other new upgrades: Interior and exterior paint, roof, plumbing, electrical and rear French doors. Additional gated boat and or RV parking is on the side of property.','0.2755','15','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','0','Spring/Klein','Central Gas','1','TIMBER LAKES 01, LOT 63','Subdivision Lot,Wooded','12000','Appraisal District','','67','0','','2','Electric Oven','0','','','Gas Range','','Composition','11 - Conroe','GLEN LOCH ELEMENTARY SCHOOL','THE WOODLANDS COLLEGE PARK HIGH SCHOOL','KNOX JUNIOR HIGH SCHOOL','Appointment Required,Lockbox Front,No Supra Keybox','Appraisal District','1','Traditional','Timber Lakes 01','5992','2.5954','Public Sewer,Public Water','1970','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','215908051','1675151832','215908051','2023-01-15T12:33:21.757','75877863','Claudette Callebs','Taylor Real Estate Group, Inc.','','','30.068399','-95.184264','17','77345','6','250000.00','Active','Glenwood Springs','3627','Drive','Houston','2','0','3','2036','Single-Family','Lowest price point in the neighborhood, never flooded and is priced to sell! One story, 3-bedroom, 2 bathrooms, updated and opened up from the original floor plan. Large backyard with lush landscaping. Oversized garage and huge walk-in pantry. Roof - 2011, all but three windows have been replaced with double pane, HVAC 2011, Furnace 2021, some plumbing replaced with pex, gas furnace, attic storage and oversized garage with extra storage. Fireplace plumbed for gas/or wood burning.','0.2057','32','','','','','Sellers Disclosure','','','1','Kingwood East','Central Electric','1','LT 27 BLK 1 GREENTREE VILLAGE SEC 1 AMEND','Subdivision Lot','8960','Appraisal District','','450','0','','2','','0','','','','','Composition','29 - Humble','GREENTREE ELEMENTARY SCHOOL','KINGWOOD HIGH SCHOOL','CREEKWOOD MIDDLE SCHOOL','Appointment Required,Lockbox Front,Supra Keybox','Appraisal District','1','Contemporary/Modern','Greentree Village Sec 01 Amd','6712','2.5839','Public Sewer,Public Water','1981','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','216055763','1675151832','216055763','2023-01-15T11:56:37.167','76481239','Darla Ortiz','Colesio Real Estate, LLC','','','28.953647','-95.966852','21','77414','3','209990.00','Active','Spruce Street','1920','','Bay City','2','0','3','1282','Single-Family','NEW CONSTRUCTION HOME to be completed in February of 2023. This well built contemporary home will be beautiful when completed! Will be Located in the South City Limits, of Bay City, Texas! 3 bedrooms, 2 bath with a 1 car garage, giving you 1282 sq ft. of spacious wonderful living. You will find lovely tile flooring throughout, with Carpet in the bedrooms and LED lighting brightens all the rooms. Enjoy an open concept for living area, dining & kitchen. Your kitchen includes brand name stainless steel appliances, tiled backsplash, along w/solid granite countertops & nickel brushed hardware. Relax in your spacious Master Bedroom w/master bath & big closet. This home is all electric, w/low E insulated energy efficient windows, 16-Seer Air Conditioning System, fresh air filtration, Sherwin Williams designer paint on walls & ceilings. ***Warranty: 1 year workmanship, 2-year mechanical, 10-year structural. THIS HOME IS WAITING FOR YOU!','','54','AWARD Homes','','Electric Dryer Connections','','Other Disclosures','1','','','','Central Electric','0','Lot 6, Blk 1, Spruce Terrace Subdv. Matagorda County, Texas','Subdivision Lot','7938','Other','','','1','To Be Built/Under Construction','1','Electric Oven','0','','','Electric Range','','Composition','132 - Bay City','TENIE HOLMES ELEMENTARY SCHOOL','BAY CITY HIGH SCHOOL','BAY CITY JUNIOR HIGH SCHOOL','Lockbox Front','Builder','1','Contemporary/Modern','SPRUCE TERRACE S/D','','','Public Sewer,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','216176157','1675151832','216176157','2023-01-15T12:55:38.920','72497249','Lisa Gilbreth','Clark Warthen Properties','','','29.676595','-95.469768','32','77096','18','915000.00','Active','Braesheather','5131','Drive','Houston','6','2','7','6207','Single-Family','Welcome to this home! Seven bedrooms, six baths and two half baths. Zoned to Bellaire HS. It has a guest suite complete with kitchen, living area, bedroom and bath on the ground floor! Perfect for extended family or a nanny.\r\nThe kitchen is a dream with 48\" Bertazzoni range, separate icemaker on the wet bar, quartz countertops, carrera marble and subway tile backsplash. The flooring is wood look tile and slate throughout the downstairs living areas. Three A/Cs were replaced in 2019.\r\nThe outdoor space has a large (~37K gallon) pool with half bath, extensive patio with more yard behind the garage.\r\nThis property has one of the largest lots in the area.\r\nExclusions: washer, dryer, utility room refrigerator & freezer, suite microwave & frig and 2 attached TVs\r\nVerify room measurements. Notice for showing is 2 hours.','0.4051','20','','','Electric Dryer Connections,Washer Connections','','Exclusions,Sellers Disclosure,Special Addendum','1','','','Meyerland Area','Central Gas,Zoned','1','LT 4 BLK 25 MEYERLAND SEC 8 R/P I','Subdivision Lot','17646','Appraisal District','','','0','','2','Convection Oven,Double Oven,Electric Oven,Freestanding Oven','1','Gunite,In Ground','','Gas Cooktop','','Composition','27 - Houston','KOLTER ELEMENTARY SCHOOL','BELLAIRE HIGH SCHOOL','MEYERLAND MIDDLE SCHOOL','Appointment Required,Controlled Access,Lockbox Back,No Photos/No Videos,Supra Keybox','Appraisal District','2','Contemporary/Modern','Meyerland Sec 08 R/P I','17326','2.3307','Public Sewer,Public Water','1964','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','216358421','1675151832','216358421','2023-01-15T11:07:18.163','85737276','St John Okeke','eXp Realty, LLC','','','29.507380','-95.430653','11','77583','6','265000.00','Active','Gardenspring','13408','Court','Rosharon','2','1','4','2259','Single-Family','Motivated Seller!!! Please come and submit all offers for this nice starter home in the SAVANNAH BEND subdivision. This won\'t be available for too long!!!','0.3581','5','','','','','Sellers Disclosure,Short Sale','','','1','Alvin North','Central Gas','1','SAVANNAH BEND SEC 1 (A0562 HT&BRR) BLK 1 LOT 61','Subdivision Lot','15599','Appraisal District','','670','0','','2','','0','','','','','Composition','3 - Alvin','SAVANNAH LAKES ELEMENTARY SCHOOL','MANVEL HIGH SCHOOL','MANVEL JUNIOR HIGH SCHOOL','Accompany,Appointment Required','Appraisal District','1','Traditional','Savannah Bend Sec','8838','2.9567','Water District','2007','Appraisal District'); --> New record created successfully