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-22T21:23:58.627' ,`MLSNumber` = '70619938' ,`ListAgentFullName` = 'Courtney Johnson Rose' ,`ListOfficeName` = 'George E. Johnson Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.793219' ,`Longitude` = '-95.820890' ,`PhotoCount` = '50' ,`PostalCode` = '77493' ,`RoomCount` = '7' ,`ListPrice` = '999999.00' ,`Status` = 'Active' ,`StreetName` = 'Avenue A' ,`StreetNumber` = '1506' ,`StreetSuffix` = '' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2071' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Excellent location in the heart of Old Towne Katy! The only 1.3 acre lot with frontage on both Avenue A to the west and East Avenue on the east! See attached survey and map image. A beautiful update and renovation has been completed! See attached Amenities PDF. Property interior was renovated in 2020-2021 with commercial use in mind. Kitchen and baths updated, new windows throughout. Roof has been replaced.' ,`Acres` = '1.3636' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 22 & N 1/2 OF LT 23 KATY OUTLOTS' ,`LotDesciption` = 'Cleared' ,`LotSize` = '59400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'KATY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'KATY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Katy Outlots' ,`TaxAmount` = '14248' ,`TaxRate` = '2.3852' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641415' WHERE `Matrix_Unique_ID` = '203730250' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-22T22:01:52.417' ,`MLSNumber` = '63933204' ,`ListAgentFullName` = 'Mark Welch' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.218646' ,`Longitude` = '-95.300182' ,`PhotoCount` = '39' ,`PostalCode` = '77302' ,`RoomCount` = '4' ,`ListPrice` = '600000.00' ,`Status` = 'Active' ,`StreetName` = 'Deer Glen West' ,`StreetNumber` = '17775' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2243' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '6 Acre secluded wooded estate. 3 lots consisting of 2 acres. Bring your business, bring your toys, bring your family and still have room. Horses can come too. Low HOA basically covers street lights. Home has never flooded. Home is a 3-4 bedroom home 3.5 baths and a 1500 Sq ft metal workshop on a slab. Workshop has electricity and air compressor and storage loft. RV space has hook ups. Raised garden beds waiting for a spring garden. Home office with half bath in the home that could be converted to a parent suite. Detached 2 car garage and extra storage and carport covering in front of garage. Back covered patio great for the outdoor chef. 2 driveways to the property. Home awaits buyers personal touch. Property is minutes to 242 centrally located between 45 and 59. Ice machine excluded. \r\nRoom measurements are approximate please have buyer to verify. \r\nOwner has surveillance on the property.' ,`Acres` = '6' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Heat Pump' ,`HOAMandatory` = '1' ,`Legal` = 'DEER GLEN WEST, BLOCK 6, LOT 13,14,15' ,`LotDesciption` = 'Wooded' ,`LotSize` = '261360' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '45' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'HOPE ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CANEY CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MOORHEAD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Deer Glen West' ,`TaxAmount` = '3300' ,`TaxRate` = '1.9103' ,`WaterSewer` = 'Septic Tank,Water District' ,`YearBuilt` = '1975' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641415' WHERE `Matrix_Unique_ID` = '204918153' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-22T21:21:53.893' ,`MLSNumber` = '97254586' ,`ListAgentFullName` = 'Dante Cruz' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.097021' ,`Longitude` = '-94.994040' ,`PhotoCount` = '50' ,`PostalCode` = '77535' ,`RoomCount` = '11' ,`ListPrice` = '1200000.00' ,`Status` = 'Active' ,`StreetName` = 'Fm 686' ,`StreetNumber` = '5128' ,`StreetSuffix` = '' ,`City` = 'Dayton' ,`BathsFull` = '7' ,`BathsHalf` = '0' ,`BedsTotal` = '7' ,`SqFtTotal` = '9000' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous Secluded 10 Acre Home located in Dayton, TX A must see!! 7 bedrooms 7 bathrooms with unique details from Granite countertops and custom cabinetry feature exceptional quality in every room to the amazing porcelain Italiano flooring throughout the home. Stunning gourmet kitchen with top of the line Thor kitchen appliances, each room is a master bedroom with a unique design with out of this world ceiling fans and custom light fixtures, an huge walk-in closets. the outdoor includes 2 front and back balcony, outdoor relaxation with beautiful landscaping.' ,`Acres` = '10' ,`Area` = '52' ,`BuilderName` = 'Jesus Villalpando' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Dayton' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = '000495 R PRUITT-120, TRACT 6, ACRES 10' ,`LotDesciption` = 'Cleared' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '74 - Dayton' ,`SchoolElementary` = 'STEPHEN F. AUSTIN ELEMENTARY SCHOOL (DAYTON)' ,`SchoolHigh` = 'DAYTON HIGH SCHOOL' ,`SchoolMiddle` = 'WOODROW WILSON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'R Pruitt-120' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669641416' WHERE `Matrix_Unique_ID` = '205704290' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-22T22:16:26.460' ,`MLSNumber` = '76210330' ,`ListAgentFullName` = 'Ginger Gayden' ,`ListOfficeName` = 'Adams Homes Realty, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.835165' ,`Longitude` = '-95.852357' ,`PhotoCount` = '27' ,`PostalCode` = '77493' ,`RoomCount` = '10' ,`ListPrice` = '307400.00' ,`Status` = 'Active' ,`StreetName` = 'Camino Bay' ,`StreetNumber` = '416' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1503' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful New One Story Ranch Home on an amazing Large Cul-de-sac Lot. Built by Adams Homes! Beautiful Brick & Stone Elevation! Grand Entry W/High Ceilings, Gorgeous Large Tile Floors, 5 1/4\" Baseboards throughout for that Custom Look! Huge Family Area with wall of Windows that Flows into the Casual Dining & The Dramatic Gourmet Kitchen with Stunning Granite Counters, Breakfast Bar that wraps around the Kitchen, Stainless Steel Appliances, Tall Shaker Cabinets, Subway Tile Backsplash, Deep Double Undermount Stainless Steel Sink, Swan Pull Out Kitchen Faucet, Walk in Pantry & More! The Private Owner\'s Suite has High Coffered Ceilings, Ceiling Fan, Lush Bathroom W/Huge Gorgeous Shaker Cabinet Vanity, His & Her Sink, Deep Soaker Tub, Large Shower & Massive Walk In Closet! 2 Guest Bedrooms & Full Bathroom! Blinds included and also Grass to enjoy in your Backyard! Covered Patio! Energy Saving Home! Outstanding Schools for all ages & Amazing Resort Amenities!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Adams Homes, Inc.' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SUNTERRA SECTION 4, LOT 5, BLOCK 2' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'BRYANT ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Sunterra' ,`TaxAmount` = '' ,`TaxRate` = '3.67' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669641416' WHERE `Matrix_Unique_ID` = '207777266' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-22T21:30:32.563' ,`MLSNumber` = '89676206' ,`ListAgentFullName` = 'Lisa Pride' ,`ListOfficeName` = 'Above and Beyond Realty' ,`SellingAgentFullName` = 'Rachel Semien' ,`SellingOfficeName` = 'Keller Williams HoustonCentral' ,`Latitude` = '29.946477' ,`Longitude` = '-95.216412' ,`PhotoCount` = '33' ,`PostalCode` = '77396' ,`RoomCount` = '5' ,`ListPrice` = '299500.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Fairwood Creek' ,`StreetNumber` = '11407' ,`StreetSuffix` = 'Court' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1929' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home. This beautifully apportioned home on an oversized lot is waiting for you. Home includes several upgrades including wine fridge and storage racks, faux beams in dining room, Stone work on breakfast bar, and custom closets in owner\'s retreat. The large and spacious kitchen is open to dining and living rooms and combines to form a great space for entertaining and family time. Placement of secondary bedrooms at the front of home provide privacy from main living area.' ,`Acres` = '0.2629' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Summerwood/Lakeshore' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 26 BLK 1 BALMORAL PARK LAKES EAST SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11454' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1280' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'RIDGE CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = '' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Balmoral Park Lakes East' ,`TaxAmount` = '7576' ,`TaxRate` = '2.9873' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641416' WHERE `Matrix_Unique_ID` = '209305343' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-22T22:04:08.383' ,`MLSNumber` = '16985804' ,`ListAgentFullName` = 'Holly Petrie' ,`ListOfficeName` = 'RE/MAX Pro' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.194010' ,`Longitude` = '-93.948494' ,`PhotoCount` = '25' ,`PostalCode` = '77662' ,`RoomCount` = '6' ,`ListPrice` = '159900.00' ,`Status` = 'Active' ,`StreetName` = 'Sandridge Dr' ,`StreetNumber` = '12162' ,`StreetSuffix` = '' ,`City` = 'Vidor' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2128' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Want out of city limits? With acreage? Privacy? 4 bedrooms?? Well honey stop the car here!!!!!! This home is 6 years young and is situated on 3.42 acres with an open floor plan, split bedrooms, living room AND den and lots of great upgrades throughout like entertainment walls and new carpeting. Kitchen with all appliances including refrigerator, breakfast bar and pantry. Barn doors lead to more storage and an interior laundry room. New front and back decks for entrance to home, and storage building included. This one still smells NEW!! Call your favorite Realtor today for your tour!' ,`Acres` = '3.42' ,`Area` = '50' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'NORTH GRIGSBY SUBDIVISION, Lot 9,SERIAL # CS2020201TNA, TITL' ,`LotDesciption` = 'Other' ,`LotSize` = '' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '683 - Little Cypress-Mauriceville Consolidated' ,`SchoolElementary` = 'MAURICEVILLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LITTLE CYPRESS-MAURICEVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'MAURICEVILLE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'TBD' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641416' WHERE `Matrix_Unique_ID` = '211296897' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-22T22:52:01.820' ,`MLSNumber` = '13987435' ,`ListAgentFullName` = 'Travis Smith' ,`ListOfficeName` = 'Randall Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.873487' ,`Longitude` = '-95.717191' ,`PhotoCount` = '29' ,`PostalCode` = '77449' ,`RoomCount` = '8' ,`ListPrice` = '320000.00' ,`Status` = 'Active' ,`StreetName` = 'Arbor Creek' ,`StreetNumber` = '20015' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2497' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful and spacious 3 bedroom 2.5 bath home in the Estates of Highland Creek. Former model home offers soaring ceilings from the foyer through the family room. Large kitchen open to family room with new SS gas range and microwave. Primary bedroom offers vaulted ceilings, dual vanities, tub and walk-in shower. Large game room (20x20) on the 2nd floor over looks the family room. Nice backyard with covered patio off the master suite. August 2022 updates include new paint, new carpet, new quartz countertops in the kitchen. New roof installed (Oct 2022)' ,`Acres` = '0.1567' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 3 BLK 1 ESTATES OF HIGHLAND CREEK SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6825' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '520' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'DURYEA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS SPRINGS HIGH SCHOOL' ,`SchoolMiddle` = 'HOPPER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Estates Highland Creek 03' ,`TaxAmount` = '5597' ,`TaxRate` = '2.69' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641417' WHERE `Matrix_Unique_ID` = '211304237' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-22T22:25:18.810' ,`MLSNumber` = '58647000' ,`ListAgentFullName` = 'Vanessa Darko' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.396869' ,`Longitude` = '-95.640844' ,`PhotoCount` = '46' ,`PostalCode` = '77356' ,`RoomCount` = '3' ,`ListPrice` = '390000.00' ,`Status` = 'Active' ,`StreetName` = 'La Costa' ,`StreetNumber` = '91' ,`StreetSuffix` = 'Drive' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2608' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Location is EVERYTHING! Welcome to 91 La Costa Drive nestled in the exclusive Del Lago / Margaritaville Resort community. THIS HOME HAS IT ALL! Not only is it situated ON THE 4TH HOLE, but it also OVERLOOKS THE 5TH TEE and has FRONT AND BACK WATER VIEWS...and that\'s just the outside. Inside feast your eyes on over $100K of modern renovations! This beautiful home has been completely upgraded to feature modern flooring, lighting, countertops, painting (inside and outside) landscaping, a brand new roof, 2 brand new 16 SEER air conditioning units, and SO MUCH MORE! Property is available for sale or for lease.' ,`Acres` = '0.1651' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'DEL LAGO 01, BLOCK 5, LOT 91' ,`LotDesciption` = 'In Golf Course Community,On Golf Course,Subdivision Lot,Water View' ,`LotSize` = '7193' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'MADELEY RANCH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MONTGOMERY HIGH SCHOOL' ,`SchoolMiddle` = 'MONTGOMERY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Leave Business Card,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Del Lago' ,`TaxAmount` = '4549' ,`TaxRate` = '1.862' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1989' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641417' WHERE `Matrix_Unique_ID` = '212093560' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-22T21:49:35.493' ,`MLSNumber` = '71864321' ,`ListAgentFullName` = 'Susan Stahley' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = 'Denise Ashby' ,`SellingOfficeName` = 'Keller Williams RealtyNortheast' ,`Latitude` = '30.268690' ,`Longitude` = '-95.422823' ,`PhotoCount` = '50' ,`PostalCode` = '77302' ,`RoomCount` = '12' ,`ListPrice` = '849000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Sonali Springs' ,`StreetNumber` = '13239' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4208' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Spectacular ONE OF A KIND with TONS of Recent Updates & AMAZING OUTDOOR PARADISE. One & Half Story w/ 4 Beds Down & Game Room/Media Room Up. Gorgeous Island Kitchen w/ Top of the Line Bosch Appliances, New Cabinets, High End Granite & Designer Backsplash. Completely Remodeled Master Bathroom w/ Fantastic Shower & Soaking Tub. Secondary Bathrooms Remodeled. New High End Carpet. Light, Bright & Open Throughout. Tons of Built Ins for Great Storage. Floor to Ceiling Windows Showcase the BREATHTAKING Private & Serene Backyard w/ Lush Landscaping, Walking Paths, Bridge, Flowing Stream, Arbor, Pool/Spa, Firepit, Covered Veranda w/ Ample Seating Areas Plus an Additional Covered Patio. New Roof in 2022 w/ Automatic Vent Systems. Whole House Generator. Water Softener. Reverse Osmosis System at Kitchen Sink. Both HVAC Systems are New & Have Reme Halo Air Purification Systems, New Media Filter Cabinets & Ducts. New Interior/Exterior Paint. Tankless Water Heater. Lutron Remote Controlled Blinds.' ,`Acres` = '0.6705' ,`Area` = '19' ,`BuilderName` = 'Trendmaker' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S355802 - CRIGHTON WOODS 02, BLOCK 1, LOT 22' ,`LotDesciption` = 'Greenbelt,Wooded' ,`LotSize` = '29205' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '560' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'WILKINSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Crighton Woods 02' ,`TaxAmount` = '10370' ,`TaxRate` = '2.1863' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641417' WHERE `Matrix_Unique_ID` = '212710032' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-22T22:03:39.303' ,`MLSNumber` = '88416779' ,`ListAgentFullName` = 'Holly Petrie' ,`ListOfficeName` = 'RE/MAX Pro' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.400678' ,`Longitude` = '-94.306599' ,`PhotoCount` = '21' ,`PostalCode` = '77625' ,`RoomCount` = '6' ,`ListPrice` = '129900.00' ,`Status` = 'Active' ,`StreetName` = 'Villa Rd' ,`StreetNumber` = '2549' ,`StreetSuffix` = '' ,`City` = 'Kountze' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Wanting acreage in the country?? Well come check this out! 2009 Doublewide with 4 bedroom split floor plan, living room open concept to kitchen/breakfast area, new carpet throughout, interior laundry room, covered back deck situated all on 4 beautiful acres. Quiet area,brand new well, plenty of parking and ready for YOU! Call your favorite agent today, better not delay!' ,`Acres` = '' ,`Area` = '49' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'AB 270 J HOUSTON 2009 28X52 TAN/BLACK NTA1487545/46 P# 270-2' ,`LotDesciption` = 'Other' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition,Other' ,`SchoolDistrict` = '269 - Kountze' ,`SchoolElementary` = 'KOUNTZE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KOUNTZE HIGH SCHOOL' ,`SchoolMiddle` = 'KOUNTZE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = '' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'TBD' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '2009' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641417' WHERE `Matrix_Unique_ID` = '213249144' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-22T22:24:15.367' ,`MLSNumber` = '81376741' ,`ListAgentFullName` = 'Dawei Ke' ,`ListOfficeName` = 'Glad Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.550701' ,`Longitude` = '-95.524182' ,`PhotoCount` = '50' ,`PostalCode` = '77459' ,`RoomCount` = '6' ,`ListPrice` = '399000.00' ,`Status` = 'Active' ,`StreetName` = 'Catania Bay' ,`StreetNumber` = '3911' ,`StreetSuffix` = 'Court' ,`City` = 'Missouri City' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2906' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'On the Lake! Upgraded tile floor throughout the 1st. 42\' Maple wood Cabinet in the Kitchen Off the family room, the master bedroom suite hosts a master bath featuring dual sinks, a relaxing garden tub, a convenient separate shower, a private commode, a linen closet, and an oversized walk-in closet. Downstairs you will also find the utility room and convenient powder room for visiting guests. Upstairs, you will find 3 additional bedrooms with large closets, two full baths, and an oversized game room.' ,`Acres` = '0.1876' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LAKE SHORE HARBOUR, BLOCK 2, LOT 15 SEC 5' ,`LotDesciption` = 'Waterfront' ,`LotSize` = '8173' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'PALMER ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'HIGHTOWER HIGH SCHOOL' ,`SchoolMiddle` = 'LAKE OLYMPIA MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lake Shore Harbour' ,`TaxAmount` = '7163' ,`TaxRate` = '2.34' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641417' WHERE `Matrix_Unique_ID` = '213265248' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-22T22:13:48.903' ,`MLSNumber` = '57398963' ,`ListAgentFullName` = 'Jamie Butler' ,`ListOfficeName` = 'Brighthouse Realty, LLC' ,`SellingAgentFullName` = 'Tammy Longdon' ,`SellingOfficeName` = 'Coldwell Banker RealtyThe Willis Office' ,`Latitude` = '30.123095' ,`Longitude` = '-95.459585' ,`PhotoCount` = '44' ,`PostalCode` = '77380' ,`RoomCount` = '9' ,`ListPrice` = '369999.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Trestletree' ,`StreetNumber` = '86' ,`StreetSuffix` = 'Place' ,`City` = 'The Woodlands' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2040' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home! Updated 4 bedroom 2.5 bath home with 2 car garage on a Large Corner Lot located on a cul-de-sac in Grogans Mill. Gourmet island style kitchen with featuring granite counter tops, gas cooking & stainless appliances ALL included. Home features high ceilings, open floor plan, fireplace, updated flooring, washer / dryer included, updated fixtures throughout, Roof Replaced in 2017, primary suite located on the first floor, features updated bath with granite, frameless shower & walk-in closet Texas Size Backyard with new fence, custom deck & storage shed ! Short distance to parks and school. Zoned to outstanding CISD schools. Low Tax rate. close proximity to shopping and entertainment. Easy access to the Houston park and ride, I45, Hardy toll, and Hwy 99.' ,`Acres` = '0.2412' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S972865 - WDLNDS VIL GROGANS ML 65, BLOCK 4, LOT 6' ,`LotDesciption` = 'Corner,Cul-De-Sac' ,`LotSize` = '10505' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '0' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'SAM HAILEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'THE WOODLANDS COLLEGE PARK HIGH SCHOOL' ,`SchoolMiddle` = 'KNOX JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Wdlnds Village Grogans Ml 65' ,`TaxAmount` = '5328' ,`TaxRate` = '2.1816' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1994' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641418' WHERE `Matrix_Unique_ID` = '213490235' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-22T22:47:00.437' ,`MLSNumber` = '72221540' ,`ListAgentFullName` = 'Priscilla Raji' ,`ListOfficeName` = 'Summit Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.582026' ,`Longitude` = '-95.529453' ,`PhotoCount` = '40' ,`PostalCode` = '77489' ,`RoomCount` = '8' ,`ListPrice` = '380000.00' ,`Status` = 'Active' ,`StreetName` = 'Avocet' ,`StreetNumber` = '1830' ,`StreetSuffix` = 'Way' ,`City` = 'Missouri City' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2606' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 4 bedrooms, 3 full baths, lovely entrance with spacious kitchen with stainless steel appliances, lots of cabinet space 42\", primary bath, with double sinks, separate shower big family room, game room up, walk-in-closet your family will enjoy the backyard out door dinning.' ,`Acres` = '0.1188' ,`Area` = '38' ,`BuilderName` = 'CENTEX HOMES' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'MUSTANG TRAILS SEC 1A, BLOCK 1, LOT 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5175' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '625' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'LANTERN LANE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ELKINS HIGH SCHOOL' ,`SchoolMiddle` = 'QUAIL VALLEY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Mustang Trails Sec 1a' ,`TaxAmount` = '7846' ,`TaxRate` = '3.1174' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669641418' WHERE `Matrix_Unique_ID` = '214155607' --> 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','214275962','1669641418','214275962','2022-11-22T21:48:24.547','5289771','Phyllis Baudat','BHGRE Gary Greene','','','30.384722','-95.704430','50','77316','9','725000.00','Active','Old Plantersville','623','Road','Montgomery','1','0','4','2329','Single-Family','Once in a lifetime opportunity to own a unique piece of Montgomery history! This property features a historical two-story building, 50x43 2-story barn, and a 23x30 carport that is nestled on almost five acres which lies just seconds from historic downtown Montgomery! The 2-story historical building was built circa 1880 and was used as a boarding house for employees of the Hardesty Sawmill that existed on the property. The sawmill was known as the Montgomery Mill and Lumber Company which operated from 1884 to 1896. The home has undergone extensive renovations; however, it requires someone with a vision to restore it to its former glory! The property has not been occupied in a number of years and is in need of restoration. Beautiful property with so much potential! This is an estate sale and the property will sold in \"AS IS\" condition. This property would be an excellent location for a bed-and-breakfast, wedding/event venue, tiny home village (if approved by City of Montgomery).','4.99','39','Frank Hardesty','','','','Estate,No Disclosures','0','Freestanding','1','Montgomery County Northwest','Central Gas,Propane','0','A0022 - LANDRUM ZACHARIAS, TRACT 45-D, 45D-1, ACRES 4.113','Cleared','217364','Other','','','0','','0','','0','','','','','Aluminum','37 - Montgomery','MONTGOMERY ELEMENTARY SCHOOL (MONTGOMERY)','MONTGOMERY HIGH SCHOOL','MONTGOMERY JUNIOR HIGH SCHOOL','Accompany,Appointment Required,No Supra Keybox','Appraisal','2','Victorian','Landrum Zacharias','','2.2242','Public Sewer,Public Water,Well','1880','Seller'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-22T21:22:00.787' ,`MLSNumber` = '25137444' ,`ListAgentFullName` = 'Janis Adams' ,`ListOfficeName` = 'RE/MAX Associates Northeast' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.997161' ,`Longitude` = '-95.144746' ,`PhotoCount` = '18' ,`PostalCode` = '77346' ,`RoomCount` = '9' ,`ListPrice` = '269000.00' ,`Status` = 'Active' ,`StreetName` = 'Hikers Trail' ,`StreetNumber` = '19215' ,`StreetSuffix` = 'Drive' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2350' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Well-maintained two-story home in the wonderful golf community of Walden on Lake Houston. This 4-bed home offers plenty of room with its generous amount of living space. Entry opens into an elegant dining room, which is presently being used as a home office, to one side. The family room adjoins the spacious kitchen and breakfast nook. Master bedroom suite includes a walk-in closet, private master bath with walk-in shower. An oversized game room separates three additional bedrooms and a full bath on the second floor. The backyard is private with no back or side neighbors and good-sized patio area. Recent updates include fresh paint, light fixtures and faucets. NOTE: Country Club membership is required, you have access to fantastic neighborhood amenities like the Clubhouse restaurant, golf course, tennis, fitness center, Racquetball Courts, Olympic-sized pool. Close to shopping and restaurants, IAH Airport and Major freeways for commuters.' ,`Acres` = '0.1983' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Atascocita South' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 7 BLK 22 OLYMPIC VILLAGE WALDEN ON LAKE HOUSTON PH 2' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot' ,`LotSize` = '8640' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '375' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'MAPLEBROOK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ATASCOCITA HIGH SCHOOL' ,`SchoolMiddle` = 'ATASCOCITA MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Walden on Lake Houston' ,`TaxAmount` = '5163' ,`TaxRate` = '2.5885' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641418' WHERE `Matrix_Unique_ID` = '214320085' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-22T21:44:15.127' ,`MLSNumber` = '19882063' ,`ListAgentFullName` = 'Jose Ramirez Garcia' ,`ListOfficeName` = 'American Property Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.505361' ,`Longitude` = '-95.094555' ,`PhotoCount` = '25' ,`PostalCode` = '77573' ,`RoomCount` = '5' ,`ListPrice` = '130000.00' ,`Status` = 'Active' ,`StreetName` = 'Wilkins' ,`StreetNumber` = '200' ,`StreetSuffix` = 'Street' ,`City` = 'League City' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1089' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Investor special! 3 bedrooms 1 bath home located in League City. Just minutes away from I45, Space Center Houston and more! Bring all offers.' ,`Acres` = '0.1403' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 3 S F AUSTIN SUR LOT 11 PATTON SUB' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6110' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'RALPH PARR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'VICTORYLAKES INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Patton 1' ,`TaxAmount` = '3373' ,`TaxRate` = '2.0697' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1954' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641418' WHERE `Matrix_Unique_ID` = '214419931' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-22T22:20:44.257' ,`MLSNumber` = '83320484' ,`ListAgentFullName` = 'Fabyan Banos' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.185493' ,`Longitude` = '-95.469682' ,`PhotoCount` = '30' ,`PostalCode` = '77381' ,`RoomCount` = '6' ,`ListPrice` = '550000.00' ,`Status` = 'Active' ,`StreetName` = 'Tapestry Forest' ,`StreetNumber` = '43' ,`StreetSuffix` = 'Place' ,`City` = 'The Woodlands' ,`BathsFull` = '2' ,`BathsHalf` = '2' ,`BedsTotal` = '3' ,`SqFtTotal` = '2614' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fantastic one story home in highly sought after community of The Woodlands. This open concept home features high ceilings, granite countertops, a private study, and a climate controlled storage room located above garage. Living area offers a gas fireplace. Huge master bedroom. Property has had no issues at all with flooding. EZ access to I-45, Concerts at the Pavilion, Market Place, and the top rated Medical Center! Hike and bike trail is a short commute to Whole Foods/ H-E-B . Nearby amenities consist of a park, running trails, children\'s playground and tennis courts to name a few. Water Heater replaced 2019. Water Heater replaced 2020. AC replaced 2021.Schedule a showing today for this great opportunity to live in the Woodlands!' ,`Acres` = '0.1586' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'S959908 - WDLNDS GROGANS FOREST 08, BLOCK 1, LOT 11' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6910' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'LAMAR ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'THE WOODLANDS COLLEGE PARK HIGH SCHOOL' ,`SchoolMiddle` = 'KNOX JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Wdlnds Grogans Forest 08' ,`TaxAmount` = '8489' ,`TaxRate` = '2.1319' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641419' WHERE `Matrix_Unique_ID` = '214461821' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-22T22:41:25.670' ,`MLSNumber` = '5404236' ,`ListAgentFullName` = 'Melissa King' ,`ListOfficeName` = 'CORCORAN FERESTER REALTY' ,`SellingAgentFullName` = 'Amando Queiroga' ,`SellingOfficeName` = 'REALM Real Estate Professional' ,`Latitude` = '30.153854' ,`Longitude` = '-95.510354' ,`PhotoCount` = '46' ,`PostalCode` = '77381' ,`RoomCount` = '7' ,`ListPrice` = '1799000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Dara Beth' ,`StreetNumber` = '10' ,`StreetSuffix` = 'Court' ,`City` = 'The Woodlands' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3846' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Hard to find, luxury one story in gated neighborhood in the center of The Woodlands. This thoughtfully designed Frankel Building Group custom home exudes luxury & ease of living. Home is one story with 3 beds, 3.5 baths, executive study & media room. Kitchen is open to family room, entertainment bar area, dual dining spaces & backyard views. Furniture grade cabinets, Subzero/Wolf appliances & gorgeous countertops. Primary suite has large shower, separate tub w/direct backyard access & incredible lake views. Generous secondary bedrooms w/en-suite baths & large closets. This beautiful home sits on just over 1/3 acre & includes a resort style backyard w/pool/spa overlooking nature reserve & neighborhood lake. Outdoor living area w/fireplace & summer kitchen. Oversized 3 car garage;single stall includes AC so can be used as fitness/craft room or 2nd office. HUGE area over garage provides for amazing storage or can be finished for extra living space. Central location, award winning schools.' ,`Acres` = '0.339' ,`Area` = '15' ,`BuilderName` = 'Frankel Custom Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'S971531 - WDLNDS VIL INDIAN SPRG 31, BLOCK 1, LOT 11' ,`LotDesciption` = 'Cul-De-Sac,Greenbelt,Water View' ,`LotSize` = '14765' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Grill' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'GLEN LOCH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'THE WOODLANDS HIGH SCHOOL' ,`SchoolMiddle` = 'MCCULLOUGH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Other Style,Traditional' ,`Subdivision` = 'Wdlnds Village Indian Sprg 31' ,`TaxAmount` = '27859' ,`TaxRate` = '2.1319' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641419' WHERE `Matrix_Unique_ID` = '214755286' --> 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','214758162','1669641419','214758162','2022-11-22T21:10:23.380','85855092','Sheritha Vaughns','Natalie Glass Properties','','','30.125107','-95.391261','26','77386','4','420000.00','Active','Legends Ridge','29806','Drive','Spring','2','1','4','3030','Single-Family','Welcome to 29806 Legends Ridge! This beautiful 4 bedroom, 2 ½ bath, two story home is tucked away in the highly desired Gated Community of Canyon Gate at Legends Ranch! This home is perfectly located in between I-45, Hardy Toll, and Grand Parkway! Location provides immediate access to The Woodlands and 30 minutes to downtown Houston. There are lots of dining and shopping options within minutes away! This beautiful home has lots of upgrades (Tile Wood, Granite Countertops, Crown Moulding, Covered Patio, and much, much, more!) and is perfect for entertaining, as well as just relaxing and enjoying the family! With over 3000 sq ft, this home is generous in space with an XXL Gameroom/Media Room! This beauty is located on an extra-large street that leads to the community splash pad! The waterfront view is an added bonus! All measurements, square footage, and information deemed accurate, however, buyer to verify.','0.1612','15','Gehan Homes','','Electric Dryer Connections,Gas Dryer Connections','','Mud,Sellers Disclosure','1','Gas Connections','1','Spring Northeast','Central Electric','1','S328304 - CANYON GATE AT LEGENDS RANCH 04, BLOCK 3, LOT 24','Cul-De-Sac,Subdivision Lot,Water View','7020','Appraisal District','','1000','0','','2','Gas Oven','0','','','Gas Range','','Composition','11 - Conroe','BIRNHAM WOODS ELEMENTARY SCHOOL','GRAND OAKS HIGH SCHOOL','YORK JUNIOR HIGH SCHOOL','Appointment Required,Leave Business Card,Supra Keybox','Appraisal District','2','Traditional','Canyon Gate At Legends Ranch 0','8294','2.5587','Public Sewer,Public Water','2004','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','214814411','1669641419','214814411','2022-11-22T21:57:09.520','90678639','Vicki Miller','RE/MAX Opportunities','','','29.388623','-95.759008','45','77461','8','529900.00','Active','Dannhaus','10230','Road','Needville','4','0','3','1947','Single-Family','This Hill Country inspired \"Holiday House\" welcomes you home! Enjoy exterior features such as Austin Stone facade, sprawling covered porches, Mature shade TREES, & the perfect sized \'plunge\' pool for those Texas summers all situated on 1.89+/- Acres! Main House includes: generous sized 3 beds/3 baths, Metal Roof, open living/kitchen/dining with vaulted ceilings crafted from beautiful ASPEN wood, Stained concrete counters in kitchen w/stainless appliances, island with storage, very open floor plan, & a large picturesque window overlooking the acreage in back! Guest house: 546+/-sqft w/full kitchen & bath w/access to the pool side. Shop: 72x35 METAL FRAME, concrete floors, w/4 roll up doors & 1 walk thru door, plumbed for bath, & has extended cover for Motor home or farm equipment. Recent improvements: flooring (in both houses), paint, sink, dishwasher, concrete patio, roof ventilation, & fencing. Zoned to Needville ISD w/easy access to major freeway & hospitals. MUST SEE to appreciate!','1.897','30','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','','Central Electric','0','0481 J B PADON, TRACT C (PT), ACRES 1.897, (150 X 260.4)','Wooded','82633','Appraisal District','','','0','','4','Electric Oven','1','Gunite,In Ground','','Electric Range','','Aluminum','38 - Needville','NEEDVILLE ELEMENTARY SCHOOL','NEEDVILLE HIGH SCHOOL','NEEDVILLE JUNIOR HIGH SCHOOL','Appointment Required,Lockbox Front,Supra Keybox','Appraisal District','1','Traditional','J B Padon','5962','1.8957','Aerobic,Well','2003','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-22T22:45:49.300' ,`MLSNumber` = '59928410' ,`ListAgentFullName` = 'Elisa Noriega' ,`ListOfficeName` = 'NB Elite Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.344624' ,`Longitude` = '-95.532091' ,`PhotoCount` = '6' ,`PostalCode` = '77304' ,`RoomCount` = '6' ,`ListPrice` = '419000.00' ,`Status` = 'Active' ,`StreetName` = 'Catoti Cay' ,`StreetNumber` = '208' ,`StreetSuffix` = 'Court' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2662' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home!! This amazing Two-Story Plan Offers 4 Bedrooms, 3.5 Bathrooms, Game Room, Covered Outdoor Living Space + 2 Car Garage, this Beauty does not disappoint! Wide Open Concept Great Space Features Oversized Granite Chef\'s Kitchen, Large Casual Dining that Opens to the Family Room. Master Retreat has Attached Bath and a Wrapped Master Closet offering direct access to Utility. Upstairs houses 3 Beds, 2 Full Baths and Game Room. Stainless Steel Appliance Pkg w/ 42\" Cabinetry, Wood Tile Flooring, Gutters, Upgraded Carpet, 2\" Blinds, Automatic Garage Door Opener, Sprinkler System, Fully Sodded Yard + Landscape This property is also for lease: $2,600 a month.' ,`Acres` = '0.116' ,`Area` = '19' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'S582100 - HILLS OF WESTLAKE 01, BLOCK 7, LOT 45' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '5054' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'GORDON-REED ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Hills Of Westlake 01' ,`TaxAmount` = '621' ,`TaxRate` = '2.9803' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641419' WHERE `Matrix_Unique_ID` = '214896213' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-22T21:56:52.313' ,`MLSNumber` = '80546415' ,`ListAgentFullName` = 'Cathleen Harrison' ,`ListOfficeName` = 'My Galveston Getaway, Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.271421' ,`Longitude` = '-94.844125' ,`PhotoCount` = '4' ,`PostalCode` = '77551' ,`RoomCount` = '5' ,`ListPrice` = '295000.00' ,`Status` = 'Active' ,`StreetName` = 'Avenue R' ,`StreetNumber` = '7308' ,`StreetSuffix` = '' ,`City` = 'Galveston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1572' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Priced for quick sale. Quiet, end of dead end street. Lovely 3 bedroom, 2 bath home ready for your personal touches. Large family room connected to kitchen by the breakfast bar with granite counters. Dining room off the kitchen for easy entertaining or family dinners or game nights. Laundry/mud room accessible through hallway and also the 2 car garage. Primary bedroom has walk in closet and en suite bath, 2nd full bath in hallway as well. Small yard in the back.' ,`Acres` = '0.0781' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Near West End' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'MAGNOLIA COURT SUB (2007) ABST 121, LOT 28, ACRES 0.078' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '3400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Magnolia Court Sub 2007' ,`TaxAmount` = '4262' ,`TaxRate` = '2.0662' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641419' WHERE `Matrix_Unique_ID` = '214897062' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-22T21:16:14.947' ,`MLSNumber` = '24885300' ,`ListAgentFullName` = 'Cheryl Hadrych' ,`ListOfficeName` = 'Jason Mitchell Real Estate LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.539729' ,`Longitude` = '-96.263173' ,`PhotoCount` = '41' ,`PostalCode` = '77845' ,`RoomCount` = '4' ,`ListPrice` = '644900.00' ,`Status` = 'Active' ,`StreetName` = 'Pearl River' ,`StreetNumber` = '4822' ,`StreetSuffix` = 'Court' ,`City` = 'College Station' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2897' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Absolutely Gorgeous Ambit Farmhouse Style Home in the Greens Prairie Reserve Community. Inviting covered porch, stunning wood/ glass door, open feel foyer with a study on your left and two bedrooms and a bath on your right made private with a sliding barn door. The main center of the home, has spacious open concept kitchen/ dining/ living with exquisite stone fireplace flanked w/ built-ins & floating shelves. Chef\'s kitchen w/ tons of storage, Kitchen Aide inc. built-in double ovens, gas cooktop, and dishwasher! Walk-in butler\'s prep pantry w/ side built-in microwave and wine fridge, and ample storage. Supersized laundry area, mudroom, & powder bath. Large primary bedroom, walk-in closet w/ built-ins. Spa ensuite bath w/ double sinks, sitting area, walk in shower w/ sprayer & rain head, & soaking tub. Upstairs oversized bonus room along w/ bedroom & bath. 2-car garage has separate storage. Outdoor living w/ open view back yard & covered patio. A must see so you do not want to miss!' ,`Acres` = '0.1964' ,`Area` = '61' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'GREENS PRAIRIE RESERVE SEC 1 PH 102, BLOCK 2, LOT 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8555' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '850' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '153 - College Station' ,`SchoolElementary` = 'GREEN PRAIRIE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'A & M CONSOLIDATED HIGH SCHOOL' ,`SchoolMiddle` = 'WELLBORN MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Other Style' ,`Subdivision` = 'Greens Prairie Reserve Ph 102' ,`TaxAmount` = '12496' ,`TaxRate` = '2.1321' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641420' WHERE `Matrix_Unique_ID` = '214912934' --> 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','214932985','1669641420','214932985','2022-11-22T21:05:05.257','78037834','Glenda Johnson','A Action Realty','','','30.562395','-94.886544','23','77335','4','157000.00','Active','Briarwood','346','Drive','Goodrich','2','0','4','2552','Single-Family','Spacious 4-bedroom 2 bath home on over an acre of land. Interior of home has 2 living areas, an office/study that is accessed through the primary bedroom. Dining area has a glass door which leads to the sunroom that is perfect for the nature lover to enjoy the views of hardwood trees or bird watching. Kitchen has ample cabinet and countertop space. Backyard has 2 storage buildings. Oversized carport has plenty of room to park so bring the RV. Subdivision amenities include community pool and community Lake that is a short walk from the home. This property has so many possibilities. Schedule your appointment today.','1.1374','44','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','Wood Burning Fireplace','1','Livingston Area','Central Electric','1','HOLIDAY LAKE ESTATES SECTION 5 BLK 28 LOT 15, 16, 20 & 21','Cleared,Wooded','49547','Appraisal District','','64','0','','0','Freestanding Oven','0','','','Freestanding Range','','Composition','138 - Goodrich','GOODRICH ELEMENTARY SCHOOL','GOODRICH HIGH SCHOOL','GOODRICH MIDDLE SCHOOL','Accompany,Appointment Required','Appraisal District','1','Contemporary/Modern','Holiday Lake Estates Sec 5','313','1.7032','Aerobic','1998','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-22T21:46:43.493' ,`MLSNumber` = '81488298' ,`ListAgentFullName` = 'Ruksanah Pirani' ,`ListOfficeName` = 'Hometrust Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.590983' ,`Longitude` = '-95.694343' ,`PhotoCount` = '32' ,`PostalCode` = '77479' ,`RoomCount` = '10' ,`ListPrice` = '399000.00' ,`Status` = 'Active' ,`StreetName` = 'Annies' ,`StreetNumber` = '735' ,`StreetSuffix` = 'Way' ,`City` = 'Sugar Land' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3124' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous home in the prestigious New Territory. NEW ROOF - 2022, NEW COOKTOP, NEW PAINT, NEW QUARTZ COUNTERTOP in kitchen, home in very clean ready to move in condition. Large kitchen with access to formal dining and breakfast area. Neutral colors, gorgeous floors, good sized master bedroom. huge gameroom upstairs.' ,`Acres` = '0.1824' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Sugar Land West' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'NEW TERRITORY PARCEL SF-32, BLOCK 1, LOT 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7947' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1125' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'BRAZOS BEND ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TRAVIS HIGH SCHOOL (FORT BEND)' ,`SchoolMiddle` = 'SARTARTIA MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'New Territory Prcl Sf-32' ,`TaxAmount` = '7163' ,`TaxRate` = '2.4394' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641420' WHERE `Matrix_Unique_ID` = '214954323' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-22T21:55:01.260' ,`MLSNumber` = '82832303' ,`ListAgentFullName` = 'Justin Guyer' ,`ListOfficeName` = 'RE/MAX Professionals' ,`SellingAgentFullName` = 'Susan Wright' ,`SellingOfficeName` = 'RE/MAX Integrity' ,`Latitude` = '28.721287' ,`Longitude` = '-96.421838' ,`PhotoCount` = '25' ,`PostalCode` = '77465' ,`RoomCount` = '2' ,`ListPrice` = '315000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Bayshore' ,`StreetNumber` = '1798' ,`StreetSuffix` = 'Drive' ,`City` = 'Palacios' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1036' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Waterfront home with spectacular view located in the gated coastal community of Cape Carancahua. Conveniently situated on Hwy 35 between Palacios and Port Lavaca; shopping, dining and entertainment are just minutes away. This home is offered fully furnished with all appliances so you can just drop your bags and enjoy! The house has an open concept floor plan which accents the gorgeous views through the many windows in the living & dining area. Additional highlights include recent interior and exterior paint, vinyl plank floors and lots of cabinet and counter space. Outside there is a carport with parking pad, storage shed, covered patio, beautiful gardens, wood bulkhead and pier. Roof installed 2020 and full HVAC was replaced 2021. Community amenities include: 2 pools, lighted piers, boat ramp, playground, community center, covered pavilion with bathrooms, security gate and a relaxed atmosphere.' ,`Acres` = '0.26' ,`Area` = '67' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'CAPE CARANCAHUA #2, LOT 361, ACRES 0.26' ,`LotDesciption` = 'Subdivision Lot,Waterfront' ,`LotSize` = '11326' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven,Freestanding Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '156 - Palacios' ,`SchoolElementary` = 'CENTRAL ELEMENTARY SCHOOL (PALACIOS)' ,`SchoolHigh` = 'PALACIOS HIGH SCHOOL' ,`SchoolMiddle` = 'PALACIOS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Lockbox Back' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cape Carancahua' ,`TaxAmount` = '3162' ,`TaxRate` = '1.8978' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641420' WHERE `Matrix_Unique_ID` = '214973123' --> 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','214973538','1669641420','214973538','2022-11-22T21:46:32.607','46417527','Ben Hughes','Realty Solutions','','','30.134773','-95.651751','39','77362','6','259000.00','Active','Bunny','12031','Lane','Pinehurst','2','0','3','1464','Single-Family','Quiet and quaint this 3 bedroom 2 full bath home with attached 2 car garage is ready for immediate move in. Nestled in the corner of a cud-de-sac it is the perfect location zoned to Tomball ISD school district. Ceiling fans in all bedrooms, walk-in closets, gas fireplace in the living room, new carpet in guest room, new sod and landscaping in the front yard. This home also includes all appliances (washer, dryer, refrigerator, stove/oven, and microwave). Roof is only a few years old, recently replaced in 2018.','0.139','15','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gaslog Fireplace','1','Tomball','Central Gas','1','VILLAGE OF DECKER OAKS 01, BLOCK 1, LOT 13','Cul-De-Sac,Subdivision Lot','6056','Appraisal District','','504','0','','2','Gas Oven','0','','','Gas Range','','Composition','53 - Tomball','DECKER PRAIRIE ELEMENTARY SCHOOL','TOMBALL HIGH SCHOOL','TOMBALL JUNIOR HIGH SCHOOL','Appointment Required,Lockbox Front,Request Online Appointment','Appraisal District','1','Traditional','Village Of Decker Oaks 01','4087','1.9215','Public Sewer,Public Water','2003','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-22T22:54:17.567' ,`MLSNumber` = '79614479' ,`ListAgentFullName` = 'Karishma Naidu' ,`ListOfficeName` = 'Nextgen Real Estate Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.692161' ,`Longitude` = '-95.357517' ,`PhotoCount` = '9' ,`PostalCode` = '77021' ,`RoomCount` = '3' ,`ListPrice` = '255000.00' ,`Status` = 'Active' ,`StreetName` = 'Conley' ,`StreetNumber` = '6701' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1916' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Investor special. PROPERTY BEING SOLD \"AS IS\". No repairs will be made. Property has a great opportunity to rebuild and make it your dream home in this growing area. Surrounded by numerous remodels and new construction. Wonderful corner lot, perfect for a new home inside Houston\'s loop, Close to 288 and downtown, Museum district, I-45.' ,`Acres` = '' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'University Area' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LT 1 BLK 19 FOSTER PLACE' ,`LotDesciption` = 'Corner' ,`LotSize` = '5150' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'FOSTER ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'YATES HIGH SCHOOL' ,`SchoolMiddle` = 'CULLEN MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'FOSTER PLACE' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641420' WHERE `Matrix_Unique_ID` = '214977311' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-22T22:53:41.970' ,`MLSNumber` = '76638318' ,`ListAgentFullName` = 'Karishma Naidu' ,`ListOfficeName` = 'Nextgen Real Estate Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.691643' ,`Longitude` = '-95.357728' ,`PhotoCount` = '16' ,`PostalCode` = '77021' ,`RoomCount` = '3' ,`ListPrice` = '299000.00' ,`Status` = 'Active' ,`StreetName` = 'Conley' ,`StreetNumber` = '6711' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1131' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this newly updated home. Beautiful modern look with an open concept floor plan with a huge backyard. Gorgeous on the exterior as well as inside. You will not want to miss this Houston gem, great location. Close to 288 and downtown, Museum district, I-45. Schedule your tour today!' ,`Acres` = '' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'University Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 5 BLK 19 FOSTER PLACE' ,`LotDesciption` = 'Other' ,`LotSize` = '5150' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'FOSTER ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'YATES HIGH SCHOOL' ,`SchoolMiddle` = 'CULLEN MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'FOSTER PLACE' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1945' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641421' WHERE `Matrix_Unique_ID` = '214977432' --> 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','214984516','1669641421','214984516','2022-11-22T22:24:17.240','22221272','Christopher Schirmer','Christopher Schirmer, REALTOR','','','29.450060','-95.115906','33','77539','10','395031.00','Active','Ninos','2102','Drive','League City','3','0','4','2550','Single-Family','This Attractive new Cervelle Home, Plan 255 is a 4 bedroom, 3 full baths with an island kitchen, breakfast room and a soaring ceiling in the Family Room. Bedroom 4 has its own bath for that extra adult at home or mother in law. Cervelle Homes uses open cell Spray foam Insulation paired with a state of the art Trane 16 SEER HVAC with dehumidifier for a huge leap forward in Energy Savings. Corner lot. 2 car, detached garage and 2 car porte cohere. Lot size 16,249 square feet. Huge value and a must see!','','33','Cervelle Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','No Disclosures','1','Gaslog Fireplace','1','League City','Central Gas','1','Lot 9 Block 1','Corner,Subdivision Lot','16249','Survey','','450','1','Never Lived In','2','Electric Oven','0','','','Gas Cooktop','','Composition','17 - Dickinson','LOBIT ELEMENTARY SCHOOL','DICKINSON HIGH SCHOOL','LOBIT MIDDLE SCHOOL','Appointment Required,Leave Business Card,Vacant/Unoccupied','Builder','1','Traditional','Pedregal','','2.57','Public Sewer,Public Water','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','215016478','1669641421','215016478','2022-11-22T21:48:17.777','37727640','Donnie Amadi','SKW Realty','','','29.694024','-95.684468','18','77083','4','159990.00','Active','Mercado','17006','Drive','Houston','1','0','1','882','Single-Family','','0.0991','37','','','','','Sellers Disclosure','','','','Mission Bend Area','Central Gas','1','MISSION WEST SEC 2, BLOCK 1, LOT 12-B (SW 1/2)','Subdivision Lot','4317','Appraisal District','','350','0','','0','','0','','','','','Composition','19 - Fort Bend','MISSION WEST ELEMENTARY SCHOOL','BUSH HIGH SCHOOL','CROCKETT MIDDLE SCHOOL (FORT BEND)','Appointment Required','Appraisal District','1','Contemporary/Modern','Mission West Sec 2','2046','2.4297','Public Sewer,Public Water','1982','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','215017967','1669641421','215017967','2022-11-22T21:46:53.743','26651545','Yuliana Gonzalez','Evolve Real Estate','','','30.194965','-95.422900','43','77385','7','545000.00','Active','White Baneberry','17542','Drive','Conroe','3','0','4','2794','Single-Family','Gorgeous, like new History Maker 4 bedroom 3 bath home located amongst a top master community close to the the Woodlands-Zoned CISD, gated and resort style amenities. Beautiful kitchen with quartz countertops, 42\" Cabinetry & SS appliances. Crown molding throughout. Primary room features two enormous walk-in closet, garden tub with double sinks and separate shower. Two car garage with enough additional room for all of your outdoor gear and tools. Spacious backyard. Located just minutes away from the Woodlands fine dining, shopping and entertainment. Come check it out!!','0.2121','15','History Maker','','Washer Connections','','Sellers Disclosure','1','','','Spring Northeast','Central Gas','1','S572728 - HARPER\'S PRESERVE 28, BLOCK 2, LOT 5','Subdivision Lot','9237','Appraisal District','','1727','0','','2','','0','','','','','Composition','11 - Conroe','SUCHMA ELEMENTARY SCHOOL','OAK RIDGE HIGH SCHOOL','IRONS JUNIOR HIGH SCHOOL','Leave Business Card,Lockbox Front,Vacant/Unoccupied','Appraisal District','2','Traditional','Harpers Preserve 28','1169','3.0088','Public Sewer,Public Water','2022','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','215020492','1669641421','215020492','2022-11-22T21:52:09.523','70623746','Charlie Udolisa','US Asset Management','','','29.703690','-95.661543','21','77083','7','260000.00','Active','La Granada','6818','Drive','Houston','2','0','3','2027','Single-Family','BEAUTIFUL HOME WITH ALL FORMALS. HOME IS GORGEOUS WITH LOTS OF UPGRADES INCLUDING GRANITE COUNTERTOP IN KITCHEN WITH SPACIOUS ISLAND. MASTER BATH BOASTS OF MARBLE FINISH WITH LOTS OF BUILT-INS, SPACIOUS DECK, GREAT CURB APPEAL, RECENT ROOF E.T.C.','0.1848','37','','','','','Sellers Disclosure','','','1','Mission Bend Area','Central Gas','1','LT 33 BLK 12 MISSION BEND SEC 11','Other','8050','Appraisal District','','400','0','','2','','0','','','','','Composition','2 - Alief','PETROSKY ELEMENTARY SCHOOL','AISD DRAW','ALBRIGHT MIDDLE SCHOOL','Appointment Required','Appraisal District','1','English','Mission Bend Sec 11','5441','2.437','Public Sewer,Public Water','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','215044479','1669641421','215044479','2022-11-22T21:19:11.237','75389588','Julie Cornay','Keller Williams RealtyNortheast','','','30.171612','-95.184229','26','77357','0','284000.00','Active','24019 Cherry Birch','24019','Lane','New Caney','2','0','4','1970','Single-Family','Desirable Brenham collection by Lennar Home Builders. This is a beautiful floor plan and home! Constructed in 2020, this home looks brand new. LVP flooring throughout living area and kitchen; kitchen has granite and an island for entertaining. This home boasts a large primary bedroom with a spa like en suite with separate tub and shower, and a dual vanity. Attached is a huge walk in closet. The laundry room is easily accessible from the primary bedroom and bath. It is a split floor plan from the 3 secondary bedrooms and bath.\r\nEnjoy the covered patio in the backyard. There is plenty of room for fun and relaxation. There is nothing to do but move in! This beauty is located on a very desirable cul-de-sac with no direct across the street neighbors. Make it yours!','0.1406','40','Lennar','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','','','Porter/New Caney East','Central Gas','0','S921122 - TAVOLA 22, BLOCK 2, LOT 12','Cul-De-Sac','6125','Appraisal District','','800','0','','2','Electric Oven','0','','','Gas Cooktop','','Composition','39 - New Caney','TAVOLA ELEMENTARY SCHOOL (NEW CANEY)','NEW CANEY HIGH SCHOOL','KEEFER CROSSING MIDDLE SCHOOL','Appointment Required,Lockbox Front','Appraisal District','1','Other Style','Tavola 22','9504','3.3731','Water District','2020','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','215044686','1669641421','215044686','2022-11-22T21:32:03.337','54742046','Traci Ethington','Covenant Properties RealEstate','','','29.167951','-95.462954','18','77515','6','359900.00','Active','County Road 893','311','','Angleton','2','0','3','1812','Single-Family','Are you looking for a 3 bedroom 2 bath on just over an acre close to Highway 288? Here it is. This newly painted house (all exterior and interior) also has a new dishwasher, lights, and ceiling fans. The AC manifold was also updated and the pressure tank on the well has been replaced. This house features an open floor plan with a huge kitchen and dining area and family room. The laundry room is inside. The primary bedroom has an en-suite bathroom with 2 walk-in closets. The secondary bath has a nice shower only. Outside, the backyard is fenced and has a shed and chicken coop area. There are big beautiful shady trees on the property and plenty of room to play or garden. This house DID NOT flood during Hurricane Harvey, the yard did take on water. Chickens are welcomed in this neighborhood. This house is in a great location with easy access to 288, Angleton, Lake Jackson or West Columbia. Come and make an appointment to see this soon.','1.28','5','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','Angleton','Central Electric','0','LONGHORN S/D (UNRECD) LT 81 TRS 10-11 124 WM ROBERTS, ACRES','Subdivision Lot','55757','Appraisal District','','','0','','2','Freestanding Oven','0','','','Electric Range','','Composition','5 - Angleton','WESTSIDE ELEMENTARY SCHOOL (ANGLETON)','ANGLETON HIGH SCHOOL','ANGLETON MIDDLE SCHOOL','Appointment Required,Lockbox Front','Appraisal District','1','Ranch','Longhorn Sub','5060','1.886','Septic Tank,Well','1995','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','215045921','1669641421','215045921','2022-11-22T22:29:21.430','23300898','Paige Houston','Texas Real Estate Pro','','','30.716334','-94.935884','31','77351','3','299000.00','Active','North','400','Street','Livingston','1','0','2','1483','Single-Family','Charming Victorian Style 2 bedroom 1 bath home in the heart of Livingston! NEW ROOF INSTALLED September 2022 that comes with a transferrable warranty! NEW HVAC in July 2022. Oversized front porch to enjoy a cup of coffee in the morning. Beautiful hardwood floors throughout the entire home. The family room is located at the front of the home with shiplap walls. Large dining room connected to the kitchen perfect to hosts family dinners. The kitchen features white cabinetry, butcher block countertops, open shelving, a farmhouse sink & a stainless steel range. The primary bedroom is located at the back of the home with windows galore. LARGE YARD with oak trees, completely fenced in and recently landscaped. There is a workshop/storage building in the backyard with electricity. The white picket fence was just added at the front of the home. Just a short drive from Lake Livingston and about an hour from Houston. Minutes from restaurants, schools, health care & shopping.','0.388','44','','','Electric Dryer Connections,Gas Dryer Connections','','Sellers Disclosure','','','','Livingston Area','Central Electric','0','FEAGIN BLK 2 E/2','Subdivision Lot,Wooded','16901','Appraisal District','','','0','','0','Gas Oven','0','','','Gas Cooktop','','Composition','103 - Livingston','LISD OPEN ENROLL','LIVINGSTON HIGH SCHOOL','LIVINGSTON JUNIOR HIGH SCHOOL','Appointment Required,Supra Keybox','Appraisal District','1','Ranch,Victorian','Feagin','1653','1.8745','Public Sewer,Public Water','1950','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','215046771','1669641421','215046771','2022-11-22T22:54:58.483','46240308','Charman Escobedo','Green And Associates, REALTORS','','','30.211036','-95.176759','18','77372','8','278500.00','Active','1st','16103','Street','Splendora','2','1','3','1959','Single-Family','Country living at its finest! Beautifully remodeled home sitting on over an acre of land and ready to be yours for the holidays! Spacious home has open concept living and dining. Kitchen features granite counter tops, white shaker style cabinets and dramatic stainless/black appliances. Living area has luxury vinyl plank flooring while bedrooms have new carpet. Primary bedroom is large with en-suite that has granite counter tops, nice sized closets, and new fixtures. Two additional bedrooms are large with lots of windows to let in natural light. Both have ample closet space and secondary bath has tub/shower combo with granite counter tops. Great space for outdoor living. Massive yard, with covered patio area, attached carport and storage area. Roof, HVAC, water heater, 2 yrs old. NO HOA, NO RESTRICTIONS, LOW TAXES AND SOUGHT AFTER SPLENDORA ISD. Close to 59 for easy access to Houston. Make an appointment to view this lovely home today. This one won\'t last long.','1.06','40','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','1','Cleveland Area','Central Electric','0','PINEWOOD ESTATES, LOT 33, ACRES 1.060','Cleared','46174','Appraisal District','','','0','','0','Electric Oven,Freestanding Oven','0','','','Electric Range,Freestanding Range','','Composition','47 - Splendora','PEACH CREEK ELEMENTARY SCHOOL','SPLENDORA HIGH SCHOOL','SPLENDORA JUNIOR HIGH','Appointment Required','Appraisal District','1','Ranch','Pinewood Estates','4230','2.4206','Public Sewer,Public Water','1974','Appraisal District'); --> New record created successfully