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-19T23:56:05.373' ,`MLSNumber` = '14953580' ,`ListAgentFullName` = 'Eduardo Rangel' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.970893' ,`Longitude` = '-95.611362' ,`PhotoCount` = '50' ,`PostalCode` = '77429' ,`RoomCount` = '8' ,`ListPrice` = '670000.00' ,`Status` = 'Active' ,`StreetName` = 'Lismore Lake' ,`StreetNumber` = '11943' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3618' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**IMMACULATE AND PRIVATE SPA AND POOL** * RESORT/EXCLUSIVE GATED COMMUNITY!! *AWESOME WATERFRONT DREAM!! * HEATED POOL WITH SPA!! * Beautiful house with Amazing 2-story entry. * Study with French Doors and wood floors downstairs. * Kitchen with island, walk-in pantry, granite countertops and Stainless Steel appliances. * Wonderful view from the Den to the lake and the AMAZING backyard with Heated Pool and Spa!! * Wonderful balcony with view of the lake and fountains. Direct access to the lake with Boat Slip and Wooded Deck. * Game Room upstairs with 4 Bedrooms and 2 baths upstairs. note: Common Areas upstairs an first floor master bedroom. * NOTE: NEW WOOD FLOORS, AN NEW BATHROOM IN THE MASTER BEDROOM, FRESH NEW PAINT, A FEW UPDATES IN THE ENTIRE HOUSE, COME AN SEE INSIDE.' ,`Acres` = '0.1723' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Gas,Heat Pump,Window Unit' ,`HOAMandatory` = '1' ,`Legal` = 'LT 54 BLK 1 LISMORE LAKE ESTATES' ,`LotDesciption` = 'Subdivision Lot,Waterfront' ,`LotSize` = '7507' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2000' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Built Up,Composition,Slate,Tile' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'HAMILTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,No Supra Keybox,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lismore Lake Estates' ,`TaxAmount` = '10819' ,`TaxRate` = '2.7587' ,`WaterSewer` = 'Public Water,Water District' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669054578' WHERE `Matrix_Unique_ID` = '209645748' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T00:08:33.933' ,`MLSNumber` = '97825518' ,`ListAgentFullName` = 'Susan Kiel' ,`ListOfficeName` = 'Market Realty Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.122182' ,`Longitude` = '-95.805281' ,`PhotoCount` = '24' ,`PostalCode` = '77447' ,`RoomCount` = '9' ,`ListPrice` = '570000.00' ,`Status` = 'Active' ,`StreetName` = 'Pine Ridge' ,`StreetNumber` = '24609' ,`StreetSuffix` = 'Road' ,`City` = 'Hockley' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2400' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'You want peaceful, country living close to the conveniences of the city? Your next chapter starts right here. Down a quiet, dead-end road that backs up to 100 acres of woods, you\'ll find this custom home privately tucked away on 2.1 acres of mixed pines and hardwoods. Light deed restrictions are in place to protect your investment and no HOA! There are two fabulous 600 sq ft covered porches, so pull up a chair and enjoy the most beautiful scenery and abundant wildlife. Inside this gorgeous, energy-efficient, low-maintenance, steel-constructed home there are vaulted ceilings in the kitchen/living/dining area, a wood-burning fireplace, custom cabinets, granite countertops, and spacious bedrooms. Entertain your friends and family with a backyard barbecue, then invite them to camp out using your full 50 amp RV hookup. The perfect location for your new primary residence or weekend getaway and just a short drive to HWY 290 & Grand Parkway...WELCOME HOME! Listing Agent/Owner.' ,`Acres` = '2.1' ,`Area` = '26' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Hockley' ,`HeatSystem` = 'Propane' ,`HOAMandatory` = '0' ,`Legal` = 'S433100 CLEAR CREEK FOREST 1 LOT 2 ACRES 2.1' ,`LotDesciption` = 'Wooded' ,`LotSize` = '91476' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Double Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'EVELYN TURLINGTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'SCHULTZ JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Clear Creek Forest 1' ,`TaxAmount` = '4610' ,`TaxRate` = '2.0243' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669054579' WHERE `Matrix_Unique_ID` = '210570786' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T00:53:10.817' ,`MLSNumber` = '94084535' ,`ListAgentFullName` = 'Ahmad Adam' ,`ListOfficeName` = 'Adam Group Realty, LLC' ,`SellingAgentFullName` = 'Vamshi Kyatham' ,`SellingOfficeName` = 'All City Real Estate, Ltd. Co.' ,`Latitude` = '29.719617' ,`Longitude` = '-95.827936' ,`PhotoCount` = '38' ,`PostalCode` = '77494' ,`RoomCount` = '11' ,`ListPrice` = '639500.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Bell Mountain' ,`StreetNumber` = '4802' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3745' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This Stunning home features the ultimate luxury privacy. No rear neighbors, a beautiful elevation with brick and stone, a gorgeous entryway with a tall ceiling, and a secluded and spacious master with a high ceiling and bay window that opens to a beautiful backyard; retreat highlights this Taylor Morrison home. This sought-after floor plan features soaring ceilings, a large media room with built-in speakers, a screen, a projector, and an elegant study with a custom build in bookshelf and desk millwork. Spacious Gameroom upstairs with lots of windows. A beautiful covered patio and a second-story balcony overlook Georges\'s backyard, green space, and water views. The kitchen features a butler\'s pantry, custom cabinets, under-counter lighting, stainless steel appliances, and exotic granite. Three-car garage. New water heaters, New Carpet throughout the upstairs, and fresh paint. Water softener, reverse osmosis with cold and hot water, Never flooded. Great Katy schools, low 2.7% tax rate.' ,`Acres` = '0.2054' ,`Area` = '36' ,`BuilderName` = 'Taylor Morrison' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'CINCO RANCH SOUTHWEST SEC 27, BLOCK 1, LOT 9' ,`LotDesciption` = 'Greenbelt,Subdivision Lot,Water View' ,`LotSize` = '8946' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'WILSON ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'TOMPKINS HIGH SCHOOL' ,`SchoolMiddle` = 'TAYS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cinco Ranch Southwest Sec 27' ,`TaxAmount` = '11509' ,`TaxRate` = '2.7045' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2010' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669054579' WHERE `Matrix_Unique_ID` = '211200036' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T00:05:45.317' ,`MLSNumber` = '33402850' ,`ListAgentFullName` = 'Albric Rosa' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.969276' ,`Longitude` = '-95.230942' ,`PhotoCount` = '26' ,`PostalCode` = '77396' ,`RoomCount` = '4' ,`ListPrice` = '259000.00' ,`Status` = 'Active' ,`StreetName` = 'Cormorant' ,`StreetNumber` = '17327' ,`StreetSuffix` = 'Court' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2018' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to 17327 Cormorant Court! You\'ll love all the incredible features this home has to offer, including a gorgeous primary bedroom and bathroom, spacious high ceiling living room with cozy fireplace, upstairs game/play room, good sized backyard, and so much more! Recent updates include Custom Window Frames in the Living Room, New Toilets, Brand New Carpet, New Paint, New Flooring featuring Luxurious Vinyl Plank, New Bathroom Vanity on the Upstairs Bathroom, & All Bathrooms Include Brand New Faucets Along with New Mirrors. You will also find Baseboards & Quarter Round Moldings all around the home. The Seller to be adding New Fence in the South & Eastern direction of the backyard. The Harris County Sheriff\'s Office Academy is located just .5 mile away, just another reason to feel more safe at home! Deerbrook Mall just 11 minutes away. Only 1 other family has lived here, take advantage of this opportunity, schedule your private tour today!' ,`Acres` = '0.1385' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Humble Area East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 25 BLK 4 ATASCOCITA TRACE SEC 1' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '6032' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '366' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Wood Shingle' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'RIVER PINES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HUMBLE HIGH SCHOOL' ,`SchoolMiddle` = 'HUMBLE MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Atascocita Trace Sec 1' ,`TaxAmount` = '5452' ,`TaxRate` = '2.933' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669054579' WHERE `Matrix_Unique_ID` = '211897842' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T00:20:08.630' ,`MLSNumber` = '47824122' ,`ListAgentFullName` = 'Gary Bisha' ,`ListOfficeName` = 'My Castle Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.059670' ,`Longitude` = '-95.573932' ,`PhotoCount` = '30' ,`PostalCode` = '77422' ,`RoomCount` = '7' ,`ListPrice` = '275000.00' ,`Status` = 'Active' ,`StreetName` = 'Bernard' ,`StreetNumber` = '121' ,`StreetSuffix` = 'Street' ,`City` = 'Brazoria' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '1950' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home! Home is nestled in an established neighborhood located at 121 Bernard St located in Brazoria Oaks subdivision in the historic City of Brazoria in Brazoria County Texas. This beautiful 5 bedroom, 2 full bathrooms, 2 car garage with 2 storage sheds (one 90 sqft and one 99 sqft) is sitting on 2 lots (32 & 33) for a total of 16,406 sqft of Texas real-estate. If you want to live in and older establishment, quite neighborhood then this is the place. This home comes partially furnished so you could move in right away. This lovely home is about half a mile from Buccee\'s, Texas most liked gas station store. Also it is located very close to a baseball field and elementary school. This wonderful home truly is one of those Texas treasures that is hard to find and won\'t last long. Priced to sell fast as is where is; all offers will be considered. House went unoccupied for about the past year. Utilities were recently turned back on to list it for sale.' ,`Acres` = '0.3766' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'West of the Brazos' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'BRAZORIA OAKS A0020 S F AUSTIN (BRAZORIA) BLK 3 LOT 32 & 33' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '16406' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '10 - Columbia-Brazoria' ,`SchoolElementary` = '' ,`SchoolHigh` = 'COLUMBIA HIGH SCHOOL' ,`SchoolMiddle` = 'WEST BRAZOS JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Brazoria Oaks' ,`TaxAmount` = '3823' ,`TaxRate` = '2.3372' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669054579' WHERE `Matrix_Unique_ID` = '212428762' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-19T23:48:01.850' ,`MLSNumber` = '29127553' ,`ListAgentFullName` = 'Lucia Moore' ,`ListOfficeName` = 'Kino Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.759653' ,`Longitude` = '-95.769907' ,`PhotoCount` = '36' ,`PostalCode` = '77494' ,`RoomCount` = '9' ,`ListPrice` = '450000.00' ,`Status` = 'Active' ,`StreetName` = 'Sawleaf' ,`StreetNumber` = '23202' ,`StreetSuffix` = 'Circle' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2432' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Remarkable remodeled home in Cinco Ranch awaits You! This fantastic one-story corner home features an inviting open floor plan with 10\' ceilings. Enjoy a nice view to your own swimming pool from the family room, a gas fireplace & two large bookcases complete this room. The formal dining room is adorned with a large window. The family\'s check will be thrilled in this spacious kitchen, has abundance of counter space, 42\" cabinets, double ovens, gas cooktop, walk-in pantry, & a nice view to the pool. The master bedroom has direct access to the pool from the new French doors, it has a huge closet and a newly remodeled bathroom. It also comes with three additional spacious bedrooms and a secondary bathroom. \r\nPer the owners the following is NEW NEW NEW!! Roof, Water Heater, Interior Paint Including Cabinets, Carpet, Refinished Wood Flooring, Light Fixtures & Ceiling Fans, Hardware, French doors, Master Bath floor, Shower Wall Tile, Countertop, Mirror, Mulch. Come see it and Fall in Love!!' ,`Acres` = '0.1871' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 5 CINCO RANCH MEADOW PLACE SEC 3' ,`LotDesciption` = 'Corner,Cul-De-Sac' ,`LotSize` = '8150' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1115' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'FIELDER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CINCO RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'BECK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch,Split Level,Traditional' ,`Subdivision` = 'Cinco Ranch Meadow Place Sec 0' ,`TaxAmount` = '6842' ,`TaxRate` = '2.6083' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1997' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669054580' WHERE `Matrix_Unique_ID` = '212444047' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-19T23:18:24.920' ,`MLSNumber` = '21160067' ,`ListAgentFullName` = 'Heather Niemeyer' ,`ListOfficeName` = 'Camelot Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.798598' ,`Longitude` = '-95.403410' ,`PhotoCount` = '37' ,`PostalCode` = '77008' ,`RoomCount` = '13' ,`ListPrice` = '1250000.00' ,`Status` = 'Active' ,`StreetName` = 'Ashland' ,`StreetNumber` = '1512' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2487' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Offering unparalleled comfort, charm, & convenience, this NEW & CUSTOM HEIGHTS home is sure to exceed all of your expectations. Close to Shepherd & 610 for easy commute, local businesses, shops, & restaurants! Zoned to exemplary Love Elementary, Hamilton Middle, & Heights High School! The bright & inviting kitchen features quartz counters, 6-burner gas range w/ double oven, & moveable ladder for hard-to-reach cabinets. The living room is warm & cozy perfect for snuggling up by the fireplace. Glass & steel French doors invite you into the home OFFICE, featuring a lengthy built-in desk, & art display sconces. A perfect place to unwind, the 1st floor owners’ suite is generous in size, offering two walk-in closets, floating shelves, & soaking tub. The 2nd floor is enveloped in warm light consisting of two bedrooms, a full bathroom, & GAME ROOM. Across the turfed out, pool-sized backyard, is the self-sufficient 1bed/ 1bath GUEST APARTMENT above the garage, with a range to be installed soon!' ,`Acres` = '0.1' ,`Area` = '9' ,`BuilderName` = 'T. Hobson Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'LT 24 BLK 145 HOUSTON HEIGHTS' ,`LotDesciption` = 'Other,Patio Lot' ,`LotSize` = '4356' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition,Wood Shingle' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LOVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Accompany,Appointment Required,Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Craftsman,Other Style,Traditional' ,`Subdivision` = 'Houston Heights' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669054580' WHERE `Matrix_Unique_ID` = '213282052' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T00:20:08.473' ,`MLSNumber` = '29810301' ,`ListAgentFullName` = 'Tonya Brown' ,`ListOfficeName` = 'Compass RE Texas, LLCKaty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.723422' ,`Longitude` = '-95.939795' ,`PhotoCount` = '50' ,`PostalCode` = '77423' ,`RoomCount` = '9' ,`ListPrice` = '395000.00' ,`Status` = 'Active' ,`StreetName` = 'Ruthie Dean' ,`StreetNumber` = '32963' ,`StreetSuffix` = 'Drive' ,`City` = 'Brookshire' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '2974' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to Vanbrooke in the Fulshear area! This barely lived in home is waiting for you to make it your own. Featuring brick on 4 sides, this customized home features 5 bedrooms + study, 4.5 bathrooms, 2.5 car garage on a premium lot and no rear neighbors. This gorgeous home features 2 primary suites -- 1 upstairs and 1 downstairs! This is the only home constructed with this exact configuration in the community. New builds in the neighborhood are priced significantly higher for similar upgrades, square footage and lot size. There are too many features to name, but some include LVP and ceramic tile flooring, 2\" blinds throughout, Dual zoned 16 SEER HVAC system, tankless water heater, island kitchen with walk-in pantry, covered patio, full sprinkler system, epoxy coated garage floor, a total of 3 en suites, family room with lots of natural lighting and an open concept to the kitchen, plus a game room upstairs. Verify all measurements and community-related information.' ,`Acres` = '0.1906' ,`Area` = '30' ,`BuilderName` = 'HistoryMaker' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Fulshear/South Brookshire/Simonton' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'VANBROOKE SEC 2, BLOCK 1, LOT 115' ,`LotDesciption` = 'Cleared,Greenbelt,Subdivision Lot' ,`LotSize` = '8301' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'HUGGINS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Vanbrooke Sec 2' ,`TaxAmount` = '4775' ,`TaxRate` = '3.2948' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669054580' WHERE `Matrix_Unique_ID` = '213564129' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T00:03:16.827' ,`MLSNumber` = '37334050' ,`ListAgentFullName` = 'Tiffany Romero' ,`ListOfficeName` = 'Fathom Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.811641' ,`Longitude` = '-94.838069' ,`PhotoCount` = '26' ,`PostalCode` = '77523' ,`RoomCount` = '7' ,`ListPrice` = '254500.00' ,`Status` = 'Active' ,`StreetName` = 'Rainbow' ,`StreetNumber` = '5514' ,`StreetSuffix` = 'Road' ,`City` = 'Cove' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1335' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great Location! This beautiful home has 3 bedrooms, 2 bathrooms and family room. The kitchen overlooks family room has granite countertops gorgeous wood cabinets and a breakfast bar. The refrigerator and island can stay with the home Primary bedroom includes a large window overlooking the back yard, as well as a spacious bathroom and walk-in closet. A covered front entry, front yard landscaping and fenced backyard add to the curb appeal of this adorable, move-in ready home. The backyard has a beautiful custom made palapa with lights and fan. Schedule a tour today.' ,`Acres` = '0.131' ,`Area` = '53' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Chambers County West' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 10 BK 3 JOSEPHS COVE SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5706' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '380' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '6 - Barbers Hill' ,`SchoolElementary` = 'BARBERS HILL SOUTH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BARBERS HILL HIGH SCHOOL' ,`SchoolMiddle` = 'BARBERS HILL SOUTH MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Josephs Cove Sec 3' ,`TaxAmount` = '3738' ,`TaxRate` = '1.7058' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669054580' WHERE `Matrix_Unique_ID` = '213576616' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T00:33:33.923' ,`MLSNumber` = '54383381' ,`ListAgentFullName` = 'Leslie McMurrey' ,`ListOfficeName` = 'Red Door Realty & Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.008820' ,`Longitude` = '-95.169679' ,`PhotoCount` = '37' ,`PostalCode` = '77346' ,`RoomCount` = '9' ,`ListPrice` = '319900.00' ,`Status` = 'Active' ,`StreetName` = 'January' ,`StreetNumber` = '19815' ,`StreetSuffix` = 'Drive' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2718' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming home in the desirable Pinehurst of Atascocita. Spacious main living area with gas fireplace and loads of windows letting in all the natural light. Large kitchen with walk-in pantry, breakfast area, and spacious laundry room. Office/formal dining and primary bedroom complete the first floor. Upstairs includes 3 bedrooms, full bath and storage galore! Large gameroom overlooking 2nd floor deck and backyard. NO BACK NEIGHBORS!!' ,`Acres` = '0.2204' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Atascocita North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 31 BLK 23 PINEHURST OF ATASCOCITA SEC 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'PINEFOREST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ATASCOCITA HIGH SCHOOL' ,`SchoolMiddle` = 'ATASCOCITA MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Pinehurst Atascocita Sec 06' ,`TaxAmount` = '5710' ,`TaxRate` = '2.453' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669054581' WHERE `Matrix_Unique_ID` = '213656558' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T00:04:43.357' ,`MLSNumber` = '97794127' ,`ListAgentFullName` = 'Tiffany Romero' ,`ListOfficeName` = 'Fathom Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.412646' ,`Longitude` = '-95.567391' ,`PhotoCount` = '36' ,`PostalCode` = '77318' ,`RoomCount` = '6' ,`ListPrice` = '550000.00' ,`Status` = 'Active' ,`StreetName` = 'Fm 830' ,`StreetNumber` = '13790' ,`StreetSuffix` = 'Road' ,`City` = 'Willis' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2886' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'GREAT opportunity to live within walking distance of Lake Conroe. This home is an amazing 3 bedroom with so much character. It is on 2 lots almost 3/4 of an acre total. If you love to cook and entertain than this is your home!! The gorgeous kitchen and family room are located upstairs with 3 balconies to have views from the second floor. Family room and Kitchen both have cedar beams which makes it such a rustic living area with Texas feel. Backyard has a separate fenced in area great for a pet. This property would also make a fun weekend lake house or a great investment property or airbnb. Owner has Access to boat launch, clubhouse and community park. There are two entrances to the property, off of FM830 leads to front of home and off of Woodland Manor Dr in Lakeview Manor you can enter from the back of property. Downstairs AC 2020, New water heater 2022' ,`Acres` = '0.2353' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LAKEVIEW MANOR, BLOCK 1, LOT 8 and 16' ,`LotDesciption` = 'Cleared,Subdivision Lot,Water View' ,`LotSize` = '30928' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '212' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'W. LLOYD MEADOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERT P. BRABHAM MIDDLE SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Lockbox Front,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Ranch' ,`Subdivision` = 'Lakeview Manor' ,`TaxAmount` = '6814' ,`TaxRate` = '2.1633' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1976' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669054581' WHERE `Matrix_Unique_ID` = '213879452' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T00:53:43.747' ,`MLSNumber` = '94835192' ,`ListAgentFullName` = 'Kimberlee Batres' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = 'Chandal Franger' ,`SellingOfficeName` = 'RE/MAX ONE - Premier' ,`Latitude` = '29.793937' ,`Longitude` = '-94.847891' ,`PhotoCount` = '20' ,`PostalCode` = '77523' ,`RoomCount` = '8' ,`ListPrice` = '649900.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Pineloch Bayou' ,`StreetNumber` = '4619' ,`StreetSuffix` = 'Drive' ,`City` = 'Baytown' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2982' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful home in Winfree Bayou Estate on over 1 acre. This home has an open concept throughout the kitchen, breakfast and living room. 4 bedrooms, 3 full baths (2 Walk in showers). Kitchen features beautiful granite countertops, plenty of cabinets for storage and stainless steel appliances. Stone gas fireplace in the living room. Back porch is covered and has a gas line installed for an outdoor kitchen. Beautiful fire pit and a gorgeous pool that has WIFI controls. This home has lots of upgrades that include: Brick all the way around the house, 8 ft doors including garage, extra wide driveway, Custom shutters throughout the house, WHOLE HOME Generator, Privacy fence with electric gate, Water proof floors throughout, double front door, Frameless shower in guest bathroom, Rock wall on bar and firesplace to the ceiling, tankless water heater and a Swimming pool with waterfall & WIFI Controls. Schedule your tour today this home is a MUST SEE!' ,`Acres` = '1.121' ,`Area` = '53' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Chambers County West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 7 BK 1 WINFREE BAYOU EST 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '48831' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '475' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '6 - Barbers Hill' ,`SchoolElementary` = 'BARBERS HILL SOUTH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BARBERS HILL HIGH SCHOOL' ,`SchoolMiddle` = 'BARBERS HILL SOUTH MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Winfree Bayou Estates Sec 1' ,`TaxAmount` = '7954' ,`TaxRate` = '1.7058' ,`WaterSewer` = 'Aerobic,Public Water' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669054581' WHERE `Matrix_Unique_ID` = '214003596' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T00:20:08.317' ,`MLSNumber` = '25816324' ,`ListAgentFullName` = 'Nguyen Le' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.870181' ,`Longitude` = '-95.650992' ,`PhotoCount` = '27' ,`PostalCode` = '77084' ,`RoomCount` = '7' ,`ListPrice` = '319500.00' ,`Status` = 'Active' ,`StreetName` = 'Kimball Mill' ,`StreetNumber` = '6310' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2031' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Low tax, low HOA, good school! Feel and look like new built! 1-bed room downstairs with full bath; open floorplan connecting the breakfast, kitchen, and living room all together; a huge backyard with cover patio for your outdoor lifestyle! Upstairs you will find a game room, master bedroom, 2 full baths, and 2 other rooms that can be used as a home office! You will also love the convenience of this location, just a minute away from the shopping, and dining center! Schedule your showing today.' ,`Acres` = '0.095' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 14 BLK 5 KINGFIELD SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4140' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '575' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'LOWERY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LANGHAM CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'KAHLA MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Pine Grv Sec 1' ,`TaxAmount` = '868' ,`TaxRate` = '2.861' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669054581' WHERE `Matrix_Unique_ID` = '214105410' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-19T23:54:52.510' ,`MLSNumber` = '55281027' ,`ListAgentFullName` = 'Beth Ferester' ,`ListOfficeName` = 'CORCORAN FERESTER REALTY' ,`SellingAgentFullName` = 'Cecelia Smith' ,`SellingOfficeName` = 'eXp Realty, LLC' ,`Latitude` = '30.159062' ,`Longitude` = '-95.485417' ,`PhotoCount` = '40' ,`PostalCode` = '77381' ,`RoomCount` = '12' ,`ListPrice` = '2100000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Pleasure Cove' ,`StreetNumber` = '35' ,`StreetSuffix` = 'Drive' ,`City` = 'The Woodlands' ,`BathsFull` = '3' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '4747' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This is a million dollar view!!! Truly one of the best views in The Woodlands with so many windows internalizing the views from almost every room. The inside is just as beautiful with a major remodel done after seller’s purchased. White oak wide plank floors, huge island kitchen with upgraded appliances, large “gathering” room off kitchen and open to family room. Two boat docks, lush pool and spa and dining area with grill outside. Voila - this could be yours!' ,`Acres` = '0.2743' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '3' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'WDLNDS VIL PANTHER CK 24, BLOCK 2, LOT 11' ,`LotDesciption` = 'Water View,Waterfront,Wooded' ,`LotSize` = '11949' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'SALLY RIDE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'THE WOODLANDS COLLEGE PARK HIGH SCHOOL' ,`SchoolMiddle` = 'KNOX JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Wdlnds Village Panther Ck 24' ,`TaxAmount` = '27017' ,`TaxRate` = '2.0501' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1992' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669054581' WHERE `Matrix_Unique_ID` = '214291563' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T00:20:08.067' ,`MLSNumber` = '39996603' ,`ListAgentFullName` = 'Stephanie Palmer' ,`ListOfficeName` = 'Leopold & Strahan Realty Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.483989' ,`Longitude` = '-95.090765' ,`PhotoCount` = '25' ,`PostalCode` = '77573' ,`RoomCount` = '8' ,`ListPrice` = '484500.00' ,`Status` = 'Active' ,`StreetName` = 'Torrance' ,`StreetNumber` = '1540' ,`StreetSuffix` = 'Drive' ,`City` = 'League City' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3929' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home. This beautiful home is a must see. Located in the highly desired neighborhood of Victory Lakes, this 4 bedroom, 3 1/2 bath , 2 story home is just waiting for you. This home features a beautiful brick and stone exterior. Once inside you will find a beautiful palatial entry. Soaring ceiling in the family room with open concept to the beautiful kitchen and a large island, perfect for entertaining family and friends or hosting holiday get togethers. You will find privacy in the large primary bedroom and ensuite bathroom with double vanities, soaking tub, separate shower and large walk-in closet. Upstairs is perfect for game night or a great place to hang out with a huge game room and 3 large bedrooms and 2 bathrooms. Once out back you will find a large fenced backyard and no back neighbors. Come see this beautiful home today!!' ,`Acres` = '0.1893' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'VICTORY LAKES SEC 5 (2007) ABST 3, BLOCK 1, LOT 42, ACRES 0.' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8247' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '715' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'RALPH PARR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'VICTORYLAKES INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Victory Lakes Sec 5 2007' ,`TaxAmount` = '10557' ,`TaxRate` = '2.0697' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2009' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669054582' WHERE `Matrix_Unique_ID` = '214403642' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T00:39:07.317' ,`MLSNumber` = '76111672' ,`ListAgentFullName` = 'Beverly Bradley' ,`ListOfficeName` = 'Weekley Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.228639' ,`Longitude` = '-95.775969' ,`PhotoCount` = '42' ,`PostalCode` = '77354' ,`RoomCount` = '7' ,`ListPrice` = '442294.00' ,`Status` = 'Active' ,`StreetName` = 'Opal Heights' ,`StreetNumber` = '1408' ,`StreetSuffix` = 'Court' ,`City` = 'Magnolia' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2463' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Explore the remarkable lifestyle possibilities of the spacious and sophisticated Conway new home plan - with a 4-car garage. Growing residents and out-of-town visitors will love the sizable junior bedrooms and the private guest suite. The study presents a sunlit opportunity for additional gathering space or the personally-designed home office you’ve been dreaming of. Culinary masterpieces and quick, easy meals are equally suited to the streamlined kitchen nestled at the heart of this home. Your open floor plan provides a beautiful expanse for you to fill with decorative flair and lifelong memories. Your Owner’s Retreat includes a sleek en suite bathroom and a walk-in closet to make it easy to rest and refresh in luxury. Enjoy refreshments and good company in the breezy leisure of your covered patio. Bonus storage, top-quality construction, and our EnergySaver™ features make it easy to love each day in this wonderful new home plan.' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'David Weekley Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 25 Block 1' ,`LotDesciption` = 'Cul-De-Sac,Greenbelt,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'MAGNOLIA ELEMENTARY SCHOOL (MAGNOLIA)' ,`SchoolHigh` = 'MAGNOLIA WEST HIGH SCHOOL' ,`SchoolMiddle` = 'MAGNOLIA JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Escondido' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669054582' WHERE `Matrix_Unique_ID` = '214488765' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T00:07:00.837' ,`MLSNumber` = '97378828' ,`ListAgentFullName` = 'Aaron Jistel' ,`ListOfficeName` = 'Listing Spark' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.558802' ,`Longitude` = '-95.728110' ,`PhotoCount` = '26' ,`PostalCode` = '77469' ,`RoomCount` = '8' ,`ListPrice` = '420000.00' ,`Status` = 'Active' ,`StreetName` = 'Anna Creek' ,`StreetNumber` = '1715' ,`StreetSuffix` = 'Drive' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3046' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fantastic location for this fabulous home! 2 minutes into the 59 highway, 2019 built, Open concept kitchen and expansive island, large main room with high ceilings all around! come and visit you\'ll love it! Spacious & open floor plan GORGEOUS home; 4 bedrooms; 2.5 baths; upstairs game room. The kitchen features an oversized island, pull-out cabinet drawers with new hardware & large walk-in pantry. All stainless appliances stay except the fridge, including the gas dryer. Great location near the 59 ( 2 minutes only, spacious, upgraded kitchen with great storage space, upgraded the main bedroom with high ceiling, covered patio, sprinkler system in place, water softener outdoor ring door bell and ring camera.' ,`Acres` = '0.1377' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'WILLIAMS RANCH SEC 4, BLOCK 1, LOT 4' ,`LotDesciption` = 'Other' ,`LotSize` = '6000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition,Other' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'HUTCHISON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR CONSOLIDATED HIGH SCHOOL' ,`SchoolMiddle` = 'WESSENDORF/LAMAR JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Williams Ranch Sec 4' ,`TaxAmount` = '8820' ,`TaxRate` = '3.1798' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1669054582' WHERE `Matrix_Unique_ID` = '214677494' --> 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','214946868','1669054582','214946868','2022-11-19T23:48:20.507','37889049','Simona Toliver','RE/MAX Prestige','','','30.001942','-95.634484','28','77429','5','288000.00','Active','Gray Bear','14011','Circle','Cypress','2','0','3','1714','Single-Family','Beautiful one-story home located on Cul De Sac street. Open floor plan, large den open to kitchen and formal dining. Covered patio. Excellent Cy Fair Schools! Recent roof, AC, Water Heater, Paint and Carpet.','0.1439','10','','','','','Sellers Disclosure','1','Gas Connections','1','Cypress North','Central Gas','1','LT 28 BLK 23 FAIRWOOD SEC 6 2ND AMEND','Cul-De-Sac','6268','Appraisal District','','424','0','','2','Gas Oven','0','','','Gas Cooktop','','Composition','13 - Cypress-Fairbanks','BLACK ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)','CY-FAIR HIGH SCHOOL','HAMILTON MIDDLE SCHOOL (CYPRESS-FAIRBANKS)','Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox','Appraisal District','1','Traditional','Fairwood Sec 06 02 Amd','7490','2.8937','Water District','1997','Appraisal District'); --> New record created successfully