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-09-11T17:05:11.203' ,`MLSNumber` = '13931889' ,`ListAgentFullName` = 'Connie Reddington' ,`ListOfficeName` = 'King & Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.225431' ,`Longitude` = '-95.768552' ,`PhotoCount` = '13' ,`PostalCode` = '77354' ,`RoomCount` = '6' ,`ListPrice` = '350000.00' ,`Status` = 'Active' ,`StreetName` = 'Brenda' ,`StreetNumber` = '809' ,`StreetSuffix` = 'Lane' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '2' ,`SqFtTotal` = '1514' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great location to access to 249 on minutes away from shops, homes needs tlc has lots of possibility on the size and location of the lot, home was brought from the heights over and set up the home has a lot of history and is a gem high ceiling through out DE attached garage, storage shed and extra small home in the back of the property. Seller is ready to move . Lots of room to make it your own bring a camper or RV, horses, build a another home on lots,' ,`Acres` = '2' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'S927300 - TOBY SMITH HIGH CHAPARRAL, LOT 7, SERIAL UNKNOWN,' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '87120' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'MAGNOLIA ELEMENTARY SCHOOL (MAGNOLIA)' ,`SchoolHigh` = 'MAGNOLIA WEST HIGH SCHOOL' ,`SchoolMiddle` = 'MAGNOLIA JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Toby Smith High Chaparral' ,`TaxAmount` = '2724' ,`TaxRate` = '1.8587' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '1940' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663709416' WHERE `Matrix_Unique_ID` = '206501699' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-11T16:43:17.790' ,`MLSNumber` = '29896445' ,`ListAgentFullName` = 'Brenda Moon' ,`ListOfficeName` = 'Alliance Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.047512' ,`Longitude` = '-95.335551' ,`PhotoCount` = '42' ,`PostalCode` = '77373' ,`RoomCount` = '12' ,`ListPrice` = '2450000.00' ,`Status` = 'Active' ,`StreetName` = 'Treaschwig' ,`StreetNumber` = '6530' ,`StreetSuffix` = 'Road' ,`City` = 'Spring' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '4528' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful unrestricted Ranch Style home on approximately 27.34 acres. Located in desirable Spring, Texas. Area attractions include but not limited too, scenic forested trails in Carter Park along Spring Creek great for hiking, biking and equestrian activities. Cypresswood Golf Club, Property has a 6 stall barn and tack room with a fully fenced pasture. Home features 5/6 bedrooms with built-ins and large closets. Primary suite on 1st floor. Kitchen is a cooks dream and offers great entertaining options, formal dining, Executive Study/Office to allow privacy for remote work from home. Huge bonus room upstairs that can be used for game room or whatever your heart desires. Crown molding, 6 car garage with loft, plenty of parking for entertaining, RV, ETC. Easy access to Houston IAH Airport, shopping, and dining. Property is AG EXEMPT so bring your horses. Great Income Development Opportunity. THIS PROPERTY IS A MUST SEE!!! All sizes are approximate and should be verified.' ,`Acres` = '27.34' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring East' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TRS 11C-2 23A-1A 23A-2 & 23B-1 (HOMESITE) ABST 282 R GILES' ,`LotDesciption` = 'Cleared' ,`LotSize` = '761148' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'CHET BURCHETT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'DUEITT MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Ranch' ,`Subdivision` = 'Giles Robert' ,`TaxAmount` = '9226' ,`TaxRate` = '2.1367' ,`WaterSewer` = 'Aerobic,Well' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663709416' WHERE `Matrix_Unique_ID` = '206847096' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-11T17:36:26.523' ,`MLSNumber` = '71409245' ,`ListAgentFullName` = 'Jessica Fetzer' ,`ListOfficeName` = 'Abundant Living Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.353426' ,`Longitude` = '-97.722003' ,`PhotoCount` = '24' ,`PostalCode` = '78757' ,`RoomCount` = '8' ,`ListPrice` = '599900.00' ,`Status` = 'Active' ,`StreetName` = 'Burrell' ,`StreetNumber` = '7914' ,`StreetSuffix` = 'Drive' ,`City` = 'Austin' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1704' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Updated 3 bedroom, 2 bath home on an over-sized lot with converted garage space, insulated, sheetrock and fully air conditioned with brand new Trane HVAC to service the entire home, recently added new insulation in the attic, updated kitchen, light fixtures and fans, newer carpet and paint, original \"retro\" bathrooms. Original hardwoods are under carpeted areas, could be refinished. Storage building on its own slab in the backyard. Convenient location to downtown, UT, The Domain, Apple Campus and so much more!' ,`Acres` = '0.2118' ,`Area` = '83' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate,Other Disclosures,Tenant Occupied' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LOT 8 WOOTEN PARK SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9226' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '111 - Austin' ,`SchoolElementary` = 'WOOTEN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NAVARRO HIGH SCHOOL (AUSTIN)' ,`SchoolMiddle` = 'BURNET MIDDLE SCHOOL (AUSTIN)' ,`ShowInstructions` = 'Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Wooten Park Sec 01' ,`TaxAmount` = '8597' ,`TaxRate` = '2.1767' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1961' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663709416' WHERE `Matrix_Unique_ID` = '208445424' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-11T16:58:49.757' ,`MLSNumber` = '57218655' ,`ListAgentFullName` = 'Heather Carlile' ,`ListOfficeName` = 'Blavesco, LTD' ,`SellingAgentFullName` = 'Heather Carlile' ,`SellingOfficeName` = 'Blavesco, LTD' ,`Latitude` = '30.420398' ,`Longitude` = '-95.553358' ,`PhotoCount` = '21' ,`PostalCode` = '77318' ,`RoomCount` = '4' ,`ListPrice` = '289000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Ridgecrest' ,`StreetNumber` = '12264' ,`StreetSuffix` = 'Drive' ,`City` = 'Willis' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1699' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Spacious 1 story house, 4 bedrooms 2 baths and 2 car garage. Great location in Lake Conroe Hills with Lake Conroe access. Home was just refreshed after tenant with new paint, new carpet, and ready to move in immediately.' ,`Acres` = '0.2581' ,`Area` = '39' ,`BuilderName` = 'Kendall Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LAKE CONROE HILLS 02, BLOCK 5, LOT 104' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11244' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'W. LLOYD MEADOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERT P. BRABHAM MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lake Conroe Hills 02' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663709416' WHERE `Matrix_Unique_ID` = '209993145' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-11T16:41:02.730' ,`MLSNumber` = '30339770' ,`ListAgentFullName` = 'Lin Golson' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.274067' ,`Longitude` = '-95.556212' ,`PhotoCount` = '42' ,`PostalCode` = '77316' ,`RoomCount` = '10' ,`ListPrice` = '849000.00' ,`Status` = 'Active' ,`StreetName` = 'Sunridge' ,`StreetNumber` = '103' ,`StreetSuffix` = 'Court' ,`City` = 'Montgomery' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3915' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Exquisite Partners in Building highly desired one story, 4 bed, 3 bath, 4 car garage home nestled on a corner cul-de-sac lot located in the golf course community of Woodforest. Beyond the double door entry is an open flowing floor plan complete with soaring ceilings, wood floors, formal dining room, dry bar, spacious family room , & game room. Extraordinary kitchen showcases 6 burner stove, double ovens, under cabinet lighting, pantry, breakfast area and large island perfect for entertaining. Primary suite includes a sitting area while the primary bath features a jetted tub, double sinks, HUGE walk in closet, and walk through shower. The private resort-like outdoor setting boasts pool w/spa, pergola and pizza oven, and outdoor kitchen for ultimate indoor & outdoor entertaining. Enjoy all the amenities that Woodforest has to offer with Harvest Market, shopping, restaurants, pharmacy, doctors, fitness, coffee shops, Pool, splash pad & more!' ,`Acres` = '0.3018' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S965217 - WOODFOREST 17, BLOCK 1, LOT 8' ,`LotDesciption` = 'Corner,Cul-De-Sac,In Golf Course Community' ,`LotSize` = '13145' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1265' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'LONE STAR ELEMENTARY SCHOOL (MONTGOMERY)' ,`SchoolHigh` = 'LAKE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'OAK HILL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodforest 17' ,`TaxAmount` = '14803' ,`TaxRate` = '2.665' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663709416' WHERE `Matrix_Unique_ID` = '210592329' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-11T16:49:21.127' ,`MLSNumber` = '82545639' ,`ListAgentFullName` = 'Jaime Connell' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.833936' ,`Longitude` = '-95.480084' ,`PhotoCount` = '45' ,`PostalCode` = '77092' ,`RoomCount` = '7' ,`ListPrice` = '280000.00' ,`Status` = 'Active' ,`StreetName` = 'De Milo' ,`StreetNumber` = '6106' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1640' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fabulous location! This one story, rare 4-bedroom brick home in Forest Pines is situated on a large lot at the end of a quiet cul-de-sac. Upon entering the home, you are greeted by a spacious flex room which could be used as a formal living/dining, game room or home office. The family room has French doors leading out to a covered patio and backyard. Kitchen features breakfast bar, granite counters, gas cooktop and plenty of cabinet and counter space. Split floor plan separates the primary suite from the secondary bedrooms. All bedrooms have ceiling fans and walk-in closets. Primary bath features granite counter and large granite shower. Secondary bath features granite counter and shower/tub combo. Tile and granite flooring throughout, no carpet in this home! New HVAC condenser installed 2018, water heater 2022. Conveniently located close to 290/610/shops/restaurants. Great location for commuters. With all it has to offer and a little TLC from you, it can be the perfect home!' ,`Acres` = '0.1848' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Oak Forest West Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 24 BLK 8 FOREST PINES SEC 2B' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8050' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '25' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WAINWRIGHT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SCARBOROUGH HIGH SCHOOL' ,`SchoolMiddle` = 'CLIFTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Forest Pines' ,`TaxAmount` = '5844' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1965' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663709416' WHERE `Matrix_Unique_ID` = '210641791' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-11T17:09:32.250' ,`MLSNumber` = '67975190' ,`ListAgentFullName` = 'Salvador Caballero' ,`ListOfficeName` = 'ListWithFreedom.com' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.085664' ,`Longitude` = '-97.314077' ,`PhotoCount` = '22' ,`PostalCode` = '78602' ,`RoomCount` = '9' ,`ListPrice` = '480000.00' ,`Status` = 'Active' ,`StreetName` = 'Pauwela' ,`StreetNumber` = '124' ,`StreetSuffix` = 'Lane' ,`City` = 'Bastrop' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2200' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful Stunning Custom Built New Home Construction Single Story with an open floor plan located in Tahitian Village!!!!!!!! With Gorgeous white Cabinetry throughout the house. Nice Granite Countertops!!! Gorgeous Marble backsplash in master shower! Walk in pantry has a stunning slide Barn Door. A must see in person!!!!!' ,`Acres` = '0.24' ,`Area` = '83' ,`BuilderName` = 'Rosebberg Garcia' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Heat Pump' ,`HOAMandatory` = '0' ,`Legal` = 'TAHITIAN VILLAGE, UNIT 5 BLK 5 LOT 405' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10454' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '210 - Bastrop' ,`SchoolElementary` = 'EMILE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BASTROP HIGH SCHOOL' ,`SchoolMiddle` = 'BASTROP MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Tahitian Village,' ,`TaxAmount` = '3392' ,`TaxRate` = '1.8898' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663709416' WHERE `Matrix_Unique_ID` = '210687549' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-11T17:34:22.333' ,`MLSNumber` = '96833717' ,`ListAgentFullName` = 'Jesse Reneau' ,`ListOfficeName` = 'Richards & Assoc. Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.452768' ,`Longitude` = '-95.295529' ,`PhotoCount` = '22' ,`PostalCode` = '77378' ,`RoomCount` = '3' ,`ListPrice` = '285000.00' ,`Status` = 'Active' ,`StreetName` = 'Sandy Creek' ,`StreetNumber` = '610' ,`StreetSuffix` = 'Road' ,`City` = 'Willis' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1352' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Nature enthusiasts relax on the 375sq ft deck overlooking Boggy Creek. Living on the peaceful creek offers the opportunity to watch wildlife in their natural habitat. \r\n \r\n3 bed 2 bath upgraded manufactured home situated on nearly 4 acres that has never flooded.\r\nLocated in San Jacinto county so low tax rates but zoned for Willis ISD. Close enough to easily go to the upcoming HEB grocery store but far from the hustle and bustle of living in the city.' ,`Acres` = '3.759' ,`Area` = '64' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Coldspring/South San Jacinto County' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'SANDY CREEK ADDITION #1 & #2, LOT 48 & 49, SECTION 1, ACRES' ,`LotDesciption` = 'Water View,Waterfront' ,`LotSize` = '163742' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'EDWARD B. CANNAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'LYNN LUCAS MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sandy Creek #1 & #3' ,`TaxAmount` = '862' ,`TaxRate` = '1.9577' ,`WaterSewer` = 'Aerobic,Well' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663709417' WHERE `Matrix_Unique_ID` = '210825977' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-11T16:40:04.603' ,`MLSNumber` = '24733510' ,`ListAgentFullName` = 'John Branch' ,`ListOfficeName` = 'Cynthia Tibbs Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.858869' ,`Longitude` = '-95.223038' ,`PhotoCount` = '8' ,`PostalCode` = '77044' ,`RoomCount` = '3' ,`ListPrice` = '70000.00' ,`Status` = 'Active' ,`StreetName` = 'Grand Isle' ,`StreetNumber` = '9426' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1280' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'LOT IS NOT FOR SALE! Mobile home is in good shape, looking for savvy investors or buyers who want a place to call their home.' ,`Acres` = '0' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = '1998 T0WN & COUNTRY 16X76 WHT/GRN HUD#NTA0825421 SER#TXCTCMW' ,`LotDesciption` = 'Other' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '46 - Sheldon' ,`SchoolElementary` = 'GARRETT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CE KING HIGH SCHOOL' ,`SchoolMiddle` = 'MICHAEL R. NULL MIDDLE SCHOOL' ,`ShowInstructions` = 'Temporarily No Showings' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'N/A' ,`TaxAmount` = '439' ,`TaxRate` = '3.0293' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663709417' WHERE `Matrix_Unique_ID` = '210882300' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-11T16:04:38.567' ,`MLSNumber` = '38541683' ,`ListAgentFullName` = 'Ebin Kurian' ,`ListOfficeName` = 'Stride Real Estate, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.510330' ,`Longitude` = '-95.426837' ,`PhotoCount` = '41' ,`PostalCode` = '77583' ,`RoomCount` = '14' ,`ListPrice` = '415000.00' ,`Status` = 'Active' ,`StreetName` = 'Rainy Garden' ,`StreetNumber` = '5205' ,`StreetSuffix` = 'Court' ,`City` = 'Rosharon' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3081' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to this beautiful 2-story home nestled in the heart of Rosharon with easy access to Hwy 288, Hwy 6, & FM 521. This well-maintained home is 4 bed, 2 bed down, 3.5 bath giving plenty of space to everyone. With crown molding throughout the home, high ceilings, and eye-catching granite countertops in the kitchen this home will wow anyone. This cozy home also includes a spacious home theater room perfect for those days you just want to relax & unwind. This fully guttered home is also equipped with a prep kitchen. The home comes with two new water heaters, new & modern carpet throughout the home, & is freshly painted. This home is equipped with a sprinkler system, water softener, and a reverse osmosis system as well. The property has never been flooded nor experienced any power cut during the freeze in 2021. The seller is willing to convert the prep kitchen to a covered patio if requested. The new Manvel town center is only a few mins away. Schedule your private tour today' ,`Acres` = '0.1518' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SAVANNAH MEADOWS SEC 10 (A0562 HT&BRR) BLK 2 LOT 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6612' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '670' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'SAVANNAH LAKES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'MANVEL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Savannah Meadows Sec 10' ,`TaxAmount` = '9514' ,`TaxRate` = '3.1908' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663709417' WHERE `Matrix_Unique_ID` = '211205728' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-11T16:40:51.030' ,`MLSNumber` = '55901222' ,`ListAgentFullName` = 'Cherie Wolfe' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = 'Michele Gordon' ,`SellingOfficeName` = 'HomeSmart' ,`Latitude` = '30.328845' ,`Longitude` = '-95.460571' ,`PhotoCount` = '35' ,`PostalCode` = '77301' ,`RoomCount` = '8' ,`ListPrice` = '305000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Woodsway' ,`StreetNumber` = '200' ,`StreetSuffix` = 'Street' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2977' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home to this lovely single story with strong bones and charming character. Double door entrance brings you into the huge Living area. Beautiful vaulted ceilings with a cozy wood burning fireplace. You will love the spacious kitchen with charming breakfast room. Don\'t miss the brick flooring in the Laundry Room! It flows throughout the kitchen floor, breakfast room, hallway, and laundry room. BONUS* the laminate wood flooring can be removed to expose this beautiful real brick flooring. If storage is what you need, this home has it. Cedar lined closets with built-ins and shelves throughout the home. The Primary bathrooms and closets are separated by a fully tiled Roman Bath/Shower. This home has so much character and features you just don\'t see anymore. Just minutes from Historical Down Town Conroe. Easy access to 45! Don\'t miss this opportunity to make this house your HOME!' ,`Acres` = '0.2091' ,`Area` = '19' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Northeast' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TANGLEWOOD 01, BLOCK 3, LOT 3' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '9108' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'REAVES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Tanglewood 01' ,`TaxAmount` = '4153' ,`TaxRate` = '2.1863' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1965' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663709417' WHERE `Matrix_Unique_ID` = '211221750' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-11T16:30:54.663' ,`MLSNumber` = '79474689' ,`ListAgentFullName` = 'Nereida Pita' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.673963' ,`Longitude` = '-95.199779' ,`PhotoCount` = '21' ,`PostalCode` = '77502' ,`RoomCount` = '5' ,`ListPrice` = '399900.00' ,`Status` = 'Active' ,`StreetName` = 'Fresa' ,`StreetNumber` = '910' ,`StreetSuffix` = 'Road' ,`City` = 'Pasadena' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2023' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '** No Restrictions** 3 bedrooms/ 2 baths with endless possibilities come and make it your own, land is a little over 2 Acres cleared, the back has a big workshop open towards the back of the house, great to work from home shop or rent it out. Two Poll Barns, Great for FFA Projects. Mobile Homes are welcomed. All property information should be independently verified.' ,`Acres` = '2.0014' ,`Area` = '6' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pasadena' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'W 1/2 OF LT 82 ALTA VISTA ACRES' ,`LotDesciption` = 'Cleared' ,`LotSize` = '87180' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Above Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'BAILEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SAM RAYBURN HIGH SCHOOL' ,`SchoolMiddle` = 'PARKVIEW INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Back,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Alta Vista Acres' ,`TaxAmount` = '6193' ,`TaxRate` = '2.6514' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663709417' WHERE `Matrix_Unique_ID` = '211236825' --> 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','211729341','1663709417','211729341','2022-09-11T17:31:56.350','94957129','Rodrick Dixon','First Class, Realtors®','','','29.640492','-95.510429','26','77071','7','265500.00','Active','Laleu','12518','Lane','Houston','2','1','3','2435','Single-Family','This spacious 2,435 sqft single-family home is a 2-story, 3 bed, 2 1/2 bath, in a quiet neighborhood zoned to the Houston ISD. This home is minutes from 610, Beltway 8, Highway 90, Highway 59, The Medical Center, and Downtown, making the work commute relatively faster. This home has a nice floor plan, which includes hardwood floors, new tile in both bathrooms, ceramic tile in the kitchen, black granite countertops in the kitchen & wet bar, a custom wood-burning fireplace, an open game room area, and a covered deck out back.','0.1125','20','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Mock Fireplace','1','Missouri City Area','Central Gas','1','LT 29 BLK 6 FONMEADOW SEC 3','Subdivision Lot','4900','Appraisal District','','350','0','','2','','0','','','','','Composition','27 - Houston','GROSS ELEMENTARY SCHOOL','WESTBURY HIGH SCHOOL','WELCH MIDDLE SCHOOL','Appointment Required,Supra Keybox','Appraisal District','2','Other Style','Fonmeadow','4611','2.8249','Public Sewer,Water District','1983','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','211821409','1663709417','211821409','2022-09-11T16:17:32.533','27985396','Reginald Whyte JR','God\'s Asset Realty Inc.','','','29.521504','-95.371484','36','77578','12','545000.00','Active','Kestrel Ridge Ct','4246','','Manvel','3','1','4','3524','Single-Family','Welcome home to this immaculate Westin built home, built in 2019, the “Preston III” plan, located in Sedona Lakes. This home features an inviting large open concept living/dining/kitchen with soaring ceilings proving tons of natural light. The living room features a fireplace, surround sound speakers, and a magnificent view of the breathtaking rotunda. The Primary suite, located on the first floor, features an ensuite bathroom with two sinks, built in vanity, large free-standing tub, and a walk-in shower. There is also a private office, a formal dining room, three additional bedrooms upstairs, a game room, and media room with surround sound speakers. The backyard has a large patio and plenty of room for a pool. This home has many upgrades including a whole home surge protector, smart window shades, smart sprinkler system, 7.1 surround sound system in media room, 2.1 surround sound system in living room, and smart thermostats. Easy access to the Medical Center and Downtown.','','5','Westin Homes','','Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gaslog Fireplace','1','Alvin North','Central Gas','1','SEDONA LAKES Sec 10(A0541 ACH&B)(A0320 E LITTLE) BLK 1 LOT 1','Subdivision Lot','7723','Appraisal District','','860','0','','2','Gas Oven,Single Oven','0','','','Gas Range','','Composition','3 - Alvin','POMONA ELEMENTARY SCHOOL','MANVEL HIGH SCHOOL','MANVEL JUNIOR HIGH SCHOOL','Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox','Appraisal District','2','Traditional','Sedona Lakes','','3.4474','Public Sewer,Public Water,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','212017597','1663709417','212017597','2022-09-11T16:58:38.277','41069439','Jarred DeMore','Keller Williams SoutheastTexas','','','29.412182','-94.700945','46','77650','5','750000.00','Active','Johnson Crawford','804 1/2','Circle','Port Bolivar','2','0','3','1411','Single-Family','New construction with incredible unobstructed VIEWS just steps from the beach. Enjoy the massive deck overlooking the gulf w/an additional deck to the west! 3/2 with large open living concept with 10 foot high ceilings! The kitchen is a dream for those who appreciate an awesome layout and ss appliances! And that island will seat quiet a crowd! Bedrooms-super spacious! Primary has an amazing walk-in shower/double sinks AND a huge walk-in closet with built-ins. The decorator tones, gorgeous fixtures, finishes and lovely furnishings will welcome all of your renters/family/friends! Just when you think it can\'t get any better...you\'ll even have a brand new washer/dryer! Enclosed garage for all of your toys! Tons of space downstairs to entertain large crowds! This dream home will come mostly furnished, brand new! Located in a quiet area w/ lighter traffic. Close to ferry, shopping, restaurants! It\'s your turn to own a piece of heaven here in Crystal Beach! Come take a look and fall in love!','','33','Traditional Homes','','','','No Disclosures','1','','','Port Bolivar','Central Electric','0','ABST 203 A VAN NOSTRAND SUR LOT 54 -54-1 JOHNSON-CRAWFORD AD','Water View','4356','Appraisal District','','','1','Never Lived In','1','','0','','','','','Composition','22 - Galveston','GISD OPEN ENROLL','BALL HIGH SCHOOL','GISD OPEN ENROLL','Accompany','Builder','1','Traditional','Johnson-Crawford 1','982','1.6103','Public Sewer','2022','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212033631','1663709417','212033631','2022-09-11T17:07:20.853','35214966','Santiago Panama','NB Elite Realty','Remo Castillo','Realty Associates','29.792498','-95.137547','40','77530','9','300000.00','Option Pending','Lost Lariat','15426','Court','Channelview','2','1','4','2669','Single-Family','Among the largest lot in the entire subdivision. Check our 3D Tour Welcome to your Gorgeous new home, this home shows pride of ownership, as you come in you will find your office, children\'s play area, or studio. As you keep on walking you will find to the left a formal dining room and to the right a large open kitchen with a huge island that can accommodate up to 6 bar stools. Between the garage door and behind the kitchen you will find a large laundry room. A few steps to the left of the kitchen is the half bathroom, for visitors. At the end to the left after the stairs is the Master Bedroom with a huge bath and an extra-large closet. As soon as you get up the stairs on the second floor you will have a game room to the right and to the left an over-size secondary bedroom with a walk-in closet, a second full bathroom, and two more secondary bedrooms. Garage has an A/C Unit.\r\nLots of shopping and dining around, an excellent location, and easy access to BW-8, I-10, 610 Loop, and Hwy-90.','0.1358','2','','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','','','North Channel','Central Gas','1','LT 26 BLK 3 RANCHO VERDE SEC 9','Subdivision Lot','5915','Appraisal District','','405','0','','2','Gas Oven','0','','','Gas Range','','Composition','8 - Channelview','MCMULLAN ELEMENTARY SCHOOL','CHANNELVIEW HIGH SCHOOL','JOHNSON JUNIOR HIGH','Lockbox Right Side,Supra Keybox','Appraisal District','2','Traditional','Rancho Verde Sec 9','5954','2.618','Public Sewer,Public Water,Water District','2018','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','212091618','1663709417','212091618','2022-09-11T17:04:08.650','23622799','Anja Drewes Neidhardt','Anja DrewesProperties, LLC','','','29.583315','-95.637012','40','77479','10','450000.00','Active','Marigold','17419','Drive','Sugar Land','2','1','4','2531','Single-Family','Charming 4 bedroom home zoned to best schools in Sugar Land for sale. This a great opportunity to access a neighborhood that is high in demand. Home has great layout with premier bedroom downstairs, large ensuite bathroom with his and her closet. Formal dining room, family room with fireplace is open to the kitchen. Upstairs 3 bedrooms and game room. Beautiful large backyard with no back neighbors. Minutes away from the First Colony mall and 59 freeway. No flooding. Priced for quick sale to reflect the home need some updates. Sold as is & no repairs.','0.1832','29','','','','','Estate,Sellers Disclosure','1','','1','Sugar Land South','Central Gas','1','LEXINGTON MEADOWS SEC 1, BLOCK 1, LOT 5','Subdivision Lot','7980','Appraisal District','','750','0','','2','Electric Oven','0','','','','','Composition','19 - Fort Bend','COLONY MEADOWS ELEMENTARY SCHOOL','CLEMENTS HIGH SCHOOL','FORT SETTLEMENT MIDDLE SCHOOL','Appointment Required','Appraisal District','2','Traditional','Lexington Meadows','7752','2.1584','Public Sewer,Public Water','1994','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','212219220','1663709417','212219220','2022-09-11T17:31:32.683','79444270','Vicki Oldham','Vicki Oldham Realty','','','30.375891','-95.206521','45','77328','11','799000.00','Active','Big Buck','866','Drive','Cleveland','2','1','3','2601','Single-Family','Live your best life in this lovely home, with a heated swimming pool, hot tub, pool storage building with a half bath, a 2400sf workshop, and an all house generator on 10+-acres! Many custom features throughout include wood flooring, granite counters, stainless steel appliances (double oven and a warming drawer) in the kitchen, an abundance of storage, plus a walk-in pantry. The owner’s suite offers a sumptuous bath/spa with additional features (noted on the amenities sheet), stunning over-sized shower, a double sink vanity, a 9\'x12\' walk-in closet complete with custom shelving. Enjoy the outdoors - minus the bugs - in the 14\'x17\' screened in porch overlooking the pool with the spa and open spillway. The workshop boasts a 260sf air conditioned room, a 4\'x12\' custom workbench, custom drawer storage, covered RV storage and hook ups on one side, a 15\' patio in front and 10\' patio in back, with two roll down doors for easy entry and exit. The property also contains a private water well.','10.79','64','','','Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','Coldspring/South San Jacinto County','Central Electric','1','PEACH CREEK ESTATES #1, BLOCK 2, LOT 16, ACRES 10.79','Cleared,Wooded','470012','Appraisal District','','400','0','','2','Double Oven,Gas Oven','1','Gunite,In Ground','','Gas Cooktop','','Composition','100 - Cleveland','NORTHSIDE ELEMENTARY SCHOOL (CLEVELAND)','CLEVELAND HIGH SCHOOL','CLEVELAND MIDDLE SCHOOL','Accompany,Appointment Required,Controlled Access,Leave Business Card,Lockbox Front,Request Online Appointment,Supra Keybox','Appraisal District','1','Traditional','Peach Creek Estates #1','9383','1.9249','Aerobic,Well','2010','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','212327170','1663709417','212327170','2022-09-11T16:12:49.197','84332101','Greg LaRue','LaRue Team Realty','Tracy Murski','Southern Realty Group','29.797645','-95.576460','41','77043','7','449000.00','Option Pending','Upland Lakes','1827','','Houston','3','1','3','2677','Single-Family','Well-appointed Patio style home in the established, gated community of Upland Lakes. Community amenities include swimming pool, green space, lakes, dog park and walking/jogging paths. Gorgeous travertine floors greet you at entry & lead to private guest bedroom & bath, then leads you to outdoor patio. Upstairs are gleaming hardwood floors that unify the home showing off your island kitchen with granite & stainless, & built-in desk, den with loads of windows, allowing light to pour in. Balcony off of living area for some relaxing. Gorgeous open stairwell with wood treads, leads to 3rd floor with huge master & spa like bath. Additional bed & bath are on this floor. Beautifully maintained with updates including Trane AC system 2019, fresh paint in entry and 3rd floor bedrooms and bathrooms, stucco recently sealed and painted 12/2021. Plantation shutters and window coverings included. Convenient to City Centre. Zoned to Stratford High School.','0.0421','24','InTown Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','','1','Spring Branch','Central Gas','1','LT 5 BLK 4 UPLAND PARK 3RD PAR R/P & R/P AMEND','Other,Patio Lot','1832','Appraisal District','','2000','0','','2','Electric Oven,Single Oven','0','','','Gas Cooktop','','Composition','49 - Spring Branch','SHERWOOD ELEMENTARY SCHOOL','STRATFORD HIGH SCHOOL (SPRING BRANCH)','SPRING FOREST MIDDLE SCHOOL','Appointment Required,Controlled Access,Leave Business Card,Lockbox Front,Supra Keybox','Appraisal','3','Traditional','Upland Park Rep 1 Sec 3 Amd','10010','2.4415','Public Sewer,Public Water','2014','Appraisal District'); --> New record created successfully