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-16T21:36:45.250' ,`MLSNumber` = '25853674' ,`ListAgentFullName` = 'Fafu Zeng' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.046296' ,`Longitude` = '-95.391047' ,`PhotoCount` = '29' ,`PostalCode` = '77373' ,`RoomCount` = '6' ,`ListPrice` = '239800.00' ,`Status` = 'Active' ,`StreetName` = 'Lone Wolf' ,`StreetNumber` = '23207' ,`StreetSuffix` = 'Trail' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1629' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 1-story home with 3-bedroom, 2 baths and 2 attached garage!. Recently updated with new tile flooring and new carpets. Freshly painted throughout inside and outside of the home. New fans/lights. Huge high ceiling family room with a fire place. Spacious kitchen and a large formal dining open to the family room. Large backyard ready to entertain! Move in ready. Great schools with awesome shopping centers down the road. Close to I45, Hardy Tollway and all amenities. Schedule your show today' ,`Acres` = '0.1446' ,`Area` = '12' ,`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` = 'Spring East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 39 BLK 65 TIMBER LANE SEC 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6300' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '125' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'PEARL M HIRSCH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'TWIN CREEKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front,No Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Timber Lane Sec 07' ,`TaxAmount` = '5341' ,`TaxRate` = '3.0268' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1996' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675194872' WHERE `Matrix_Unique_ID` = '214075927' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-16T21:25:15.297' ,`MLSNumber` = '43775320' ,`ListAgentFullName` = 'Nimol In' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.328147' ,`Longitude` = '-95.422306' ,`PhotoCount` = '33' ,`PostalCode` = '77301' ,`RoomCount` = '6' ,`ListPrice` = '300000.00' ,`Status` = 'Active' ,`StreetName` = 'Oak Circle' ,`StreetNumber` = '635' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1946' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Better than New! 1 Story bricked, 3 bed, study with french doors, 2 bath and 2 car garage! Refrigerator, washer, dryer, faux wood blinds and drapery included!! This cute cozy home is move in ready! The kitchen is the heart of this home with open sight line to breakfast and family room! Jumbo island, lots of storage and counter space, SS appliances and gas stove. Family room is full of natural lighting and features a gas fireplace. Spacious master bedroom. Master bathroom with double sinks, separate shower, soaking tub and walk in closet. Good size secondary bedrooms. Great lighting and ambience throughout the home. Zoned to CISD and easy access to I-45. This well manicured home is a must see!' ,`Acres` = '0.1151' ,`Area` = '19' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S337700 - CEDAR WOODS, BLOCK 2, LOT 9' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5014' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '484' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'PATTERSON ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cedar Woods' ,`TaxAmount` = '7579' ,`TaxRate` = '2.7863' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675194872' WHERE `Matrix_Unique_ID` = '214530267' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-16T21:52:40.083' ,`MLSNumber` = '16635959' ,`ListAgentFullName` = 'Jamion Blackwell' ,`ListOfficeName` = 'Radius Agent LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.183306' ,`Longitude` = '-95.594991' ,`PhotoCount` = '11' ,`PostalCode` = '77354' ,`RoomCount` = '3' ,`ListPrice` = '1100000.00' ,`Status` = 'Active' ,`StreetName` = 'Prine' ,`StreetNumber` = '8617' ,`StreetSuffix` = 'Lane' ,`City` = 'Magnolia' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1733' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Howdy, mogul. Have you been looking for your next unrestricted location to put a Starbucks franchise, gas station, or rocket launch pad? Well here it is. Get ready for Prine time! Over 1 full acre of unrealized dreams and possibilities await you. Want to open up a salad bar and muffler shop combo? No problem. Turn Baltic Ave into Park Place and slide down your pyramid of dollar bills your new business will generate.\r\n\r\nPer TXDOT, there is a 32% increase in traffic, plus the Woodlands Parkway expansion is going in within a mile. Traffic right in front of your future business is slammed from 6-8am and then again at 3-5pm. Thousands of customers are driving by your corner location on a busy connecting artery. There\'s a house on the property, but the true value in this lot is commercial. So if you like, live in it while you plot global domination, wait for the land to appreciate, paint it pink, bulldoze it, whatever you like. It\'s yours, and just like you...it\'s unrestricted.' ,`Acres` = '1.0829' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'A0078 BROWN JAMES, TRACT 13-M, ACRES 1.0829' ,`LotDesciption` = 'Cleared,Corner' ,`LotSize` = '47171' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'CEDRIC C. SMITH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'BROWN JAMES' ,`TaxAmount` = '5317' ,`TaxRate` = '1.8587' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '1996' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675194873' WHERE `Matrix_Unique_ID` = '215002716' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-16T21:58:17.890' ,`MLSNumber` = '68648002' ,`ListAgentFullName` = 'Kay Robbins' ,`ListOfficeName` = 'RE/MAX RESULTS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.766420' ,`Longitude` = '-95.894486' ,`PhotoCount` = '42' ,`PostalCode` = '77423' ,`RoomCount` = '11' ,`ListPrice` = '559000.00' ,`Status` = 'Active' ,`StreetName` = 'Norhill Heights' ,`StreetNumber` = '9973' ,`StreetSuffix` = 'Lane' ,`City` = 'Brookshire' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3123' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Exceptional Westin home decked w/over the top upgrades and its outdoor kitchen & pool make this a prized purchase! Nestled on cul-de-sac street w/easy access to 1-10 West Katy in sought after Willow Creek Farms & zoned to popular KISD schools. Captivating Stone & brick elevation accented w/uplighting yard,lush landscaping,sprinkler & mesquito system. Striking 2-story entry features rotunda & spiraling iron staircase with hardwood stairs w/travertine,custom rod iron covers lighting & windows in the 2-story family room. French doors opens to front study, adjacent dining, grand-size island kitchen opens to the family room. Primary bedroom downstairs w/ensuite bathroom overlook sparkling pool & new landscaping. Upstairs landing you will have gameroom opening to the media room,plus additional 3 bedrooms, 2 bathrooms convenient to all rooms.\r\nMedia room comes with full surround sound w/top of the line ML built-in speakers. Custom iron window covering for the 2 story upper windows in family' ,`Acres` = '0.1377' ,`Area` = '26' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fulshear/South Brookshire/Simonton' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'S976201 WILLOW CREEK FARMS 2 SECTION 1 BLK 1 LOT 16 ACRES .1' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '6000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '598' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'BRYANT ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'WOODCREEK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Willow Creek Farms' ,`TaxAmount` = '10504' ,`TaxRate` = '3.1705' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675194873' WHERE `Matrix_Unique_ID` = '215102126' --> 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','215328867','1675194873','215328867','2023-01-16T21:12:53.380','93790083','Bintuan Zhu','Great Wall Realty, LLC','','','29.086962','-95.676000','31','77480','11','635000.00','Active','County Road 684c','7660','','Sweeny','5','0','6','3848','Single-Family','Country living at well-maintained 2 story home on 3.3 acres land. Also includes a stocked fishing pond, large shop w/carport, covered screened porch, and sunporch. Beautiful tree set off this charming home. The first floor has a formal study adjacent to the primary bedroom, living area with gas fireplace and custom-built ins, music room, and formal dining open to the living area. The spacious eat in kitchen has ample countertops, 5 burner stove top with convection oven. Large down stair laundry just off the kitchen. Off the upstairs living is a balcony to take in the view.','3.33','5','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gas Connections','1','West of the Brazos','Propane','0','CYPRESS BEND (A0085 D MCCORMICK) LOT 3A-4-5 ACRES 3.33','Subdivision Lot','145055','Appraisal District','','','0','','2','Electric Oven,Gas Oven','0','','','Gas Cooktop','','Composition','51 - Sweeny','SWEENY ELEMENTARY SCHOOL','SWEENY HIGH SCHOOL','SWEENY JUNIOR HIGH SCHOOL','Appointment Required,No Supra Keybox','Appraisal District','2','Traditional','Cypress Bend','7078','1.9264','Aerobic,Well','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','215850551','1675194873','215850551','2023-01-16T22:22:23.097','3802971','Patricia Navar','JLA Realty','','','29.795546','-95.136305','40','77530','12','309900.00','Active','Picea Azul','15462','Street','Channelview','2','1','4','2587','Single-Family','Welcome Home! Beautiful 2-story 4 bedroom 2.5 bath home in the highly desired neighborhood of Rancho Verde. Freshly painted interior, new tile flooring and baseboards, new light fixtures and more. Island kitchen with seating, stainless steel appliances, formal dining, private home office and an oversized laundry room. Second level features spacious secondary bedrooms and a game/media room. Back yard with covered patio perfect for entertaining. Quick access to Beltway 8 and I-10 for easy commute to downtown. Conveniently located near schools, shopping, restaurants and more! Schedule your private showing today!','0.1196','2','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Exclusions,Mud,Sellers Disclosure','1','','','North Channel','Central Gas','1','LT 16 BLK 3 RANCHO VERDE SEC 11','Cleared,Subdivision Lot','5208','Appraisal District','','405','0','','2','Gas Oven','0','','','Gas Range','','Composition','8 - Channelview','HAMBLEN ELEMENTARY SCHOOL','CHANNELVIEW HIGH SCHOOL','JOHNSON JUNIOR HIGH','Appointment Required,Supra Keybox','Appraisal District','2','Traditional','Rancho Verde Sec 11','6783','2.618','Water District','2019','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','216043707','1675194873','216043707','2023-01-16T21:53:41.607','60032688','Morad Fiki','Keller Williams Metropolitan','','','30.276301','-95.441522','45','77301','11','474900.00','Active','Brookmont','2007','Drive','Conroe','3','1','4','3025','Single-Family','Luxury awaits you at this stunning 2016 new build with upgrades throughout! This two-story residence is located on a spacious oversized lot and features a beautiful brick and stone facade, a bright and open floor plan, and extensive upgraded interior finishes. Inside the home, you’ll find stunning wood flooring, a beautiful wood staircase, and high ceilings as soon as you enter. The upgraded kitchen offers 42\" wooden cabinetry, granite countertops, a Reverse Osmosis water filtration system, a walk-in pantry, and stainless steel appliances. There are 2 living areas both upstairs and downstairs. The 3-car garage has AC and Expoxy flooring. The oversized and well-manicured backyard is ready for entertaining! The new metal fence separates the backyard, allowing for a dog-run area or garden. There is a whole Home Surge Protector, Security System with 13 Cameras, a Water Softener & Generator connection! Easy Access to I-45! Conroe ISD! Don’t miss the opportunity to own this gorgeous home!','0.3036','19','','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','','','Conroe Southeast','Central Gas,Zoned','1','S902409 - STEWARTS FOREST 09, BLOCK 1, LOT 7','Cul-De-Sac,Subdivision Lot','13225','Appraisal District','','510','0','','3','Gas Oven','0','','','Gas Range','','Composition','11 - Conroe','WILKINSON ELEMENTARY SCHOOL','CONROE HIGH SCHOOL','STOCKTON JUNIOR HIGH SCHOOL','Appointment Required','Appraisal','2','Traditional','Stewarts Forest','8843','2.7863','Public Water,Water District','2016','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','216189728','1675194873','216189728','2023-01-16T21:37:27.587','91376091','Lindsey Stutts','FYI Realty','','','30.916516','-94.827847','43','75960','12','275000.00','Active','State Hwy Loop 177','274','','Moscow','3','0','3','2075','Single-Family','Charming country home with 3 bedrooms and 3 baths on 1.6 acres in Moscow. Wood burning fireplace in the family room, lots of storage in the kitchen, hardwood flooring in the family room, living room, primary and second bedroom. RV/Camper cover, newly built animal pen. Large yard with above-ground pool and nice size patio.','1.57','44','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','Wood Burning Fireplace','1','Polk County North','Central Electric','0','MOSCOW BLK 6 LOT 2','Cleared','68389','Appraisal District','','','0','','2','Electric Oven','1','Above Ground','','Electric Range','','Composition','238 - Corrigan-Camden','CORRIGAN-CAMDEN PRIMARY/ELEMENTARY SCHOOL','CORRIGAN-CAMDEN HIGH SCHOOL','CORRIGAN-CAMDEN JUNIOR HIGH SCHOOL','Accompany,Appointment Required,Leave Business Card','Appraisal','1','Traditional','Moscow','2686','1.7144','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','216414625','1675194873','216414625','2023-01-16T22:40:40.790','91080562','Liliana Martinez','Jane Byrd Properties INTL.','','','29.780658','-95.322767','35','77020','4','547900.00','Active','Noble','4701','Street','Houston','4','1','4','3172','Single-Family','THIS BEAUTY is a Custom built Home with all you need and more, just minutes away from downtown and the anticipated East River project along Buffalo Bayou.\r\nCorner and Ready to move in. First floor offers Open concept Kitchen w Granite counters, large Island, dark brown cabinets, high ceilings with recessed lighting, all Stainless appliances included. Living room and office/study room downstairs, utility room with washer & dryer connections. Upstairs, Master bedroom with a walking closet and gorgeous bathroom, bedrooms each with own bathroom and walk in closet. Nice size Game room. Buyer to verify room dimensions and Schools.','','2','','','Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','Denver Harbor','Central Electric','0','LT 10 BLK 91 AUGUSTA','Corner','3411','Other','','','0','','','Electric Oven','0','','','Gas Range','','Wood Shingle','27 - Houston','ATHERTON ELEMENTARY SCHOOL (HOUSTON)','WHEATLEY HIGH SCHOOL','MCREYNOLDS MIDDLE SCHOOL','Appointment Required,Leave Business Card,Lockbox Front,Vacant/Unoccupied','Appraisal','2','Other Style','Augusta','','','Public Sewer,Public Water','2017','Appraisal'); --> 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','216418138','1675194873','216418138','2023-01-16T22:48:22.317','35045989','Maria Hernandez','HomeSmart','','','29.487959','-95.593342','33','77469','7','648000.00','Active','Jerry','804','Road','Richmond','2','1','4','3500','Single-Family','Truly Awesome Custom Home on Perfect Unrestricted 1.75 acre lot in Richmond TX! House is 4 Bed/2.5 Bath/2 car garage. High Ceiling, all tile flooring except the bedrooms, quartz Kitchen Countertops, Recessed Lighting, Walk-in Closets and many more upgrades. Tons of natural light entering through the large number of windows, even in the garage. Spend relaxing nights enjoying the beautiful sunsets on the covered back patio. Endless possibilities in the open space land. No MUD and HOA fees!!! Low Tax Rate 1.7%. It is convenient to Freeways 59 and 99, 15 minutes from Sugar Land TX and 5 minutes from River Point Golf Club!!! Please call to schedule your appointment today.','1.75','30','Other','','','','Sellers Disclosure','1','','','Fort Bend Southeast','Central Electric','0','0018 H CHRIESMAN, ACRES 3.5677','Cleared','','Other','','','1','Never Lived In','2','','0','','','','','Composition','33 - Lamar Consolidated','VELASQUEZ ELEMENTARY SCHOOL','GEORGE RANCH HIGH SCHOOL','RYON/READING JUNIOR HIGH SCHOOL','Supra Keybox','Seller','1','Ranch,Traditional','H Chriesman','1443','1.6948','Septic Tank,Well','2022','Seller'); --> New record created successfully