Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-10T10:35:14.493' ,`MLSNumber` = '65186198' ,`ListAgentFullName` = 'Ava Gutowski' ,`ListOfficeName` = 'Key 2 Texas Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.813076' ,`Longitude` = '-95.654098' ,`PhotoCount` = '50' ,`PostalCode` = '77414' ,`RoomCount` = '3' ,`ListPrice` = '299000.00' ,`Status` = 'Active' ,`StreetName` = 'Private Road 674' ,`StreetNumber` = '536' ,`StreetSuffix` = '' ,`City` = 'Sargent' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '2' ,`SqFtTotal` = '2004' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This Property Offers 3 Large(150 ft.) Waterfront Lots, 2 Bedrooms, 2 1/2 Bathrooms, A Large Recreation and Bunk Room on A Quite Serene Canal. Recent Paint and Central A/C. This Property Has a Recent Bulkhead and Pier! There is almost always a pleasant breeze while sitting in the shade outside of this home. Even on the hottest of days the breeze is sufficient enough to keep you comfortable. Add your favorite beverages into the mix and you may not want to leave! The sun room offers a pleasant view of the water and surrounding area. You can watch the family, friends and guests enjoying the pier and water activities while also entertaining guests or working on projects. The lower level rec-room is a great place to enjoy recreational activities such as ping pong, pool, card games, board games and video games. This room provides additional sleeping capacity(up to 8) and can accommodate guests with its 2 trundle beds, a bunk bed and a murphy bed! HVAC 2022!' ,`Acres` = '0.512' ,`Area` = '54' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'CANEY COVE ESTATES SEC 2, LOT 8-9 & 10' ,`LotDesciption` = 'Waterfront' ,`LotSize` = '22302' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum,Composition' ,`SchoolDistrict` = '134 - Van Vleck' ,`SchoolElementary` = 'VAN VLECK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'VAN VLECK HIGH SCHOOL' ,`SchoolMiddle` = 'O H HERMAN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Caney Cove Estates Sec 2' ,`TaxAmount` = '3462' ,`TaxRate` = '2.3895' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663708947' WHERE `Matrix_Unique_ID` = '204053237' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-10T10:33:48.383' ,`MLSNumber` = '35222719' ,`ListAgentFullName` = 'Jennifer Flud' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.565390' ,`Longitude` = '-95.114670' ,`PhotoCount` = '19' ,`PostalCode` = '77062' ,`RoomCount` = '6' ,`ListPrice` = '259900.00' ,`Status` = 'Active' ,`StreetName` = 'Bonanza' ,`StreetNumber` = '1715' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1778' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Located in the quiet, beautiful neighborhood of Clear Lake City, this one-story home offers wood tile floors in the living room, kitchen and dining area. The remodeled kitchen has ample cabinet and counter space with a breakfast bar. The dining room is open to the spacious living area with a great view of the backyard. The large primary bedroom has 3 closets, a sitting area and also offers bench seating. The jumpers at each outlet have been replaced. The backyard has a covered patio with plenty of space for the kids to play. No flooding!' ,`Acres` = '0.1928' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Corporate Listing,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Clear Lake Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 85 BLK 16 CLEAR LAKE CITY SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '68' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'CLEAR LAKE CITY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR LAKE HIGH SCHOOL' ,`SchoolMiddle` = 'SPACE CENTER INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Clear Lake City Sec 02' ,`TaxAmount` = '5130' ,`TaxRate` = '2.5769' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1965' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663708947' WHERE `Matrix_Unique_ID` = '208094469' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-10T11:42:13.900' ,`MLSNumber` = '85088896' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'HomesUSA.com' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.196580' ,`Longitude` = '-95.422371' ,`PhotoCount` = '50' ,`PostalCode` = '77385' ,`RoomCount` = '11' ,`ListPrice` = '519535.00' ,`Status` = 'Active' ,`StreetName` = 'Bayou Oaks' ,`StreetNumber` = '10243' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3176' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 85088896 - Built by HistoryMaker Homes - September completion! ~ Welcome to HistoryMaker Homes in Harper\'s Preserve. The exclusive, gated, Harper\'s Preserve offers exemplary schools, resort-style amenities and is located just minutes away from world class dining, shopping, and entertainment. This stunning Alder plan boasts a welcoming stone accented covered entry, 10\' ceilings on the first floor, an extended covered patio perfect for outdoor entertaining, and a box out window in the breakfast area. Prepare meals in the finely appointed kitchen that boasts Quartz counters, stainless-steel appliances, 42 inch cabinetry with crown molding, a large island and walk-in pantry. Study in the front of your home gives great views while in the office. The primary bedroom boasts a large walk-in closet, garden tub and separate shower. One of the secondary bedrooms upstairs has a private bathroom great for guests. This home backs to Horsepen Bayou and walking trail with no rear neighbors.' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'HistoryMaker Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S572728 - HARPER\'S PRESERVE 28, BLOCK 3, LOT 6' ,`LotDesciption` = 'Cul-De-Sac,Greenbelt,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1127' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'SUCHMA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'OAK RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'IRONS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Harper\'s Preserve' ,`TaxAmount` = '' ,`TaxRate` = '3.01' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663708947' WHERE `Matrix_Unique_ID` = '208155149' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-10T11:59:28.013' ,`MLSNumber` = '18699867' ,`ListAgentFullName` = 'Gwendolyn Davis' ,`ListOfficeName` = 'CB&A, Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.183577' ,`Longitude` = '-95.587945' ,`PhotoCount` = '42' ,`PostalCode` = '77354' ,`RoomCount` = '8' ,`ListPrice` = '2125000.00' ,`Status` = 'Active' ,`StreetName` = 'Prine' ,`StreetNumber` = '8350' ,`StreetSuffix` = 'Lane' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '4691' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Private gated RETREAT. Has gorgeous relaxing lagoon out front. Main house remodeled about 6 years ago has 3/4 bedrooms & 2 baths with 6 car & RV garage! House also has a sun room or storage room off kitchen. Kitchen has rubbed bronze appliances. copper sink, copper ceiling tiles & custom Hickory cabinets. There are pull outs and built ins for exceptional space through out this home. 2 plaster fireplaces for that rustic look takes you back to the hill country. Private bar for serving beverages. There is a high game fence pen for small game. Horse stall with tack room has electricity & hot water. Private horse arena. Guest house has approx 2100 sq. ft with a 3 car garage & handicapped accessible. it was completely remodeled 2 years ago & has brand new wood aggregate floors. Both homes have metal roofs! Magnolia ISD. All this within 1 mile from Woodlands Prkwy & FM 2978! There is additional acreage available! Low Taxes!' ,`Acres` = '5.053' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Electric,Propane' ,`HOAMandatory` = '0' ,`Legal` = 'A0078-BROWN JAMES TRACT 2B,13N, 5.053 ACRES' ,`LotDesciption` = 'Cleared,Corner,Other' ,`LotSize` = '220109' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '6' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'CEDRIC C. SMITH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'James Brown' ,`TaxAmount` = '5288' ,`TaxRate` = '1.85' ,`WaterSewer` = 'Aerobic,Septic Tank,Well' ,`YearBuilt` = '1990' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663708948' WHERE `Matrix_Unique_ID` = '208173828' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-10T11:43:11.213' ,`MLSNumber` = '88696030' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'HomesUSA.com' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.196424' ,`Longitude` = '-95.421607' ,`PhotoCount` = '32' ,`PostalCode` = '77385' ,`RoomCount` = '12' ,`ListPrice` = '514208.00' ,`Status` = 'Active' ,`StreetName` = 'Bayou Oaks' ,`StreetNumber` = '10263' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3133' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 88696030 - Built by HistoryMaker Homes - September completion! ~ Welcome to HistoryMaker Homes in Harper’s Preserve. The exclusive, gated, Harper\'s Preserve offers exemplary schools, resort-style amenities and is located just minutes away from world class dining, shopping, and entertainment. This stunning Hawthorn plan features a 10 Foot ceiling on the first floor and 9 ft ceiling on the 2nd floor, box out windows in the dining area, an extended covered patio, study and large game room with Media Room! The chef-inspired kitchen boasts Quartz countertops, a large island, 42 cabinetry with crown molding, and stainless-steel Whirlpool appliances. The privately situated primary bedroom offers a dual walk-in closets, garden tub, separate shower, and dual vanities with separate sinks! OVERSIZED yard with access to the walking trail and Horsepen Bayou!' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'HistoryMaker Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S572728 - HARPER\'S PRESERVE 28, BLOCK 3, LOT 11' ,`LotDesciption` = 'Cul-De-Sac,Greenbelt,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1127' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'SUCHMA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'OAK RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'IRONS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Harper\'s Preserve' ,`TaxAmount` = '' ,`TaxRate` = '3.01' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663708948' WHERE `Matrix_Unique_ID` = '208417534' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-10T11:14:13.330' ,`MLSNumber` = '22085493' ,`ListAgentFullName` = 'Michelle Moreno' ,`ListOfficeName` = 'Fathom Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.302538' ,`Longitude` = '-94.775989' ,`PhotoCount` = '47' ,`PostalCode` = '77550' ,`RoomCount` = '3' ,`ListPrice` = '725000.00' ,`Status` = 'Active' ,`StreetName` = 'Avenue L' ,`StreetNumber` = '916' ,`StreetSuffix` = '' ,`City` = 'Galveston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1530' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fully restored, charming vintage income producing vacation home. Fully furnished and ready for you to move in and vacation where you live, or rent out. Located on Galveston\'s East End overlooking Stewart Beach in close proximity to shopping, dining, and private beach access. 3 bedroom, 2 1/2 bath, open concept living/dining/kitchen area. Pocket doors between kitchen and living room. Private backyard brick/concrete/furnished patio area, natural gas line available outdoor patio, outdoor shower (hot and cold water). Private driveway parking (3 car) and street parking. Not one, but two, furnished balconies to enjoy the water views. Primary bedroom also offers water views. Ring camera (solar). New flagstone walkway. Updated windows, electrical, plumbing, HVAC/NEST smart controls, tankless water heater, and roof. All information deemed reliable but not guaranteed. Buyer to verify.' ,`Acres` = '0.0698' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'East End' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 628 M B MENARD SUR TR II AVENUE L SEA VIEW RPLT OF LOT' ,`LotDesciption` = 'Water View' ,`LotSize` = '3042' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Galveston Townsite' ,`TaxAmount` = '7120' ,`TaxRate` = '2.0662' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1901' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663708948' WHERE `Matrix_Unique_ID` = '210038891' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-10T11:00:01.063' ,`MLSNumber` = '39314883' ,`ListAgentFullName` = 'Penny Henske' ,`ListOfficeName` = 'Double G Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.708762' ,`Longitude` = '-96.393677' ,`PhotoCount` = '36' ,`PostalCode` = '78935' ,`RoomCount` = '11' ,`ListPrice` = '680000.00' ,`Status` = 'Active' ,`StreetName` = 'Quail Hollow' ,`StreetNumber` = '1020' ,`StreetSuffix` = 'Drive' ,`City` = 'Alleyton' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2838' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Peace and quiet will describe this beautiful custom-built home which sits on 3.785 acres with a 3 bedroom 2.5 bath home. The open concept will let you enjoy guests as they gather in the family room, kitchen or dining room. The granite counters are throughout the home with a touch of class in every room. Beautifully landscaping shows how much care went into this property. The primary bedroom and bath are off from the family room with a large walk-in closet that has it all. The 2nd and 3rd bedrooms are off from the kitchen as well as the 2nd bath. The utility room is beyond a person\'s dream. You can have room for a washer/dryer as well as refrigerator and freezer and a large table that can be used for anything you need. There is a 30\'x50\' building with a kitchen, full bath and an enclosed room that can be used for a bedroom if needed. There is a 24\'x25\' building that is large enough for all your equipment and more.' ,`Acres` = '3.785' ,`Area` = '56' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 14 WINSLOW HILLS 3.785 AC HOUSE & BLDGS' ,`LotDesciption` = 'Cleared' ,`LotSize` = '164875' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '188 - Columbus' ,`SchoolElementary` = 'COLUMBUS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'COLUMBUS HIGH SCHOOL' ,`SchoolMiddle` = 'COLUMBUS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Winslow Hills' ,`TaxAmount` = '6703' ,`TaxRate` = '1.5459' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663708948' WHERE `Matrix_Unique_ID` = '210102879' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-10T11:37:54.990' ,`MLSNumber` = '57658953' ,`ListAgentFullName` = 'Laura Hughes' ,`ListOfficeName` = 'Compass RE Texas, LLCKaty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.928905' ,`Longitude` = '-95.737865' ,`PhotoCount` = '50' ,`PostalCode` = '77433' ,`RoomCount` = '12' ,`ListPrice` = '865000.00' ,`Status` = 'Active' ,`StreetName` = 'Sand Bluestem' ,`StreetNumber` = '15643' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '5' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '3542' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Why wait to build when this just constructed home is ready for immediate move in. Located Bridgeland and right around the corner from Dragonfly Park this home is surrounded by trees on two sides with no back or side neighbors. You will love the modern elevation with painted brick and dark trim. Inside find soaring ceilings, wood-look tile floors & dramatic wood stairs with iron balusters. Island kitchen features quartz counters, Kent Moore gray stained cabinets, double ovens, microwave & gas cooktop. Cook and visit with family and friends in the two-story family room with its wall of sliding glass doors, modern fireplace and casual dining room. Two bedrooms down including the primary with dual closets, oversized shower, dual sinks & separate vanity area. Upstairs are three spacious bedrooms two with en suites, a game room and a media room. Outside find a covered patio already plumbed for an outdoor kitchen and a yard large enough for a pool. Smart Home capable. Lots of upgrades.' ,`Acres` = '0.2131' ,`Area` = '25' ,`BuilderName` = 'Darling Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 6 BLK 2 BRIDGELAND PARKLAND VILLAGE SEC 50' ,`LotDesciption` = 'Cul-De-Sac,Greenbelt,Subdivision Lot' ,`LotSize` = '9283' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1210' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'MCGOWN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRIDGELAND HIGH SCHOOL' ,`SchoolMiddle` = 'SMITH MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Bridgeland Parkland Village' ,`TaxAmount` = '1558' ,`TaxRate` = '3.541' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663708948' WHERE `Matrix_Unique_ID` = '210123124' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-10T11:31:02.937' ,`MLSNumber` = '36602300' ,`ListAgentFullName` = 'Dina Sicilia' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.930218' ,`Longitude` = '-95.606787' ,`PhotoCount` = '14' ,`PostalCode` = '77065' ,`RoomCount` = '8' ,`ListPrice` = '450000.00' ,`Status` = 'Active' ,`StreetName` = 'Elm Bough' ,`StreetNumber` = '12511' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '3226' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'TWO MASTERS!!! AMAZING LAID OUT FLOORPLAN , ONE MASTER DOWN, 2ND MASTER UP-STAIRS, 5 BEDROOMS, 3 FULL BATHROOMS, BRIGHT AND SUNNY KITCHEN, TILE & LAMINATED WOOD FLOORS, GRANITE COUNTER TOPS, SPACIOUS SHOWERS, NO BEHIND NEIGHBORS FOR PRIVACY ON BEAUTIFUL COVER PATIO, CUL-DE -SAC!! OVERSIZED BACKYARD, THIS HOME IS.' ,`Acres` = '0.2566' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '1960/Cypress' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 52 BLK 3 WORTHAM PARK SEC 3' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '11177' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '575' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'ADAM ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CY-FAIR HIGH SCHOOL' ,`SchoolMiddle` = 'ARNOLD MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Wortham Park Sec 03' ,`TaxAmount` = '7246' ,`TaxRate` = '2.341' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663708948' WHERE `Matrix_Unique_ID` = '210143813' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-10T11:42:45.100' ,`MLSNumber` = '61650467' ,`ListAgentFullName` = 'Martha Sanford' ,`ListOfficeName` = 'Sticks & Bricks Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.934446' ,`Longitude` = '-95.336686' ,`PhotoCount` = '12' ,`PostalCode` = '75862' ,`RoomCount` = '8' ,`ListPrice` = '379000.00' ,`Status` = 'Active' ,`StreetName` = 'High Meadow' ,`StreetNumber` = '52' ,`StreetSuffix` = '' ,`City` = 'Trinity' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2700' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This could be your Smart Dream Home nestled on a hilltop overlooking Westwood Shores golf course and one of the many ponds. NOTE: Custom quality tile, granite, moldings & trim, electric car terminal. From the covered front porch to the extensive covered back porch this beautiful home will meet all of your criteria. Home is approximately 2000 SF with no wasted space. Unique floor plan. Impressive 2 story entry. Open concept family room w/corner fireplace. Windows surround kitchen, breakfast & dining areas for natural light. Primary suite has trayed ceilings, crown molding. Executive bath w/double sinks, free standing soaking tub, oversized walk-in shower, large walk-in closets. Utility room w/sink & room for freezer and/or extra fridge. Staircase leads to unfinished bonus room. Plumbing & electricity is in place should you elect to finish it. Brick & stone on all exterior walls. Westwood Shores amenities include manned gate, golf course, tennis, pool, miniature golf, RV parking.' ,`Acres` = '0.1789' ,`Area` = '42' ,`BuilderName` = 'S & B Custom Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'WESTWOOD SHORES SECTION 04, BLOCK 65 LOT 06' ,`LotDesciption` = 'Cul-De-Sac,In Golf Course Community,Water View' ,`LotSize` = '7791' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2244' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '63 - Trinity' ,`SchoolElementary` = 'LANSBERRY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TRINITY HIGH SCHOOL (HEB)' ,`SchoolMiddle` = 'TRINITY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Westwood Shores' ,`TaxAmount` = '68' ,`TaxRate` = '2.6424' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663708948' WHERE `Matrix_Unique_ID` = '210325179' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-10T11:38:20.637' ,`MLSNumber` = '95491055' ,`ListAgentFullName` = 'Kourtney Scroggins' ,`ListOfficeName` = 'Designed Realty Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.091600' ,`Longitude` = '-95.189955' ,`PhotoCount` = '42' ,`PostalCode` = '77365' ,`RoomCount` = '11' ,`ListPrice` = '525000.00' ,`Status` = 'Active' ,`StreetName` = 'Majestic Harbor' ,`StreetNumber` = '5819' ,`StreetSuffix` = 'Lane' ,`City` = 'Kingwood' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3128' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this stunning Mediterranean villa nestled in the livable forest of Kingwood! Built by Ashton Woods, this home displays elegant upgrades. A rich space awaits you as you enter the custom wrought iron and glass door of your new home. A stunning foyer upon the entry showcases the formal dining. Two bedrooms share a jack and jill bathroom at the front of the home. Earth tones show off a modern, open-concept floor plan. Eleven foot ceilings truly make the space feel incredible! An oversized island is the focal point of your kitchen; inviting everyone to enjoy a space together at the heart of the home. A butler\'s pantry is featured as well as two walk-in pantries. The living room displays beautiful coffered ceilings. The primary suite is nestled at the rear of the home with a stunning bath. A guest suite is tucked at the rear of the home with an en-suite bath for guest privacy. This home is situated on an oversized lot, abundant enough for a large pool of your dreams!' ,`Acres` = '0.3135' ,`Area` = '32' ,`BuilderName` = 'Ashton Woods' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Kingwood East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 42 BLK 1 ROYAL BROOK AT KINGWOOD SEC 2' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '13655' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition,Tile' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'ELM GROVE ELEMENTARY SCHOOL (HUMBLE)' ,`SchoolHigh` = 'KINGWOOD PARK HIGH SCHOOL' ,`SchoolMiddle` = 'KINGWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Mediterranean' ,`Subdivision` = 'Royal Brook' ,`TaxAmount` = '10318' ,`TaxRate` = '2.5839' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663708949' WHERE `Matrix_Unique_ID` = '210488827' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-10T11:09:48.850' ,`MLSNumber` = '29767824' ,`ListAgentFullName` = 'Ava Gutowski' ,`ListOfficeName` = 'Key 2 Texas Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.990515' ,`Longitude` = '-95.323054' ,`PhotoCount` = '33' ,`PostalCode` = '77541' ,`RoomCount` = '5' ,`ListPrice` = '299000.00' ,`Status` = 'Active' ,`StreetName` = 'Elm' ,`StreetNumber` = '504' ,`StreetSuffix` = 'Street' ,`City` = 'Freeport' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1368' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful Waterfront Oyster Creek Home on 1/2 acre, Home has beautiful elevation and additional guest quarters with a shop! Fenced in back for pets! Large RV Awning. New Granite is on it\'s way for the Kitchen! This is a must see if you are wanting a Waterfront view, Shop and additional Guest quarters. The view and back yard offer serenity and peace. A great primary location to shop, get to the beach, boating and fishing!! PROPERTY HAS NEVER FLOODED!' ,`Acres` = '0.5378' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Freeport' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LINDA VISTA (A0009 B T ARCHER) (OYSTER CREEK) LOT 1-2' ,`LotDesciption` = 'Waterfront' ,`LotSize` = '23427' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'VELASCO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRAZOSPORT HIGH SCHOOL' ,`SchoolMiddle` = 'FREEPORT INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Linda Vista' ,`TaxAmount` = '4777' ,`TaxRate` = '2.2366' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663708949' WHERE `Matrix_Unique_ID` = '210849359' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-10T10:12:16.093' ,`MLSNumber` = '25756038' ,`ListAgentFullName` = 'Bradley Tiffan' ,`ListOfficeName` = 'Legend Home Corporation' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.830782' ,`Longitude` = '-95.805523' ,`PhotoCount` = '19' ,`PostalCode` = '77493' ,`RoomCount` = '6' ,`ListPrice` = '279990.00' ,`Status` = 'Active' ,`StreetName` = 'Deledda' ,`StreetNumber` = '3935' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1643' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Love where you live in Camillo Lakes in Katy, TX! The Sequoia floor plan is a spacious 2-story home with 3 bedrooms, 2.5 baths, and 2-car garage. This home has it all including blinds, upgraded carpeting in the bedrooms, and vinyl plank flooring throughout the first-floor common areas! The first floor offers the perfect space for entertaining a large kitchen island open to both the living and dining areas! The gourmet kitchen is sure to please with 42\" cabinetry, quartz countertops, and stainless steel appliances! Upstairs offers a split floor plan and private retreat for all bedrooms! Retreat to the Owner\'s Suite featuring double sinks, a sizable shower, and Texas-sized walk-in closet! Enjoy the great outdoors with full sod and a sprinkler system! Don\'t miss your opportunity to call Camillo Lakes home, schedule a visit today!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Legend Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 60 BLK 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2647' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '875' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'LEONARD ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Camillo Lakes' ,`TaxAmount` = '' ,`TaxRate` = '3.53' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663708949' WHERE `Matrix_Unique_ID` = '211430270' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-10T10:11:27.080' ,`MLSNumber` = '18951896' ,`ListAgentFullName` = 'Bradley Tiffan' ,`ListOfficeName` = 'Legend Home Corporation' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.830511' ,`Longitude` = '-95.805518' ,`PhotoCount` = '20' ,`PostalCode` = '77493' ,`RoomCount` = '6' ,`ListPrice` = '279990.00' ,`Status` = 'Active' ,`StreetName` = 'Deledda' ,`StreetNumber` = '3923' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1643' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Love where you live in Camillo Lakes in Katy, TX! The Sequoia plan is a spacious 2-story home with 3 bedrooms, 2.5 baths, and 2-car garage. This home has it all, including blinds, upgraded carpeting in the bedrooms, and vinyl plank flooring throughout the first-floor common areas! The first floor offers the perfect space for entertaining with a large kitchen island open to both the living and dining areas! The gourmet kitchen is sure to please with 42\" cabinetry, granite countertops, herringbone pattern backsplash, and stainless steel appliances! Upstairs offers a split floor plan and private retreat for all bedrooms! Retreat to the Owner\'s Suite featuring double sinks, a sizable shower, and Texas-sized walk-in closet! Enjoy the great outdoors with full sod and a sprinkler system! Don\'t miss your opportunity to call Camillo Lakes home, schedule a visit today!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'LEGEND HOMES' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 57 BLK 4 CAMILLO LAKES SEC 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2547' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '875' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'LEONARD ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'CAMILLO LAKES' ,`TaxAmount` = '' ,`TaxRate` = '3.53' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663708949' WHERE `Matrix_Unique_ID` = '211432876' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-10T11:07:21.650' ,`MLSNumber` = '33518808' ,`ListAgentFullName` = 'Ximena Anderson' ,`ListOfficeName` = 'Resident Realty, Ltd.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.461309' ,`Longitude` = '-95.541209' ,`PhotoCount` = '31' ,`PostalCode` = '77318' ,`RoomCount` = '3' ,`ListPrice` = '158900.00' ,`Status` = 'Active' ,`StreetName` = 'Black Gum' ,`StreetNumber` = '9755' ,`StreetSuffix` = '' ,`City` = 'Willis' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1000' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '//New construction// Fall in love with this beautiful single story 3 bedroom 2 bath home featuring an open floor plan, high ceilings, granite counters, kitchen island, self closing drawers/cabinets, 42\" upper cabinets, great walk-in-pantry and stainless steel package. Ample primary bedroom with private bath and large walk-in closet. The primary bath has a large shower that gives it a spa like feel. Laundry room is also nice sized too!!! All this at a very affordable price. Subdivision has great pool and playground.' ,`Acres` = '0.0482' ,`Area` = '39' ,`BuilderName` = '3-G Construction' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'WALNUT COVE 01, BLOCK 12, LOT 24' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2100' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '100' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'PARMLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'LYNN LUCAS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Walnut Cove' ,`TaxAmount` = '149' ,`TaxRate` = '1.8698' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663708949' WHERE `Matrix_Unique_ID` = '211531405' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-10T11:59:21.260' ,`MLSNumber` = '38827736' ,`ListAgentFullName` = 'Robert Wood' ,`ListOfficeName` = 'RE/MAX Integrity' ,`SellingAgentFullName` = 'John Smither' ,`SellingOfficeName` = 'Smither Company Real Estate' ,`Latitude` = '29.741873' ,`Longitude` = '-95.400420' ,`PhotoCount` = '24' ,`PostalCode` = '77006' ,`RoomCount` = '7' ,`ListPrice` = '575000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Hawthorne' ,`StreetNumber` = '1623' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1418' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Quintessential Montrose bungalow with 3 bedrooms/1 bath...located on a quiet picture perfect street in one of the most charming neighborhoods in Houston. This bungalow would not be complete without an inviting front porch. This amazing property has an open concept living room , dining room and kitchen with lots of storage that perfect for entertaining. Recent upgrades include energy efficient windows and A/C system(2021). Great size back yard and walking distance to shops and restaurants and minutes away from Downtown, the Galleria, River Oaks shopping center and the Medical center.' ,`Acres` = '0.1217' ,`Area` = '16' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Montrose' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 5 BLK 7 MANDELL PLACE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5300' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WOODROW WILSON MONTESSORI' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LANIER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Mandell Place' ,`TaxAmount` = '12800' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1930' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663708949' WHERE `Matrix_Unique_ID` = '211646450' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-10T11:12:51.510' ,`MLSNumber` = '7117795' ,`ListAgentFullName` = 'Bobby Thomas' ,`ListOfficeName` = 'World Wide Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.649920' ,`Longitude` = '-95.582615' ,`PhotoCount` = '30' ,`PostalCode` = '77477' ,`RoomCount` = '7' ,`ListPrice` = '335000.00' ,`Status` = 'Active' ,`StreetName` = 'Brook Meadows' ,`StreetNumber` = '11706' ,`StreetSuffix` = 'Lane' ,`City` = 'Meadows Place' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1819' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come see this charming 3 bedroom, 2 bath one-story home in the City of Meadows Place. Kitchen completely updated with quartz countertops, elegant & stylish backsplash, and new stainless steel farmhouse sink, microwave, and dishwasher. Freshly painted, newly laid LVP flooring w/ upgraded 5 inch wood baseboards. Primary bathroom updated with modern fixtures and quality designer tile in shower. Meadows Place has a lot to offer including tennis courts, parks, pools, discover & nature center, stocked lake with trout, & it\'s own Police Dept and EMS. Zoned to Ft Bend ISD and recently built, state of the art Meadows Elem School. Walking distance to Starbucks. Mins to premier shopping, restaurants, and entertainment. Quick access to I-69 and Beltway 8 and new 192-acre commercial development, the Grid. NO HOA! LOW TAXES!' ,`Acres` = '0.1191' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Stafford Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'MEADOWGLEN SEC 1, BLOCK 6, LOT 18' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5186' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'MEADOWS ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'DULLES HIGH SCHOOL' ,`SchoolMiddle` = 'DULLES MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Meadowglen' ,`TaxAmount` = '5197' ,`TaxRate` = '2.4949' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663708950' WHERE `Matrix_Unique_ID` = '211654896' --> 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','211722608','1663708950','211722608','2022-09-10T10:00:14.727','92030436','Lisa Roth','RE/MAX The Woodlands & Spring','','','30.225642','-95.452519','18','77385','10','350000.00','Active','Ramwind','174','Court','The Woodlands','2','1','4','2047','Single-Family','Gorgeous family home with beautiful yard in cul-de-sac. Home features many upgrades: Wood Laminate floors and tile in living areas, high ceilings, open floor plan, chef style island kitchen with 42\" cabinets and plenty of counter space open to great room featuring wall of windows to gaze at your oversized yard and custom deck. Large Primary bedroom and huge walk in closet, serene master bath. Game room up and great closets in secondary rooms. Don\'t miss this one - Call now for tour!','0.1682','15','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gas Connections','1','The Woodlands','Central Gas','0','WDLNDS HARPER\'S LND COLLEGE PK 05, BLOCK 2, LOT 20','Cul-De-Sac','7328','Appraisal District','','','0','','2','Electric Oven','0','','','Electric Range','','Composition','11 - Conroe','POWELL ELEMENTARY SCHOOL (CONROE)','THE WOODLANDS COLLEGE PARK HIGH SCHOOL','KNOX JUNIOR HIGH SCHOOL','Appointment Required,Leave Business Card,Lockbox Front','Appraisal District','2','Traditional','Wdlnds Harpers Lnd College Park','5163','2.2719','Water District','2002','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-10T10:37:58.090' ,`MLSNumber` = '94379059' ,`ListAgentFullName` = 'Rosie Gonzalez' ,`ListOfficeName` = 'Pinnacle Real Estate Holding' ,`SellingAgentFullName` = 'Maria Hernandez' ,`SellingOfficeName` = 'City Insight Houston' ,`Latitude` = '29.870968' ,`Longitude` = '-95.742509' ,`PhotoCount` = '24' ,`PostalCode` = '77449' ,`RoomCount` = '6' ,`ListPrice` = '285000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Verbena Blossom' ,`StreetNumber` = '6506' ,`StreetSuffix` = 'Trail' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1318' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Adorable starter home, Huge patio was added in back. No neighbor in back. Larger than average yard. Shows like model home. Interested in closing on home and renting back from buyer until Dec. 30, 2022.' ,`Acres` = '0.124' ,`Area` = '25' ,`BuilderName` = 'MI Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 18 BLK 1 LANTANA SEC 6' ,`LotDesciption` = 'Greenbelt,Subdivision Lot' ,`LotSize` = '5400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'WALKER ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CYPRESS PARK HIGH SCHOOL' ,`SchoolMiddle` = 'ROWE MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lantana' ,`TaxAmount` = '1377' ,`TaxRate` = '2.831' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663708950' WHERE `Matrix_Unique_ID` = '211745126' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-10T11:15:49.207' ,`MLSNumber` = '72992093' ,`ListAgentFullName` = 'Joe Forkner' ,`ListOfficeName` = 'Anne Willis Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.515451' ,`Longitude` = '-94.479590' ,`PhotoCount` = '17' ,`PostalCode` = '77617' ,`RoomCount` = '5' ,`ListPrice` = '752250.00' ,`Status` = 'Active' ,`StreetName` = 'Hwy 87' ,`StreetNumber` = '2416' ,`StreetSuffix` = '' ,`City` = 'Gilchrist' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '1' ,`SqFtTotal` = '1152' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Adorable 1 bedroom/ 1 bath Beachfront home located in Gilchrist. A second bedroom can be added. Would make a great rental property or full time living. Has great unobstructed views of the Gulf of Mexico.' ,`Acres` = '0.647' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Gilchrist' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 52 J DUNMAN SUR LOT 7 HOGANS LANDING UNRECORDED SUB' ,`LotDesciption` = 'Cleared,Water View,Waterfront' ,`LotSize` = '28183' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '25 - High Island' ,`SchoolElementary` = 'HIGH ISLAND ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HIGH ISLAND HIGH SCHOOL' ,`SchoolMiddle` = 'HIGH ISLAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Hogans Landing' ,`TaxAmount` = '4820' ,`TaxRate` = '1.5543' ,`WaterSewer` = 'Aerobic,Public Water' ,`YearBuilt` = '2011' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663708950' WHERE `Matrix_Unique_ID` = '211746349' --> 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','211746368','1663708950','211746368','2022-09-10T10:33:52.843','75318288','Jill Hamlin','Keller Williams Realty Austin','','','30.288426','-97.936091','37','78738','5','3000000.00','Active','Musket Rim','12129','Street','Austin','5','5','5','4507','Single-Family','12129 Musket Rim is a stunning property tucked away from the street for utmost privacy. Professionally landscaped yard with multiple sitting areas welcomes you to this certified green home. Upon entry you\'ll find large windows that let you take in the incredible canyon views as well as the pool, flat yard, fire pit and stocked neighborhood fishing pond. Open living, dining and kitchen areas all connect beautifully with multiple porches to make this home warm, welcoming and perfect for entertaining. Interior features include a planning/homework desk adjacent to the kitchen, 1200+ bottle wine room, exercise area within the primary suite and gorgeous windows throughout. In addition to the pool, outside you\'ll find the covered patio, fire pit, a gate accessing the fishing pond, outdoor shower and a perfect outdoor kitchen where you can take in the canyon views while you entertain. Solar panels keep electric bills incredibly low while low maintenance plants make landscaping a breeze.','1.0091','83','','','','','Other Disclosures,Sellers Disclosure','','','2','','Central Gas','1','LOT 12 BLK A SPANISH OAKS PHS II-B','Subdivision Lot','43956','Appraisal District','','1100','0','','3','','1','In Ground','','','','Other','115 - Lake Travis','LAKE POINTE ELEMENTARY SCHOOL (LAKE TRAVIS)','LAKE TRAVIS HIGH SCHOOL','BEE CAVE MIDDLE SCHOOL','Appointment Required,Request Online Appointment,Supra Keybox','Appraisal District','2','Traditional','Spanish Oaks','37679','2.1208','Water District','2007','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-10T11:42:07.630' ,`MLSNumber` = '3411028' ,`ListAgentFullName` = 'Ava Gutowski' ,`ListOfficeName` = 'Key 2 Texas Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.799068' ,`Longitude` = '-95.650486' ,`PhotoCount` = '41' ,`PostalCode` = '77414' ,`RoomCount` = '3' ,`ListPrice` = '579000.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 291' ,`StreetNumber` = '1933' ,`StreetSuffix` = '' ,`City` = 'Sargent' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1800' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Waterfront at It\'s Best With a Breathtaking View!! Open Concept and Large Windows Bring in Natural Lighting! Recently Remodeled and Updated in the Best of Coastal Colors!! The Kitchen Features Undermount Lighting, Soft Close Cabinets, Recent Appliances, Beautiful Breakfast Bar & More! Recent Roof & Siding July 2021, Recent Dock/Pier, Live Feed Security System Installed with Automated Alert. Fully Furnished (with personal exceptions)\r\nThis Coastal Home has a Great Location for Fishing, Crabbing and getting to the Cut of East Matagorda Bay!! Private Subdivision Boat Launch! Sargent Beach Within a Few Miles, Restaurants, Bait Shops!!' ,`Acres` = '0.461' ,`Area` = '54' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'CANEY CREEK HAVEN SEC 4, BLOCK 1, LOT 21' ,`LotDesciption` = 'Waterfront' ,`LotSize` = '20081' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '175' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '134 - Van Vleck' ,`SchoolElementary` = 'VAN VLECK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'VAN VLECK HIGH SCHOOL' ,`SchoolMiddle` = 'O H HERMAN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Caney Creek Haven Sec 4' ,`TaxAmount` = '5482' ,`TaxRate` = '2.3895' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1985' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663708950' WHERE `Matrix_Unique_ID` = '211772907' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-10T10:48:07.497' ,`MLSNumber` = '19416505' ,`ListAgentFullName` = 'Matt Chauvin' ,`ListOfficeName` = 'Keller Williams Metropolitan' ,`SellingAgentFullName` = 'Steve Anton' ,`SellingOfficeName` = 'Hallmark Properties, Inc.' ,`Latitude` = '29.690099' ,`Longitude` = '-95.488367' ,`PhotoCount` = '37' ,`PostalCode` = '77081' ,`RoomCount` = '3' ,`ListPrice` = '379000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Edith' ,`StreetNumber` = '5602' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2290' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Wonderful corner lot located in the heart of the original Maplewood. Only 2nd owner--raised family here-- meticulously taken care over the years. Huge primary bedroom! 2 living areas plus dining room; off the den is a reading/study nook. Spacious kitchen.Wood floors in the formal rooms. Replaced electrical service panel. Foundation recently repaired. Roof barley warn. Was updated in the 90\'s. Oversized detached garage, connecting to home by large breezeway. Large treed backyard with patio including the wooded-front yard that wraps around the property. This home was never touched by floodwaters so buy with confidence.' ,`Acres` = '0.2057' ,`Area` = '17' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate,No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Meyerland Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 10 BLK 5 MAPLEWOOD SEC 7' ,`LotDesciption` = 'Corner' ,`LotSize` = '8960' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BRAEBURN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BELLAIRE HIGH SCHOOL' ,`SchoolMiddle` = 'LONG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Maplewood Sec 07' ,`TaxAmount` = '7498' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1958' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663708950' WHERE `Matrix_Unique_ID` = '211926330' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-10T10:12:47.213' ,`MLSNumber` = '48066464' ,`ListAgentFullName` = 'Bradley Tiffan' ,`ListOfficeName` = 'Legend Home Corporation' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.831087' ,`Longitude` = '-95.805244' ,`PhotoCount` = '26' ,`PostalCode` = '77493' ,`RoomCount` = '4' ,`ListPrice` = '259990.00' ,`Status` = 'Active' ,`StreetName` = 'Landolfi' ,`StreetNumber` = '24926' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1311' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Love where you live in Camillo Lakes in Katy, TX! The Butler floor plan is a charming 2-story home with 3 bedrooms, 2.5 bathrooms, and 2-car garage! This home has it all - including blinds, upgraded carpeting in the bedrooms, and vinyl plank flooring throughout the first floor common areas! The first floor offers the perfect entertainment space with a large kitchen overlooking the family room! The gourmet kitchen is sure to please with 42\" cabinets and granite countertops! Retreat to the Owner\'s Suite featuring double sinks, a sizable shower, and spacious walk-in closet! Enjoy the great outdoors with full sod and a sprinkler system! Don\'t miss your opportunity to call Camillo Lakes home, schedule a visit today!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Legend Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 65 BLK 1 Sec 6' ,`LotDesciption` = 'Greenbelt,Subdivision Lot' ,`LotSize` = '2640' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '875' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'LEONARD ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Camillo Lakes' ,`TaxAmount` = '' ,`TaxRate` = '3.53' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663708950' WHERE `Matrix_Unique_ID` = '211941396' --> 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','212103159','1663708950','212103159','2022-09-10T10:58:14.767','53501672','Jennifer Hurst','KJ Platinum Properties LLC','','','29.131584','-95.061389','4','77554','5','650000.00','Active','Miramar','23118','Circle','Galveston','2','1','3','1696','Single-Family','This view could be yours at this Fabulous new construction home with unobstructed water views. 3 Bedrooms with 2 and 1/2 bathrooms. This new home sits on a cul-de-sac lot that backs up to protected wetlands. Awesome views from the 400 Square foot deck. This home is still under construction with an estimated completion date for the end of September. Check out the views from the bedroom upstairs. Only 5 minutes to the beach. Also near the community pool and pier. A must see in this popular neighborhood on the West End of Galveston.\r\nShort term rentals allowed.','0.1409','33','DSW','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','West End','Central Electric','1','TERRAMAR COVE (2009) ABST 121, LOT 7, ACRES 0.141','Subdivision Lot','6137','Appraisal District','','350','1','Never Lived In','0','Electric Oven','0','','','Electric Range','','Composition','22 - Galveston','GISD OPEN ENROLL','BALL HIGH SCHOOL','GISD OPEN ENROLL','Appointment Required,Leave Business Card,Lockbox Front','Builder','2','Traditional','Terramar Cove 2009','711','2.0324','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','212252504','1663708951','212252504','2022-09-10T10:53:59.257','24809430','James Hammond','Keller Williams Realty','','','31.353394','-96.307167','41','77865','3','569000.00','Active','County Road 374','6035','','Marquez','3','0','3','2253','Single-Family','Whether you want to live on the lake or have a getaway home on the water, we have the perfect place for you! Nestled amongst the trees in the TC Acres subdivision on the east side of Lake Limestone, this 3-bedroom, 3-bathroom home boasts large windows for natural light and beautiful views of the lake. In the home, you will find tall vaulted ceilings in the living room, granite countertops in the kitchen, and large bedrooms. The master bedroom has a spacious ensuite bathroom and a walk-in closet. Off of the master bedroom is an oversized outdoor balcony that overlooks the lake. Outside the home, you will find a huge outdoor covered patio that has plenty of room for entertaining. In addition, there\'s a 2-car garage/shop, 3 storage closets on the patio, a metal roof, and a gated entrance.','0.49','63','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','Wood Burning Fireplace','1','Buffalo Area','Central Electric','0','T C ACRES 2-WF BLK 2 LT 71 .49 AC AB 19 M C REJON','Subdivision Lot,Waterfront','21344','Appraisal District','','','0','','2','','0','','','Electric Range','','Aluminum','195 - Leon','LEON ELEMENTARY SCHOOL','LEON HIGH SCHOOL','LEON JUNIOR HIGH SCHOOL','Lockbox Front','Appraisal District','2','Traditional','T C Acres','3687','1.6365','Aerobic,Public Water','1988','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','212294049','1663708951','212294049','2022-09-10T10:35:42.637','85784145','Mazna Ayub','Texas United Realty','','','29.571477','-95.411668','38','77584','10','494000.00','Active','Coral Cove','12401','Court','Pearland','3','1','5','3538','Single-Family','Outstanding 2 story home with front porch, rich Brazilian hardwood floors. Granite in the kitchen and all bathrooms, high ceilings. Wrought Iron railings, hardwood stairway. Master suite downstairs. Upstairs large Game Room and a separate Media Room. Sprinkler system, crown moldings, designer walls. New Laminate flooring on the first floor, new paint all over, new stove, freshly painted Garage. All new lights and chandeliers. New faucets and new Kitchen sinks and faucets. Upgraded high efficiency AC system with commercial grade air filtration and UV antimicrobial lighting. Large backyard with stone patio. \r\nHardwired DVR for commercial grade security cameras for 24/7 monitoring and recording on any mobile device.\r\nFridge, washer/dryer can be negotiated in the sale. Must see!','0.1994','5','','','','','No Disclosures','1','','1','Pearland','Central Gas','1','SHADOW CREEK RANCH SF20A (PEARLAND) , BLOCK 3, LOT 4','Cul-De-Sac','8686','Appraisal District','','995','0','','2','','0','','','','','Composition','3 - Alvin','WILDER ELEMENTARY SCHOOL','SHADOW CREEK HIGH SCHOOL','NOLAN RYAN JUNIOR HIGH SCHOOL','Appointment Required,Lockbox Left Side','Appraisal District','2','Traditional','Shadow Creek Ranch Sf1-Sf2-Sf3','','','Public Sewer,Public Water','2005','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','212352199','1663708951','212352199','2022-09-10T11:57:16.537','81713301','Bobbie Alexander','Alexander Properties','','','29.907366','-95.751937','5','77433','12','746982.00','Active','Greystanes Grove','21639','Lane','Cypress','4','1','4','3506','Single-Family','MLS# 81713301 February Completion! The Topaz in Avalon at Cypress offers a beautiful entry with a study and media room right off the foyer. The kitchen overlooks the large gathering room and casual dining space, which easily connects to the outdoor covered living area.. Double doors in the bedroom open to the owner’s bath which includes dual sinks, large shower, garden tub, linen closet and a private commode. The laundry/utility room is off the owner’s entry for added convenience. An additional bedroom with a full bath downstairs is perfect for company. Upstairs you will find two secondary bedrooms along with a game room, perfect for family game nights. Structural options include: 12” pop-up ceiling at game room, drop in tub at owner’s bath, study, extended owner’s suite an covered outdoor living 1, interior 8’ doors on first floor, 12 x 8 sliding glass door, fireplace.','0.167','25','Taylor Morrison','','Electric Dryer Connections,Washer Connections','','Mud','1','Gas Connections','1','Cypress South','Central Gas','1','Lot 13, Block 1, Of Avalon at Cypress Section 3','Subdivision Lot','','Survey','','1200','1','To Be Built/Under Construction','3','Electric Oven,Single Oven','0','','','Gas Range','','Composition','13 - Cypress-Fairbanks','WALKER ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)','CYPRESS PARK HIGH SCHOOL','SMITH MIDDLE SCHOOL (CYPRESS-FAIRBANKS)','Appointment Required,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied','Builder','2','Contemporary/Modern','Avalon at Cypress 60\'s','','3.59','Water District','2023','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','212371506','1663708951','212371506','2022-09-10T10:31:32.850','79672196','Kyle Pryor','Pryor Properties','','','30.404092','-95.623945','30','77356','6','404000.00','Active','Happy Hollow','3805','','Montgomery','2','1','4','2258','Single-Family','New home construction! 4 bedroom, 2.5 bath, 3 car garage plus gameroom and large covered back porch. Kitchen includes granite countertops, stainless steel electric range/oven and microwave. Wood plank tile throughout main living areas. Located in beautiful Walden on Lake Conroe, subdivision amenities include community pools, gym, tennis courts, pickle ball courts, two boat ramps, dog park, community parks for all ages, walking trails and restaurant options. Low taxes and zoned to exemplary rated Montgomery ISD schools.','','39','Camillo Homes','','Electric Dryer Connections,Washer Connections','','Mud','1','Wood Burning Fireplace','1','Lake Conroe Area','Central Electric','1','Block 69, Lot 197','In Golf Course Community,Subdivision Lot','','','','1050','1','To Be Built/Under Construction','3','Electric Oven','0','','','Electric Cooktop','','Composition','37 - Montgomery','MADELEY RANCH ELEMENTARY SCHOOL','MONTGOMERY HIGH SCHOOL','MONTGOMERY JUNIOR HIGH SCHOOL','Supra Keybox','Builder','2','Traditional','Walden on Lake Conroe','','','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','212376164','1663708951','212376164','2022-09-10T11:53:43.850','32422587','Susan Stahley','Walzel Properties','','','30.074432','-95.565014','34','77375','10','545000.00','Active','Castlehead','9322','Drive','Tomball','3','1','4','3905','Single-Family','Gorgeous Village Builders Home on Oversized Lot. Recently Remodeled and Ready for Move In. New High End Carpet. New Paint. New Oven, Dishwasher and Microwave. New Lighting in Entry, Formal Dining, Kitchen & Bathrooms. Wood Floors in Family Room, Master Bedroom, Master Closet and Office. Updated Shower, Flooring and Granite in Master Bath. Tile Flooring in Kitchen, Family Room, and Formal Dining. Granite in All Secondary Bathrooms. Double Sink in Secondary Bath. Huge Game Room. Large Bedrooms and Great Closets. Fabulous Kitchen with Large Island, Breakfast Bar and a Planning Desk. Fantastic Backyard with Tons of Room For Kids to Play and Plenty of Room for a Pool. Only a Short Walk Right Around the Corner to Neighborhood Park with Swings, Pool, Tennis Courts, Walking Trails and Catch Release Ponds. Zoned to Highly Sought after Klein ISD with Easy Access to Grand Parkway (99), Shopping, Dining & Entertainment. This is a MUST SEE!','0.2298','14','Village Builders','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Exclusions,Owner/Agent,Sellers Disclosure','1','Gas Connections','1','Spring/Klein/Tomball','Central Gas','1','LT 12 BLK 3 INVERNESS ESTATES SEC 2','Wooded','10012','Appraisal District','','800','0','','3','Electric Oven,Single Oven','0','','','Gas Cooktop','','Composition','32 - Klein','MAHAFFEY ELEMENTARY SCHOOL','KLEIN CAIN HIGH SCHOOL','KRIMMEL INTERMEDIATE SCHOOL','Appointment Required,Lockbox Front','Appraisal District','2','Traditional','Inverness Estates Sec 02','9900','3.0565','Public Sewer,Public Water','2006','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','212387459','1663708951','212387459','2022-09-10T11:29:53.220','89495755','Jared Morgan','Realty ONE Group, Experience','','','30.183540','-95.784480','29','77355','5','665000.00','Active','HIGH MEADOW PRESERVE','25639','Court','Magnolia','2','1','3','2589','Single-Family','Beautifully crafted ranch style home by Masterson Homes. This 3 bed 2 bath home in a quiet community of just 50 homes is the home you have been looking for! From soaring ceilings with warm wood beam accents to the open floor plan this home is a must see for the client that is looking for a quiet Acerage community. The kitchen is a chefs dream with plenty of counter space and gorgeous walk in pantry with quartz countertops. The primary suite is where this home truly shines. A bathroom designed for ultra spa relaxation with soaking tub and double entry walk in shower. The primary closet is every woman’s dream. Access to aggieland expressway only 7 mins from the community with multiple shopping centers & restaurants coming soon.','1','15','Masterson Homes','','','','No Disclosures','1','','','Magnolia/1488 West','Central Gas','1','S582250 - High Meadow Preserve, BLOCK 1, Lot 47','Subdivision Lot,Wooded','43961','Appraisal District','','500','1','Never Lived In','2','','0','','','','','Composition','36 - Magnolia','WILLIE E. WILLIAMS ELEMENTARY SCHOOL','MAGNOLIA WEST HIGH SCHOOL','MAGNOLIA JUNIOR HIGH SCHOOL','Accompany,Appointment Required,Leave Business Card,Vacant/Unoccupied','Builder','1','Contemporary/Modern,Ranch','The Preserve','','','Aerobic','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','212388808','1663708951','212388808','2022-09-10T11:48:50.150','23317659','Carrie Farmer','All City Real Estate, Ltd. Co.','','','29.594452','-96.336704','27','77434','8','189900.00','Active','Pendleton','607','Street','Eagle Lake','1','0','3','2063','Single-Family','Quaint 2 bedroom, 1 Bath home with a converted garage as an optional 3rd bedroom. This home features a spacious living room with wood plank ceilings, open kitchen with walk in pantry. Step out into backyard to see a large patio perfect for entertaining. The home has a BRAND NEW 30 year roof, NEW TRIPLE PAINE WINDOWS and a NEW 200 AMP ELECTRICAL.','0.2359','56','N/A','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','0','','0','','Central Gas,Heat Pump,Wall Heater,Window Unit','0','BLK 20 LT 2C EAGLE LAKE & HOUSE','Other','10277','Appraisal District','','','0','','0','Convection Oven,Double Oven,Electric Oven,Freestanding Oven','0','','','Electric Range,Freestanding Range','','Composition','161 - Rice Consolidated','EAGLE LAKE INTERMEDIATE SCHOOL','RICE HIGH SCHOOL (RICE CISD)','RICE JUNIOR HIGH SCHOOL (RICE CISD)','Appointment Required,Lockbox Front','Appraisal District','1','Traditional','N/A','','','Public Sewer,Public Water','1941','Appraisal District'); --> New record created successfully