Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-08T06:26:31.327' ,`MLSNumber` = '21875131' ,`ListAgentFullName` = 'Robert Salmons' ,`ListOfficeName` = 'Entera Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.990713' ,`Longitude` = '-95.436652' ,`PhotoCount` = '24' ,`PostalCode` = '77090' ,`RoomCount` = '5' ,`ListPrice` = '219900.00' ,`Status` = 'Active' ,`StreetName` = 'Darbydale Crossing' ,`StreetNumber` = '819' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1412' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Instantly appealing, well maintained one story home with fantastic open layout. You will never miss out on the action from the spacious kitchen overlooking the dining and living rooms! Spend time outdoors in the welcoming backyard. Book a tour with your real estate agent today and feel right at home!' ,`Acres` = '0.0929' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '1960/Cypress Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 2 DARBYDALE CROSSING SEC 1' ,`LotDesciption` = 'Other' ,`LotSize` = '4045' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'CLARK ELEMENTARY SCHOOL (SPRING)' ,`SchoolHigh` = 'ANDY DEKANEY H S' ,`SchoolMiddle` = 'BAMMEL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Darbydale Xing Sec 1' ,`TaxAmount` = '4069' ,`TaxRate` = '2.5867' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667924671' WHERE `Matrix_Unique_ID` = '205633658' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-08T06:33:45.337' ,`MLSNumber` = '52285514' ,`ListAgentFullName` = 'Wendy Baty' ,`ListOfficeName` = 'Provenzano Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.357320' ,`Longitude` = '-95.669040' ,`PhotoCount` = '26' ,`PostalCode` = '77461' ,`RoomCount` = '0' ,`ListPrice` = '275000.00' ,`Status` = 'Active' ,`StreetName` = 'Melanie Lane' ,`StreetNumber` = '0' ,`StreetSuffix` = '' ,`City` = 'Needville' ,`BathsFull` = '0' ,`BathsHalf` = '0' ,`BedsTotal` = '0' ,`SqFtTotal` = '800' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Just what the doctor ordered to get away from the stress of city life! You\'ll find your spacious getaway retreat on a quiet cul-de-sac with 4.23 green, wooded acres & a circular drive. With more trees that you can count, you can take your pick of any two to set up that hammock for a little snoozing on those lazy afternoons. If gardening, chickens or horses are more your speed, there\'s plenty of room for that too! This peaceful retreat is a work in progress with an 800 square foot home that just needs to be lovingly finished. Windows are in, floor decking & insulation are in place. Seller plans to install well & septic prior to closing; all you have to do is make it your own. This homesite is country living, nestled in the farmland of Fort Bend County, but close to Brazos Bend State Park, the George Observatory for stargazing, Houston, Lake Jackson, Surfside or Galveston Beach & the Medical Center. Don\'t let this little slice of heaven get away! Call for an appointment today!' ,`Acres` = '4.231' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = '0446 Day Land and Cattle, Tract 29, Acres 4.231' ,`LotDesciption` = 'Wooded' ,`LotSize` = '185130' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '38 - Needville' ,`SchoolElementary` = 'NEEDVILLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NEEDVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'NEEDVILLE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Willow Meadows' ,`TaxAmount` = '3354' ,`TaxRate` = '1.88' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667924671' WHERE `Matrix_Unique_ID` = '207623710' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-08T06:18:39.800' ,`MLSNumber` = '76848675' ,`ListAgentFullName` = 'Sally James' ,`ListOfficeName` = 'CB&A, Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.837922' ,`Longitude` = '-95.441157' ,`PhotoCount` = '50' ,`PostalCode` = '77018' ,`RoomCount` = '8' ,`ListPrice` = '560000.00' ,`Status` = 'Active' ,`StreetName` = 'Treebark' ,`StreetNumber` = '5011' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2345' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '*PRICE ADJUSTMENT*Outstanding 1-story home on a peaceful cul-de-sac lot zoned to Oak Forest Elementary. This open floor plan is perfect for entertaining & family living. Formal dining room at the front of the house was converted to home/office & formal living room was opened up to an enormous family room/flex space. The large kitchen features granite, ceramic tile backsplash, a Kohler sink, Frigidaire Electrolux cooktop & double oven. Additional updates include new carpet in family room & kitchen/family/bathroom has fresh paint. The roof was replaced in 2018. The owner’s retreat has 2 closets/en-suite bathroom with a vanity area. Plenty of room for furniture arrangement in the spacious secondary bedrooms & 2nd full bathroom has large vanity area. The detached 2 car garage/workshop with ample storage & the expansive backyard has plenty of room for a pool. This home on a cul-de-sac street with mature trees, zoned to Oak Forest Elem. has great curb appeal & move-in ready!' ,`Acres` = '0.2276' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Oak Forest East Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 7 BLK 2 CANDLELIGHT ESTATES SEC 2' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '9915' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'OAK FOREST ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'BLACK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Candlelight Estates Sec 02' ,`TaxAmount` = '10855' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1963' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667924672' WHERE `Matrix_Unique_ID` = '209528620' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-08T06:33:16.480' ,`MLSNumber` = '39180372' ,`ListAgentFullName` = 'Carla Wade' ,`ListOfficeName` = 'RE/MAX Space Center-Clear Lake' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.204651' ,`Longitude` = '-94.938738' ,`PhotoCount` = '40' ,`PostalCode` = '77554' ,`RoomCount` = '7' ,`ListPrice` = '664800.00' ,`Status` = 'Active' ,`StreetName` = 'San Domingo' ,`StreetNumber` = '13839' ,`StreetSuffix` = 'Drive' ,`City` = 'Galveston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1720' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning 4 bedroom, 3 bath beach house has been beautifully updated with soft coastal hues and is sold furnished with just a few exclusions. This beauty has it\'s own lift to make life easy for those that don\'t love walking upstairs! \r\n It features 2 decks on the main living level and a roof top deck for nice views. Pirates beach is a very desirable beachfront neighborhood with beach access. This house offers an extended 2 car garage, so much storage including 2 ground level storage rooms. There is a breezeway, a double covered parking area plus a covered patio area at the back of the house. The large driveway allows for lots of friends and family gatherings. House has been a successful vacation rental, and would make a fantastic full time home or investment property!' ,`Acres` = '0.14' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'West End' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 121 PAGE 45 LOT 2 BLK 11 PIRATES BEACH SEC 2' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '6100' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '320' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Pirates Beach' ,`TaxAmount` = '10909' ,`TaxRate` = '2.0324' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667924672' WHERE `Matrix_Unique_ID` = '209626000' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-08T05:20:16.500' ,`MLSNumber` = '73274288' ,`ListAgentFullName` = 'Lisa Sanders' ,`ListOfficeName` = 'Living Vogue Real Estate' ,`SellingAgentFullName` = 'Adam Olsen' ,`SellingOfficeName` = 'eXp Realty, LLC' ,`Latitude` = '29.480960' ,`Longitude` = '-94.938666' ,`PhotoCount` = '48' ,`PostalCode` = '77539' ,`RoomCount` = '8' ,`ListPrice` = '419000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Dick Bay' ,`StreetNumber` = '1232' ,`StreetSuffix` = 'Drive' ,`City` = 'San Leon' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1904' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Looking for a property with PROVEN Airbnb income? You can live the high life upstairs while renting out the downstairs and an additional six income-producing covered boat slips with lifts! No HOA, so you can even store your RV in front! Perfect income-producing home! Just blocks from Top Water Grill! This fully furnished home sits on the mouth of the deepwater canal leading to Dickinson Bay in the historic city of San Leon. This property features two large living areas, two full kitchens, two full bathrooms, a bar, and a sunroom. Walk outside to the backyard and enjoy a covered patio with a swing, picnic table, fans, smoker, grill, and fire pit. Plenty of seating to relax and enjoy the boats and the water. Imagine fishing and catching crab out of the backyard. It comes furnished and is currently rented out consistently throughout the year. New Roof 2017, new storm windows 2015, New AC 2021, new plumbing 2021, new water heater 2021, boathouse built-in 2013, and over 220 ft of bulkhead.' ,`Acres` = '0.2459' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Bacliff/San Leon' ,`HeatSystem` = 'Central Gas,Other Heating,Propane' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 10 A EDWARDS SUR LOT 46 FIESTA ESTATES' ,`LotDesciption` = 'Other,Water View,Waterfront' ,`LotSize` = '10712' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'SAN LEON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'JOHN AND SHAMARION BARBER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Fiesta Estates' ,`TaxAmount` = '3507' ,`TaxRate` = '2.7147' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1987' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667924672' WHERE `Matrix_Unique_ID` = '211911786' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-08T06:50:26.580' ,`MLSNumber` = '36474935' ,`ListAgentFullName` = 'Claudia Briz' ,`ListOfficeName` = 'ELLE and CO Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.022417' ,`Longitude` = '-95.306373' ,`PhotoCount` = '26' ,`PostalCode` = '77338' ,`RoomCount` = '4' ,`ListPrice` = '389000.00' ,`Status` = 'Active' ,`StreetName` = 'Wickton' ,`StreetNumber` = '21231' ,`StreetSuffix` = 'Lane' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3350' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful, spacious home in a cul-de-sac mins away from the elementary schools, and Bush Airport. This home has a newly remodeled beautiful kitchen. The huge yard includes an underground pool and space big enough to build an outdoor kitchen. The primary bedroom is down includes large bathroom with a loft above with a separate stair case that can be used as a crafts room or nursery.' ,`Acres` = '0.2509' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Humble Area West' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 8 BLK 1 KENSWICK FOREST SEC 5' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '10931' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'JONES ELEMENTARY SCHOOL (ALDINE)' ,`SchoolHigh` = 'NIMITZ HIGH SCHOOL (ALDINE)' ,`SchoolMiddle` = 'JONES MIDDLE SCHOOL (ALDINE)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Kenswick Forest Sec 05' ,`TaxAmount` = '7364' ,`TaxRate` = '2.7433' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667924672' WHERE `Matrix_Unique_ID` = '212031662' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-08T06:26:08.770' ,`MLSNumber` = '23791921' ,`ListAgentFullName` = 'John Williams' ,`ListOfficeName` = 'Real Estate Options of Texas' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.509705' ,`Longitude` = '-95.407094' ,`PhotoCount` = '14' ,`PostalCode` = '77578' ,`RoomCount` = '7' ,`ListPrice` = '233300.00' ,`Status` = 'Active' ,`StreetName` = 'Buena Park' ,`StreetNumber` = '32' ,`StreetSuffix` = 'Circle' ,`City` = 'Manvel' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2049' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come see this 2-story 3 bedroom, 2 and half bathroom looking for just a few special touches. All bedrooms up with enough space for a game room or media room. Won\'t last long!' ,`Acres` = '0.1162' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures,Real Estate Owned,Special Addendum' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'RODEO PALMS THE COLONY SEC 1 (A0299 HT&BRR)(MANVEL) BLK 3 LO' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5062' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'DON JETER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'RODEO PALMS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Rodeo Palms, The Colony Sec 1' ,`TaxAmount` = '7298' ,`TaxRate` = '3.6694' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667924672' WHERE `Matrix_Unique_ID` = '212299226' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-08T06:14:49.427' ,`MLSNumber` = '14682852' ,`ListAgentFullName` = 'Mary Dover' ,`ListOfficeName` = 'Coldwell Banker Realty, Cy-Fair Office' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.957121' ,`Longitude` = '-95.599173' ,`PhotoCount` = '39' ,`PostalCode` = '77429' ,`RoomCount` = '9' ,`ListPrice` = '287900.00' ,`Status` = 'Active' ,`StreetName` = 'Serendipity' ,`StreetNumber` = '11802' ,`StreetSuffix` = 'Lane' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2136' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Get your creative juices flowing at this magnificent Cypress home. Zoned for Millsap Elementary, Hamilton Middle and CyCreek High, the location of this little neighborhood is minutes from area conveniences, shopping and of course great for commuting. Minutes to 249, 290 and 1960, this home is nestled back near all parks and recreational activities. This split floorplan makes it ideal for the average person and the landscape is great for entertaining. Primary bedroom down with a magnificent bathroom that is a great way to relax after a long day of work. Soak in your claw foot tub, modern shower with the rain feature, a nice size vanity with bult in storage and large organized closet. As you enter the primary bedroom, you will see the set of French doors that can lead you to your stone paved back patio. Gas cooking in your large kitchen with an island and modern light fixtures. Upstairs, there are 3 additional bedrooms with one full bath. Look at the extraordinarily low tax rate!' ,`Acres` = '0.1768' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 6 BLK 1 TOWER OAK BEND' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7700' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '675' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'MILLSAP ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CYPRESS CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Tower Oak Bend' ,`TaxAmount` = '4013' ,`TaxRate` = '2.1637' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667924673' WHERE `Matrix_Unique_ID` = '213004065' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-08T06:55:18.023' ,`MLSNumber` = '8774529' ,`ListAgentFullName` = 'Christine Lahori' ,`ListOfficeName` = 'Krueger Real Estate' ,`SellingAgentFullName` = 'Aida Holguin-Duran' ,`SellingOfficeName` = 'Newhomeprograms.com LLC' ,`Latitude` = '29.673374' ,`Longitude` = '-95.347145' ,`PhotoCount` = '21' ,`PostalCode` = '77033' ,`RoomCount` = '6' ,`ListPrice` = '170000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Kenilwood' ,`StreetNumber` = '5010' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1212' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming recently remodeled open-concept with ROOF replaced 2022, Central A/C and Water Heater replaced 2021, Flooring, Countertops, Toilets, Carpet, Bathtubs, Washer/Dryer Connections, Windows, ALL PLUMBING redone 2021, Electrical and Wood Fence. Brand new stainless steel appliances include stove and microwave. UPDATED Electrical and Light Fixtures. Situated in Smallwood Terrace. Close to Bastian Elementary School, 610 and 288. Easy access to the Medical Center.' ,`Acres` = '0.1515' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Medical Center South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 3 BLK 16 SMALLWOOD TERRACE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BASTIAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WORTHING HIGH SCHOOL' ,`SchoolMiddle` = 'ATTUCKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Smallwood Terrace' ,`TaxAmount` = '1521' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667924673' WHERE `Matrix_Unique_ID` = '213095598' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-08T06:19:58.640' ,`MLSNumber` = '76512085' ,`ListAgentFullName` = 'Oneal Texada' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.881393' ,`Longitude` = '-95.462249' ,`PhotoCount` = '26' ,`PostalCode` = '77088' ,`RoomCount` = '10' ,`ListPrice` = '234000.00' ,`Status` = 'Active' ,`StreetName` = 'Wild Basin' ,`StreetNumber` = '8818' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1532' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to your new warm and inviting Home. This single story home has a split floor plan with 3 bedrooms and 2 baths. Home features a large family room with high ceiling and gas burning fireplace for those relaxing moments when it is chilly outside. Home has a formal dining room for those wonderful family gatherings as well. Buyers have your agent schedule a showing for you soon. Great home for First Time Buyers, Investors or if you are looking to downsize.' ,`Acres` = '0.1584' ,`Area` = '11' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 BLK 6 INWOOD FOREST VILLAGE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6900' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '260' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'CARAWAY ELEMENTARY SCHOOL (ALDINE)' ,`SchoolHigh` = 'EISENHOWER HIGH SCHOOL' ,`SchoolMiddle` = 'GARCIA MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Inwood Forest Village' ,`TaxAmount` = '3959' ,`TaxRate` = '2.5119' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1997' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667924673' WHERE `Matrix_Unique_ID` = '213414505' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-08T06:46:00.060' ,`MLSNumber` = '17595560' ,`ListAgentFullName` = 'Gabriela Hagler' ,`ListOfficeName` = 'AIM Commercial Brokerage' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.502006' ,`Longitude` = '-98.296249' ,`PhotoCount` = '30' ,`PostalCode` = '78109' ,`RoomCount` = '6' ,`ListPrice` = '265000.00' ,`Status` = 'Active' ,`StreetName` = 'Copper' ,`StreetNumber` = '7611' ,`StreetSuffix` = 'Lake' ,`City` = 'Converse' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1402' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'PRICE REDUCED!!! Bright and inviting, open-concept 3/2/2 in the heart of Copperfield! Built to enjoy, this perfectly appointed home boasts of a MASSIVE BACK PATIO EXTENSION (by builder) great for entertaining in style, plus chic bay window, vaulted ceilings, 6 panel (builder\'s gold package) premium doors, two-inch faux wood blinds throughout, pre-wire for security, radiant barrier, double pane windows, ceiling fans, and high SEER HVAC for energy efficiency. Come check out the awesome Primary Bedroom with walk-in closet and private ensuite featuring relaxing Garden Tub! What else could you ask for in an OPEN CONCEPT FLOORPLAN WITH EXCELLENT CURB APPEAL with ABUNDANT ENTERTAINING OPTIONS - INDOOR AND OUTDOOR, under 1500SF?! All within close proximity to main thoroughfares, with easy access to Loop 1604, and I-35, Randolph AFB, shopping and schools! *all information should be verified by buyer\"' ,`Acres` = '0.1291' ,`Area` = '83' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'CB 5069B (MEADOWS OF COPPERFIELD UT-4), BLOCK 14 LOT 25 PLAT' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5624' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '135' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '634 - Judson' ,`SchoolElementary` = 'RICARDO SALINAS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'JUDSON HIGH SCHOOL' ,`SchoolMiddle` = 'KITTY HAWK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Back,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Meadows Of Copperfield Ut-4' ,`TaxAmount` = '5094' ,`TaxRate` = '2.4938' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2009' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667924673' WHERE `Matrix_Unique_ID` = '213677653' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-08T06:45:34.370' ,`MLSNumber` = '80806266' ,`ListAgentFullName` = 'Michael McLin' ,`ListOfficeName` = 'Heritage Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.129378' ,`Longitude` = '-95.381911' ,`PhotoCount` = '21' ,`PostalCode` = '77386' ,`RoomCount` = '5' ,`ListPrice` = '419000.00' ,`Status` = 'Active' ,`StreetName` = 'Hazel Pointe' ,`StreetNumber` = '3026' ,`StreetSuffix` = 'Trail' ,`City` = 'Spring' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2731' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'IMMACULATE SPACIOUS 5 BEDROOM 3 FULL BATH HOME! LARGE OPEN KITCHEN WITH GRANITE COUNTERTOPS AND LARGE GRANITE ISLAND/UPGRADED STAINLESS STEEL APPLIANCES/MASTER BEDROOM DOWNSTAIRS WITH MASTER BATH INCLUDING SEPARATE TUB AND SHOWER/GUEST BEDROOM DOWNSTAIRS NEXT TO FULL BATH/BEAUTIFUL PLANK FLOORING DOWNSTAIRS/INSIDE UTILITY INCLUDES WASHER AND DRYER/MANY ADDITIONAL UPDATES INCLUDING WATER SOFTNER SYSTEM , SOLAR PANELS AND BUILT-IN EXTERMINATION SYSTEM/HUGE GAMEROOM UPSTAIRS AND THREE BEDROOMS AND ONE FULL BATH UPSTAIRS.' ,`Acres` = '0.1142' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S688703 - WRIGHTS LANDING AT LEGENDS TRACE 03, BLOCK 1, LOT' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4976' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '535' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'BRADLEY ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'GRAND OAKS HIGH SCHOOL' ,`SchoolMiddle` = 'YORK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Wrights Landing At Legends Trace 03' ,`TaxAmount` = '9658' ,`TaxRate` = '3.1987' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667924674' WHERE `Matrix_Unique_ID` = '213738325' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-08T06:10:04.343' ,`MLSNumber` = '42290160' ,`ListAgentFullName` = 'Amy Larner' ,`ListOfficeName` = 'RE/MAX Leading Edge' ,`SellingAgentFullName` = 'Sonia Rossi' ,`SellingOfficeName` = 'HomeSmart' ,`Latitude` = '29.139204' ,`Longitude` = '-95.049940' ,`PhotoCount` = '47' ,`PostalCode` = '77554' ,`RoomCount` = '4' ,`ListPrice` = '887000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Pecos' ,`StreetNumber` = '22110' ,`StreetSuffix` = 'Drive' ,`City` = 'Galveston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1550' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Waterfront living with a POOL! This meticulously maintained custom home was built in 2019 and features soaring ceilings, open-concept living, and a stunning chef\'s kitchen. As you walk through the front door, your eye is drawn to all the designer touches from shiplap walls to the gorgeous beams that run throughout the main area. There are three bedrooms and two bathrooms. The beautifully designed kitchen features a large island overlooking the living and dining areas. The oversized upper deck allows for lazy days in the shade or the perfect place to soak in the sun\'s rays. Looking for more? Head to the lower level, and enjoy one of the multiple entertainment areas, including your own POOL complete with a heater and chiller! This tropical oasis is fully fenced with a cargo lift, and concrete bulkhead, complete with a boat lift, allowing easy access to Galveston Bay. Home conveys furnished with a few exclusions. This property is 100% TURNKEY, and ready for YOU!' ,`Acres` = '0.1033' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West End' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 121 HALL & JONES SUR LOT 94 SEA ISLE 15TH EXTENSION' ,`LotDesciption` = 'Subdivision Lot,Water View,Waterfront' ,`LotSize` = '4500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '225' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sea Isle Ext 15' ,`TaxAmount` = '15635' ,`TaxRate` = '2.0324' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667924674' WHERE `Matrix_Unique_ID` = '213975487' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-08T06:46:49.167' ,`MLSNumber` = '18488569' ,`ListAgentFullName` = 'Joshua Pedroso' ,`ListOfficeName` = 'Generation Realty & Associates' ,`SellingAgentFullName` = 'Joshua Want' ,`SellingOfficeName` = 'Compass RE Texas, LLC' ,`Latitude` = '29.701675' ,`Longitude` = '-95.746262' ,`PhotoCount` = '36' ,`PostalCode` = '77407' ,`RoomCount` = '8' ,`ListPrice` = '344900.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Tallow Knoll' ,`StreetNumber` = '7006' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2411' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'SELLERS ARE WILLING TO BUY DOWN BUYER\'S INTEREST RATE with an accepted offer!\r\nWelcome home to this HIDDEN GEM located in Lakemont. HUGE CUL-DE-SAC LOT!! BRAND NEW ROOF (2022) Tile throughout the WHOLE house, beautiful chandeliers in entry and dining, marble countertops with tile backsplash in the kitchen, top-of-the-line stainless Kitchen Aid appliances (with a double oven!), digital thermostat, Gameroom has been utilized as a 4th bedroom, large covered patio with a screened area for storage, sprinkler system and more! HOME HAS NEVER FLOODED!!' ,`Acres` = '0.2674' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LAKEMONT SEC 2, BLOCK 1, LOT 18' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '11649' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'MCNEILL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FOSTER HIGH SCHOOL' ,`SchoolMiddle` = 'WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakemont' ,`TaxAmount` = '6917' ,`TaxRate` = '2.8215' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667924674' WHERE `Matrix_Unique_ID` = '213980986' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-08T05:34:21.760' ,`MLSNumber` = '80499272' ,`ListAgentFullName` = 'Arash Asgharian' ,`ListOfficeName` = 'Keller Williams Realty - Memorial' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.757288' ,`Longitude` = '-95.591801' ,`PhotoCount` = '50' ,`PostalCode` = '77077' ,`RoomCount` = '6' ,`ListPrice` = '750000.00' ,`Status` = 'Active' ,`StreetName` = 'Heathwood' ,`StreetNumber` = '1215' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3043' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This is an absolute gem! Located in Energy Corridor, minutes from the beautiful Terry Hershey Park! 4bedrooms+study+garage apartment+storage, recently FULLY remodeled & NEVER FLOODED. Exterior-new roof, windows, AC, siding, gutters with leaf guard, exterior doors and more! The interior has been completely remodeled with a modern, open layout and VERY spacious kitchen including a 36” gas range&hood, french door fridge, built-in microwave&dishwasher, large island, kitchen prep area, ample cabinet space w/champagne hardware, floating shelves, and farmhouse sink with champagne faucet. If you love to cook/entertain, this kitchen is a dream! Entertain guests and spend the evening relaxing in this spacious open concept living area - gorgeous bar, sitting area & open dining/kitchen area. The gorgeous garage apartment makes the perfect area for both short/long term visitors. Make them feel at home with their own full bath and open bed/living area where they have their own space to relax in.' ,`Acres` = '0.2023' ,`Area` = '31' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Energy Corridor' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 7 BLK 4 WOODS OF LAKESIDE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8814' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '770' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ASHFORD/SHADOWBRIAR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'WEST BRIAR MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Woods Lakeside' ,`TaxAmount` = '8659' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667924674' WHERE `Matrix_Unique_ID` = '214302148' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-08T06:30:29.530' ,`MLSNumber` = '47612203' ,`ListAgentFullName` = 'Robin Loner' ,`ListOfficeName` = 'Real Estate Connection Int' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.821382' ,`Longitude` = '-95.418770' ,`PhotoCount` = '23' ,`PostalCode` = '77018' ,`RoomCount` = '7' ,`ListPrice` = '499990.00' ,`Status` = 'Active' ,`StreetName` = 'Wakefield Drive' ,`StreetNumber` = '873' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2459' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This fully furnished gorgeous 3 bedroom 3 1/2 bath home is in the prestigious much sought-after Garden Oaks area with no HOA. Centrally located just minutes from 610, I45, & 290. Surrounded by premium boutiques, restaurants, breweries, distilleries, coffee houses and entertainment along with the White Oak Bayou Greenway Trail nearby. The second floor design is open with tons of natural light and ideally set up for entertaining with a bright perfectly appointed kitchen with plenty of cabinets, huge island, beautiful chrome finishes, white granite counters, stainless appliances, and a balcony with a natural gas grill hookup. The primary suite offers a spacious bedroom and luxurious bath with soaking tub, large shower and walk-in closets. As an added bonus the 1st floor guest suite is huge and perfect for roommates or home office. Utility is appointed with quartz folding table and sink. Special epoxy sealant on garage floor.' ,`Acres` = '0.0492' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Oak Forest East Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 1 BLK 1 & .0625 INT IN RES A ESTATES AT WAKEFIELD' ,`LotDesciption` = 'Other' ,`LotSize` = '2145' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'GARDEN OAKS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'BLACK MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Garden Oaks' ,`TaxAmount` = '9730' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667924674' WHERE `Matrix_Unique_ID` = '214303305' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-08T06:41:12.717' ,`MLSNumber` = '59402628' ,`ListAgentFullName` = 'Brooke Griffith' ,`ListOfficeName` = 'Meadows Property Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.732139' ,`Longitude` = '-95.736743' ,`PhotoCount` = '34' ,`PostalCode` = '77450' ,`RoomCount` = '10' ,`ListPrice` = '489000.00' ,`Status` = 'Active' ,`StreetName` = 'Frostmeadow' ,`StreetNumber` = '3606' ,`StreetSuffix` = 'Court' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3087' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous, fully remodeled home on a culdesac lot, in a quiet gated community. Home features formal dining, large home office/study, open concept living and kitchen. The kitchen features modern cabinetry with beautiful quartz countertops and stainless steel appliances. The spacious primary retreat with fully remodeled ensuite bathroom and large walk-in closet, is located on the first floor with large windows overlooking the backyard. Gameroom and 3 large secondary rooms with 2 bathrooms on second floor, make this the perfect family home. Three car detached garage, sprinkler system, water softener and BRAND NEW 30 YEAR ROOF (2022) with transferrable warranty. Large covered back patio with full outdoor kitchen is the perfect spot to relax and hang out with friends and family. Conveniently located close to i10 and Westpark for ease of transportation and zoned to incredible KISD schools. This is a must see and won\'t last long! ' ,`Acres` = '0.2465' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'GREENS AT WILLOW FORK SEC 2, BLOCK 1, LOT 14' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '10736' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '850' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'CREECH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CINCO RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'BECK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Greens At Willow Fork Sec 2' ,`TaxAmount` = '8434' ,`TaxRate` = '2.395' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667924675' WHERE `Matrix_Unique_ID` = '214309572' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-08T05:10:20.330' ,`MLSNumber` = '31489157' ,`ListAgentFullName` = 'Shijimon Jacob' ,`ListOfficeName` = 'Everest Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.526435' ,`Longitude` = '-95.540607' ,`PhotoCount` = '50' ,`PostalCode` = '77459' ,`RoomCount` = '10' ,`ListPrice` = '680000.00' ,`Status` = 'Active' ,`StreetName` = 'Merlins' ,`StreetNumber` = '5327' ,`StreetSuffix` = 'Trail' ,`City` = 'Missouri City' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3465' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Magnificently Elegant Home with Two Primary Bedrooms ! Located on a corner lot only minutes from major conveniences, this 4BR/4.5BA, 3,465sqft property embodies rustic sophistication with a gorgeous brick and stucco exterior, meticulous landscaping, an open floorplan, high foyer ceilings, engineered hardwood floors, lovely formal dining room, office w/French doors, and a great room w/gas fireplace and overhead catwalk. Open for easy entertaining, the gourmet kitchen features stainless-steel appliances, granite counters, an island, an enormous pantry, and an adjoining spice kitchen. Each level has a primary bedroom with a deep closet and an en suite featuring dual sinks, a jetted tub, and a shower. Additionally, the main-level primary bedroom boasts tray ceilings and bay windows. Other features: 3-car tandem garage, laundry w/gas hookup, tankless water heater, sprinkler system, water softener, huge game room, guest bedrooms w/attached baths, and more! Call for a tour!' ,`Acres` = '0.2253' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'AVALON AT SIENNA PLANTATION SEC 2 FINAL PLAT OF, BLOCK 2, LO' ,`LotDesciption` = 'Corner' ,`LotSize` = '9814' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1254' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'SIENNA CROSSING ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'BAINES MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Avalon At Sienna Plantation Sec 2' ,`TaxAmount` = '7971' ,`TaxRate` = '2.8129' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667924675' WHERE `Matrix_Unique_ID` = '214375443' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-08T05:30:55.783' ,`MLSNumber` = '61686125' ,`ListAgentFullName` = 'Julie Upton' ,`ListOfficeName` = 'Pearwood Properties, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.301870' ,`Longitude` = '-94.907538' ,`PhotoCount` = '37' ,`PostalCode` = '77554' ,`RoomCount` = '4' ,`ListPrice` = '799000.00' ,`Status` = 'Active' ,`StreetName` = 'Admiral' ,`StreetNumber` = '341' ,`StreetSuffix` = 'Circle' ,`City` = 'Tiki Island' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2062' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully updated waterfront property has so much to offer...walk into an open concept floorplan with a large family room with high ceilings & a fireplace, kitchen with large island & granite countertops, breakfast room overlooking the bay; 2 bedrooms downstairs & a full bath; 2 bedrooms upstairs, both feature balconies. The primary bedroom has an en suite bath complete with a garden tub, separate shower, his & hers closets & dual sinks. A second upstairs bedrooms also has an en suite bath. Outdoors you will find a bar with roll up window downstairs adjacent to a storage room, boat house with boat lift, fenced side yard perfect for pets or a pool, spacious area under the home for entertaining as well a spacious upper deck. This home has been well maintained & shows like a model home. Other features include luxury vinyl flooring throughout, plantation shutters, double pane windows, cargo lift & more! The location is convenient to the open bay which also offers magnificent views.' ,`Acres` = '0.104' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tiki Island' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 7 LOT 28 BLK 1 TIKI YACHT CLUB COLONY' ,`LotDesciption` = 'Cul-De-Sac,Waterfront' ,`LotSize` = '4530' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '52 - Texas City' ,`SchoolElementary` = 'HAYLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA MARQUE HIGH SCHOOL (TEXAS CITY)' ,`SchoolMiddle` = 'LA MARQUE MIDDLE SCHOOL (TEXAS CITY)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1.5' ,`Style` = 'Other Style' ,`Subdivision` = 'Tiki Yacht Club Colony' ,`TaxAmount` = '10513' ,`TaxRate` = '2.4912' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1984' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667924675' WHERE `Matrix_Unique_ID` = '214388548' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-08T06:44:33.203' ,`MLSNumber` = '95922170' ,`ListAgentFullName` = 'Connie Renouard' ,`ListOfficeName` = 'Parkway Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.211280' ,`Longitude` = '-95.567283' ,`PhotoCount` = '45' ,`PostalCode` = '77382' ,`RoomCount` = '7' ,`ListPrice` = '399900.00' ,`Status` = 'Active' ,`StreetName` = 'Flickering Sun' ,`StreetNumber` = '22' ,`StreetSuffix` = 'Court' ,`City` = 'The Woodlands' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1904' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Location and charm!!! This 3 bedroom, 2 1/2 bath pristine property with soaring ceilings and open floorplan has it all! Prepare to be amazed by the newly updated kitchen, luxury wood plank vinyl flooring, and fresh interior paint throughout. Kitchen features white cabinetry with updated hardware and stainless appliances, quartz countertops, and white subway tile backsplash. Come see this secluded property tucked away on a quiet cul-de-sac lot in the heart of The Woodlands. This quaint neighborhood is very private with only one entry and exit. Zoned to Buckalew Elementary School (ranked top tier in the state of Texas), Mitchell Intermediate and The Woodlands High School. Ask about the refrigerator, washer, dryer, TVs, and furniture which are also available for purchase.' ,`Acres` = '0.1154' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Seller may be subject to foreign tax and Buyer withholding per IRS,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'WDLNDS VIL ALDEN BR 93, BLOCK 1, LOT 86' ,`LotDesciption` = 'Corner,Cul-De-Sac,Subdivision Lot' ,`LotSize` = '5027' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'BUCKALEW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'THE WOODLANDS HIGH SCHOOL' ,`SchoolMiddle` = 'MCCULLOUGH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Wdlnds Village Alden Br 93' ,`TaxAmount` = '7458' ,`TaxRate` = '2.1811' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667924675' WHERE `Matrix_Unique_ID` = '214391474' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-08T06:36:51.317' ,`MLSNumber` = '7305687' ,`ListAgentFullName` = 'Jennifer Vidales' ,`ListOfficeName` = 'RE/MAX Opportunities' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.314883' ,`Longitude` = '-96.095827' ,`PhotoCount` = '24' ,`PostalCode` = '77488' ,`RoomCount` = '3' ,`ListPrice` = '315500.00' ,`Status` = 'Active' ,`StreetName` = 'Resident' ,`StreetNumber` = '520' ,`StreetSuffix` = 'Street' ,`City` = 'Wharton' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3043' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous family home located in the heart of Wharton, Texas. Come home to upgraded tile, laminate wood flooring, upgraded hardware, built-in oven and cooktop. Large primary bedroom includes relaxing sitting area. Primary bath with built-ins, beautiful custom tile, wainscoting, linen closet as well as walk-in closet. Each room has its own special touches from sliding barn door leading into the bathroom to recent paint. Family room as well as the large living room provide space for days. Enjoy gatherings in your large kitchen leading out to the covered patio. From large gorgeous trees to the side of the home entry with covered parking, this home has it all.' ,`Acres` = '0.3329' ,`Area` = '55' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'BARBEE BLOCK 10 LOT 8' ,`LotDesciption` = 'Other' ,`LotSize` = '14501' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '180 - Wharton' ,`SchoolElementary` = 'CG SIVELLS/WHARTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WHARTON HIGH SCHOOL' ,`SchoolMiddle` = 'WHARTON JUNIOR HIGH' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Barbee' ,`TaxAmount` = '6549' ,`TaxRate` = '2.3512' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1961' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667924676' WHERE `Matrix_Unique_ID` = '214432510' --> 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','214443266','1667924676','214443266','2022-11-08T05:47:26.357','41368622','Marie Hanna','Weichert, Realtors - BCS','','','29.996865','-95.666836','20','77429','7','299900.00','Active','Arapaho Bend','15927','Lane','Cypress','2','0','3','1904','Single-Family','Lovely, spacious and updated single story home with open living spaces. Fresh paint and flooring, NO CARPET!!! High ceiling split floor plan. Entry opens to a formal living room. Spacious kitchen with island, pantry and breakfast bar. Breakfast room and kitchen open to a large family room. Primary bedroom has a garden bathtub and a separate shower. Ceiling fans in all rooms. Extended patio in the backyard. Close to major freeways: 290/99 and shopping outlet. 20 min to Beltway 8 and less than 30 min to 610 loop. Zoned to exemplary Cypress Fairbanks school district.','0.1626','35','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','','','Cypress North','Central Gas','1','LT 36 BLK 1 STABLEWOOD FARMS NORTH SEC 4 R/P','Subdivision Lot','7081','Appraisal District','','665','0','','2','Gas Oven','0','','','Gas Range','','Wood Shingle','13 - Cypress-Fairbanks','FARNEY ELEMENTARY SCHOOL','CYPRESS WOODS HIGH SCHOOL','GOODSON MIDDLE SCHOOL','Supra Keybox,Vacant/Unoccupied','Appraisal District','1','Traditional','Stablewood Farms North Sec 04 R','6106','2.94','Public Sewer,Water District','2010','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-08T06:18:27.227' ,`MLSNumber` = '92371924' ,`ListAgentFullName` = 'Kayla Armstrong' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.431930' ,`Longitude` = '-95.439169' ,`PhotoCount` = '24' ,`PostalCode` = '77583' ,`RoomCount` = '5' ,`ListPrice` = '349900.00' ,`Status` = 'Active' ,`StreetName` = 'Agassiz' ,`StreetNumber` = '2414' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2513' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Lovely Castlerock Plan Featuring 4 Bedrooms, 2.5 Baths, Formal Office, And Large Family Room With High Ceilings And Open To Kitchen. Primary Suite Located On The Main Level Is Large And Luxurious.' ,`Acres` = '0.1458' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'SIERRA VISTA SEC 2 (A0288 HT&BRR) BLK 4 LOT 40' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6351' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Right Side' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sierra Vista Sec 2' ,`TaxAmount` = '11807' ,`TaxRate` = '3.6007' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667924676' WHERE `Matrix_Unique_ID` = '214457358' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-08T06:32:03.597' ,`MLSNumber` = '78215627' ,`ListAgentFullName` = 'Carla Wade' ,`ListOfficeName` = 'RE/MAX Space Center-Clear Lake' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.446679' ,`Longitude` = '-95.087963' ,`PhotoCount` = '29' ,`PostalCode` = '77539' ,`RoomCount` = '8' ,`ListPrice` = '299900.00' ,`Status` = 'Active' ,`StreetName` = 'White Wing' ,`StreetNumber` = '522' ,`StreetSuffix` = 'Court' ,`City` = 'Dickinson' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1875' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This lovely one story 4/2/2 sits on a large lot, has recently been beautifully updated and is sold furnished! All of the windows were recently replaced, and the flooring has recently been updated with gorgeous wood look tile flooring in all of the living areas, and recent carpet in the bedrooms. The kitchen boasts recently updated cabinets, granite counters, recent stainless appliances, and a new stainless fridge in 11/22. The Washer and dryer are included, and the water heater has been recently replaced. The large family room is open to the dining room and features a beautiful brick accent wall with cozy fireplace and lovely boxed windows. The TV over the fireplace is included! The Primary bedroom is so spacious, with views of the back yard, and the primary bath has been renovated with a lovely walk-in shower with decorator tile. The back yard is large enough for a pool and plenty of room for outdoor activities. Better make your appointment today, this one won\'t last!' ,`Acres` = '0.1928' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 19 PERRY & AUSTIN SUR LOT 5 BLK 2 DOVE MEADOWS' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'CALDER ROAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'LOBIT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Dove Meadow' ,`TaxAmount` = '6725' ,`TaxRate` = '2.4697' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1990' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667924676' WHERE `Matrix_Unique_ID` = '214458124' --> 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','214512161','1667924676','214512161','2022-11-08T06:31:10.230','93520522','Patrick Rollins','City Cottage Realty','','','29.836150','-95.446954','34','77018','9','1039900.00','Active','Latexo','1915','Drive','Houston','4','1','4','3400','Single-Family','New construction, not in flood plain! Oversized garage, hardwood floors throughout, quartz countertops, gorgeous trim work and much more!','0.1653','9','City Cottage','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','No Disclosures','1','','0','Oak Forest East Area','Central Gas','0','LT 5 BLK 84 OAK FOREST SEC 12','Subdivision Lot','7200','Appraisal District','','','1','Never Lived In','2','Gas Oven','0','','','Gas Range','','Composition','27 - Houston','STEVENS ELEMENTARY SCHOOL','WALTRIP HIGH SCHOOL','BLACK MIDDLE SCHOOL','Appointment Required,Supra Keybox','Builder','1.5','Traditional','Oak Forest Sec 12','7363','2.3307','Public Sewer,Public Water','2022','Builder'); --> New record created successfully