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-28T00:37:31.270' ,`MLSNumber` = '16321694' ,`ListAgentFullName` = 'Greg Bennett' ,`ListOfficeName` = 'Greg Bennett Fine Properties' ,`SellingAgentFullName` = 'Patty Newton' ,`SellingOfficeName` = 'RE/MAX Fine Properties' ,`Latitude` = '29.622290' ,`Longitude` = '-95.588778' ,`PhotoCount` = '43' ,`PostalCode` = '77478' ,`RoomCount` = '9' ,`ListPrice` = '465000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Fox Briar' ,`StreetNumber` = '403' ,`StreetSuffix` = 'Lane' ,`City` = 'Sugar Land' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3617' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'We are proud to present this Sugar Land Meticulously Maintained home in Sugar Creek! This 3617 square foot 2 story 4 bedroom 3+ bath has 3 living areas! The Living room is 22x20 with plenty of light from the large picture window! The Family room is graced with handsome wainscoting (wood paneling) faux beams, a fireplace w/inviting hearth, large window w/ views to the back & patio. This flows into the Breakfast room, kitchen, & wet bar. The Kitchen\'s handsome cabinetry is graced by granite countertops & white appliances: Double ovens & gas cooktop. Next, 2 Large Bedrooms on the first floor! The Master Bdrm at the end of the hallway for privacy grants outdoor access through private doors. Master Bath has double sinks, a Large shower, walk-in closets plus a sit down make-up vanity. Upstairs find two large bedrooms, a large game room & Jack & Jill Bath. Outside backyard is set up for many activities from gardening, victory garden, workshop in the oversized garage with storage' ,`Acres` = '0.2114' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SUGAR CREEK SEC 10, BLOCK 3, LOT H & (PTS) 24,25' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot' ,`LotSize` = '9209' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'DULLES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DULLES HIGH SCHOOL' ,`SchoolMiddle` = 'DULLES MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sugar Creek' ,`TaxAmount` = '7873' ,`TaxRate` = '2.0094' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1975' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675265260' WHERE `Matrix_Unique_ID` = '212608314' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-27T23:12:07.900' ,`MLSNumber` = '3338152' ,`ListAgentFullName` = 'Sohail Sulahry' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.058732' ,`Longitude` = '-95.179042' ,`PhotoCount` = '25' ,`PostalCode` = '77345' ,`RoomCount` = '8' ,`ListPrice` = '343500.00' ,`Status` = 'Active' ,`StreetName` = 'Falling Brook' ,`StreetNumber` = '3022' ,`StreetSuffix` = 'Drive' ,`City` = 'Kingwood' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2307' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Kingwood living in this lovely 4 bed, 2 bath home with a split plan, completely renovated. Formal dining & living room space as you enter the main door. Kitchen has been completely redone with new cabinets, stainless steel appliances, including double oven, Quartz countertop, backsplash, Single bowl under mount sink, faucet. Kitchen opens up to the family room. Bathrooms were updated completely with new fixtures, new showers, frameless shower door.\r\nNew paint throughout the house. New waterproof vinyl plank flooring. Brand new front door to match the aesthetics of the house. All light fixtures and smoke alarms, hardware and plumbing fixtures are brand new. Double closet in master bath. Plenty of closet space for storage in every room and a separate laundry room with wash & dryer hookup. Cozy fireplace, skylights in the family room w/built in closets. Sprinkler system.\r\nTop schools close by with walking distance to the Greenbelt trail, community pool. Groceries and YMCA close by.' ,`Acres` = '0.1901' ,`Area` = '32' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Kingwood East' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 9 BLK 18 GREENTREE VILLAGE SEC 2' ,`LotDesciption` = 'Greenbelt,In Golf Course Community,Wooded' ,`LotSize` = '8280' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'GREENTREE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KINGWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'CREEKWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Greentree Village Sec 02' ,`TaxAmount` = '5608' ,`TaxRate` = '2.5839' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1981' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675265261' WHERE `Matrix_Unique_ID` = '212957207' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-28T00:20:19.397' ,`MLSNumber` = '88281611' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Turner Mangum,LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.395200' ,`Longitude` = '-95.482530' ,`PhotoCount` = '21' ,`PostalCode` = '77378' ,`RoomCount` = '4' ,`ListPrice` = '268990.00' ,`Status` = 'Active' ,`StreetName` = 'Pine Cavern' ,`StreetNumber` = '203' ,`StreetSuffix` = '' ,`City` = 'Willis' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1515' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Taft is great for entertaining. The kitchen, nestled in the back of the home, connects seamlessly to both the dining and outdoor living areas. A sunlit Owner’s Suite with walk-incloset exemplifies smart use of space in a single-story home.' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = 'Centex Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Northeast' ,`HeatSystem` = 'Heat Pump' ,`HOAMandatory` = '1' ,`Legal` = '28402' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4800' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'A.R. TURNER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERT P. BRABHAM MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'The Pines at Seven Coves' ,`TaxAmount` = '' ,`TaxRate` = '3.18' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675265261' WHERE `Matrix_Unique_ID` = '213805707' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-27T23:10:17.313' ,`MLSNumber` = '39827711' ,`ListAgentFullName` = 'Kate Myhan' ,`ListOfficeName` = 'JPAR - The Sears Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.768032' ,`Longitude` = '-94.933387' ,`PhotoCount` = '49' ,`PostalCode` = '77521' ,`RoomCount` = '3' ,`ListPrice` = '299900.00' ,`Status` = 'Active' ,`StreetName` = 'Trailwood' ,`StreetNumber` = '3611' ,`StreetSuffix` = 'Drive' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1976' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully updated 3–4-bedroom home on an oversized pool sized backyard in one of Baytown\'s finest neighborhoods. Home features high vaulted ceilings in the living area, completely remodeled bathrooms with finishes (Refer to upgrades list) worthy of a home that is double the price, refinished kitchen cabinets with Misty black honed granite counters, fresh interior and exterior paint, recent roof (2016), HVAC (2017), water heater (2022) and more. Fully fenced backyard that could be ideal for kids and pets to play. Not in a flood zone and never flooded! Seller financing available for qualified buyers.' ,`Acres` = '0.2514' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 22 TRAILWOOD' ,`LotDesciption` = 'Cleared' ,`LotSize` = '10950' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'STEPHEN F. AUSTIN ELEMENTARY SCHOOL (GOOSE CREEK)' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (GOOSE CREEK)' ,`SchoolMiddle` = 'CEDAR BAYOU J H' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Trailwood' ,`TaxAmount` = '5396' ,`TaxRate` = '2.97' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675265261' WHERE `Matrix_Unique_ID` = '213814514' --> 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','216080189','1675265261','216080189','2023-01-28T00:11:38.823','95898503','Shawn Dangerfield','Redwood Realty Group','','','29.885473','-95.468876','50','77088','3','219000.00','Active','Hickory Forest','5406','Drive','Houston','2','0','3','1821','Single-Family','Beautifully updated 1 story home. Very spacious with huge bedrooms, plenty of closet/storage space, and open living room/dining room and open den / kitchen with backyard access through both areas. Brick wood burning fireplace. Plenty of room for entertaining or setting up separate areas for large gatherings. HVAC system replaced in 2021. Laminated wood flooring and tile in wet areas. Double pane windows with window blinds. Large fenced backyard with covered patio and decorated flooring. Workbench in 2 car garage. Extra wide driveway. Ready for immediate move in. This is a must see.','0.2198','11','','','Electric Dryer Connections,Washer Connections','','Owner/Agent,Sellers Disclosure','1','','1','Northwest Houston','Central Electric','1','LT 41 BLK 4 017*I5645955-004-004-041 INWOOD NORTH SEC 4','Corner','9573','Appraisal District','','300','0','','2','Electric Oven','0','','','Electric Range','','Composition','32 - Klein','NITSCH ELEMENTARY SCHOOL','KLEIN FOREST HIGH SCHOOL','KLEIN INTERMEDIATE SCHOOL','Appointment Required,Leave Business Card,Lockbox Front,Vacant/Unoccupied','Appraisal District','1','Contemporary/Modern','Inwood North Sec 04','5613','2.6485','Water District','1979','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','216564221','1675265261','216564221','2023-01-27T23:26:37.353','56159297','Kingsley Osagie','Realty Associates','','','29.571899','-95.688500','32','77479','9','355500.00','Active','Rosehaven','5414','Court','Sugar Land','2','1','3','2349','Single-Family','WELCOME TO A BEAUTIFUL HOME!!. THE ROOF IS RELATIVELY NEW, BRAND-NEW TOILETS, LARGE 13X 23 PATIO WITH BUILT IN SPEAKERS / TV TO ENJOY ALL YEAR ROUND. 3 BEDROOMS & 2 BATH AND A HALF. THIS IS HOME HAS NICE SIZE BACKYARD FOR THE KIDS TO PLAY. IT FEATURES OPEN KITCHEN WITH AN ISLAND AND BREAKFAST AREA. HOME HAS FORMAL DINING, LARGE FAMILY ROOM WITH FIREPLACE. PRIMARY BATH TUB WITH SEPARATE SHOWER. VERY CLOSE TO HOSPITALS, MAJOR FREEWAYS, GROCERY STORES LIKE HEB, AND OTHER MAJOR RESTAURANTS AND STORES ARE JUST CLOSE BY FOR HOMEOWNER CONVENIENCE. THIS HOUSE DID NOT FLOOD.','0.1785','30','','','Electric Dryer Connections,Gas Dryer Connections','','Sellers Disclosure','1','Gas Connections','2','Sugar Land West','Central Gas','1','RIVERPARK SEC 9, BLOCK 3, LOT 34','Cul-De-Sac','7777','Appraisal District','','849','0','','2','Gas Oven','0','','','Gas Cooktop','','Composition','33 - Lamar Consolidated','HUTCHISON ELEMENTARY SCHOOL','LAMAR CONSOLIDATED HIGH SCHOOL','WESSENDORF/LAMAR JUNIOR HIGH SCHOOL','Appointment Required,Supra Keybox','Appraisal District','2','Traditional','Riverpark Sec 9','6244','2.6977','Public Water','2001','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','216605702','1675265261','216605702','2023-01-27T23:25:21.510','95326277','Herbert Anderson','Realty Associates','','','29.539288','-95.318138','50','77584','12','359900.00','Active','Larrycrest','6307','Drive','Pearland','3','1','5','3571','Single-Family','5 Bedroom 3.5 bath 2 car garage with Game room and Media room.','0.1608','5','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','','','Pearland','Central Gas','1','CYPRESS VILLAGE SEC 2 (A0546 HT&B) (PEARLAND) BLK 11 LOT 10','Cleared','7004','Appraisal District','','330','0','','2','Freestanding Oven,Gas Oven','0','','','Freestanding Range,Gas Range','','Composition','42 - Pearland','MASSEY RANCH ELEMENTARY SCHOOL','PEARLAND HIGH SCHOOL','PEARLAND JUNIOR HIGH SOUTH','Appointment Required,Lockbox Front,Supra Keybox','Appraisal District','2','Traditional','Cypress Village Sec 1-2','9613','2.6756','Other Water/Sewer,Water District','2008','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','216757817','1675265261','216757817','2023-01-27T23:22:26.607','50931842','Elmer Garcia','REALM Real Estate Professional','','','30.333011','-95.307338','20','77301','4','275000.00','Active','Newman Court','208','','Conroe','3','0','3','2145','Single-Family','','','19','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','No Disclosures','','','','Conroe Northeast','Central Gas','1','Crockett Trace Estates lot 08 Blk 1 Section 12','Subdivision Lot','','','','250','0','','2','Convection Oven','0','','','Gas Cooktop','','Composition','11 - Conroe','AUSTIN ELEMENTARY SCHOOL (CONROE)','CANEY CREEK HIGH SCHOOL','MOORHEAD JUNIOR HIGH SCHOOL','No Appointment Required','Seller','1','Traditional','Crockett Trace','','','Public Sewer,Public Water','2023','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','216799665','1675265262','216799665','2023-01-27T23:39:30.970','27630197','Meagan Minter','Keller Williams Realty - Memor','','','29.058607','-95.430616','21','77566','3','250000.00','Active','Sugar Cane','217','Trace','Lake Jackson','2','0','3','1428','Single-Family','Come see this well maintained home, complete with a remodeled kitchen and bathrooms. Before you step inside though, check out the quarter acre lot, that features a creek (that did not go out of its banks here during Harvey) that runs along the back of the home, and also has no side neighbors due to an easement and wooded area. The seller currently gardens in this area. The interior of the home offers an open feel in the living, dining and kitchen area. The living room has a high vaulted ceiling and a wood burning fireplace. In the hall bathroom you will find an oversized shower with a rain shower head and heated, programmable flooring. The primary bedroom is complete with an ensuite bathroom of its own. In the backyard, an oversized patio area is your perfect spot for entertaining. This home will come with all appliances.','0.2473','5','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','1','Lake Jackson','Central Electric','0','SUGAR CANE SD (LAKE JACKSON) (A0066 J E GROCE) LOT 10','Subdivision Lot','10772','Appraisal District','','','0','','2','Electric Oven','0','','','Electric Cooktop','','Composition','7 - Brazosport','BRANNEN ELEMENTARY SCHOOL','BRAZOSWOOD HIGH SCHOOL','LAKE JACKSON INTERMEDIATE SCHOOL','Appointment Required,Lockbox Front','Appraisal District','1','Traditional','Sugar Cane SD Lake Jackson','3993','2.1926','Public Sewer,Public Water','1984','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','216820962','1675265262','216820962','2023-01-28T00:58:58.817','75285200','Jasmin Clopton','eXp Realty, LLC','','','29.742693','-95.550507','35','77042','7','889000.00','Active','Meadow Lake','10038','Lane','Houston','3','0','5','3327','Single-Family','Beautifully renovated home located in warm and friendly BRIARGROVE PARK. Very spacious home with five bedrooms and fantastic pool. Home boasts many upgrades. Porcelain wood look tile throughout common areas perfect for wet floors after those fun pool activities. Completely updated kitchen with 3 CM quartz countertops, soft close cabinets and high end appliances. Custom cabinets with built in bench for morning breakfast gatherings. Grand primary suite with extra large shower. Other upgrades includes new batten board style exterior siding 2022, new roof shingles 2022, double pane high end windows, new doors, custom shutters, Pex plumbing 2022, Two Trane HVAC system 2022, sprinkler system, mosquito misting system and much more. Ask you agent for a full list of all updates.','0.1937','22','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gas Connections','1','Briargrove Park/Walnutbend','Central Electric,Central Gas','1','LT 230 BLK 8 BRIARGROVE PARK SEC 1','Subdivision Lot','8439','Appraisal District','','680','0','','2','','1','In Ground','','Gas Range','','Composition','27 - Houston','WALNUT BEND ELEMENTARY SCHOOL (HOUSTON)','WESTSIDE HIGH SCHOOL','REVERE MIDDLE SCHOOL','Appointment Required','Appraisal District','2','Ranch','Briargrove Park Sec 01','12353','2.3307','Public Sewer,Public Water','1961','Appraisal District'); --> New record created successfully