Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T20:29:54.577' ,`MLSNumber` = '10604463' ,`ListAgentFullName` = 'Laolu Yemitan' ,`ListOfficeName` = 'Five Woods Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.664936' ,`Longitude` = '-95.370251' ,`PhotoCount` = '24' ,`PostalCode` = '77051' ,`RoomCount` = '4' ,`ListPrice` = '135900.00' ,`Status` = 'Active' ,`StreetName` = 'Comal' ,`StreetNumber` = '8821' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '816' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Super cute bungalow featuring an open floorplan with two bedrooms, one shared bathroom, large living room, and flexible open space for breakfast or dining area. Property located on large lot with plenty of yard space. Live in now and expand existing footprint or develop later.' ,`Acres` = '0.1596' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Medical Center South' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = 'S 1/2 OF LT 2 BLK G SUNNYSIDE EXTENSION SOUTH' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6950' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'YOUNG ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WORTHING HIGH SCHOOL' ,`SchoolMiddle` = 'ATTUCKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sunnyside Ext South' ,`TaxAmount` = '1599' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669652333' WHERE `Matrix_Unique_ID` = '207529975' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T20:07:11.893' ,`MLSNumber` = '57962337' ,`ListAgentFullName` = 'Wesley Wilson' ,`ListOfficeName` = 'JPAR - The Sears Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.898064' ,`Longitude` = '-95.646128' ,`PhotoCount` = '30' ,`PostalCode` = '77095' ,`RoomCount` = '7' ,`ListPrice` = '350000.00' ,`Status` = 'Active' ,`StreetName` = 'Pinyon Creek' ,`StreetNumber` = '15807' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2136' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This unique split-level in Copperfield Middlegate Village is ready for your personal touches. Situated on a large lot backing up to the greenbelt and creek, this home features mature trees in the front and oversized fenced backyard. You\'ll love the privacy offered by the split-level plan boasting a formal living room with fireplace and primary bedroom suite on the first floor. The main living space and enormous secondary bedrooms fill the second floor. You\'ll love the updated kitchen with custom cabinets and quartz countertops all open to the massive family room. The breakfast area opens to a balcony overlooking the giant back yard. You\'ll have room for everything with all bedrooms large enough for king sized beds and full furniture sets. Bring your own style and color pallet to make this home yours. Just steps from Middlegate Park. Labay Middle School and Fiest Elementary are right in the neighborhood!' ,`Acres` = '0.1926' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Copperfield Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 21 BLK 58 COPPERFIELD MIDDLEGATE VILLAGE SEC 2' ,`LotDesciption` = 'Greenbelt,Subdivision Lot' ,`LotSize` = '8390' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '715' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'FIEST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'LABAY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Split Level,Traditional' ,`Subdivision` = 'Copperfield Middlegate Village' ,`TaxAmount` = '4650' ,`TaxRate` = '2.3216' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1984' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669652333' WHERE `Matrix_Unique_ID` = '210113039' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T19:10:48.743' ,`MLSNumber` = '51595508' ,`ListAgentFullName` = 'Janell Callihan' ,`ListOfficeName` = 'Keller Williams Woodlands' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.559405' ,`Longitude` = '-95.620027' ,`PhotoCount` = '50' ,`PostalCode` = '77340' ,`RoomCount` = '6' ,`ListPrice` = '350000.00' ,`Status` = 'Active' ,`StreetName` = 'Hunters Creek' ,`StreetNumber` = '86' ,`StreetSuffix` = 'Drive' ,`City` = 'Huntsville' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1434' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Cozy log cabin style 2/2/1 waterfront log home on N. Lake Conroe located in the sought-after, gated community of Wildwood Shores. This updated home is bordered by the Sam Houston National Forest and has a screened-in back porch overlooking the lake & forest where you can watch the fish & wildlife! Stone fireplace. Primary ensuite is downstairs; full bath, spacious secondary bedroom & 2 roomy open alcove spaces are upstairs. Separate 1-car garage.\r\nRecent updates include wood-look tile flooring on the first floor, carpet on the stairs and 2nd floor; granite counters, backsplash, wood cabinets, a bank of drawers w/counter space, fixtures, ceiling fans, extra electrical box, septic, screened-in back porch. Home was only used occasionally on weekends. Sleeps 13 comfortably. You can enjoy this amazing property as a get-away vacation home or you can choose to live here year-round! No Air B&B. 18 minutes from the city of Huntsville, 30 minutes from The Woodlands and 60 minutes from Houston.' ,`Acres` = '0.2824' ,`Area` = '43' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'WILDWOOD SHORES (SEC 2), BLOCK 2, LOT 41' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot,Water View,Waterfront,Wooded' ,`LotSize` = '12302' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '891' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '64 - Huntsville' ,`SchoolElementary` = 'SAMUEL W HOUSTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HUNTSVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'MANCE PARK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Wildwood Shores Sec 2' ,`TaxAmount` = '4483' ,`TaxRate` = '1.7534' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669652334' WHERE `Matrix_Unique_ID` = '210668851' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T20:01:48.127' ,`MLSNumber` = '37906038' ,`ListAgentFullName` = 'Charisse Conover' ,`ListOfficeName` = 'C & S Premier Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.460028' ,`Longitude` = '-95.558967' ,`PhotoCount` = '48' ,`PostalCode` = '77318' ,`RoomCount` = '8' ,`ListPrice` = '875000.00' ,`Status` = 'Active' ,`StreetName` = 'Cozy Cove' ,`StreetNumber` = '15120' ,`StreetSuffix` = 'Lane' ,`City` = 'Willis' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2502' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Your waterfront dream awaits you! Situated in a cove with an open water view of Lake Conroe, sits a gated three bedroom two and a half bath stone faced home that has barley been lived in. The home sits on approximately half of an acre of lush green grass and beautiful mature trees. From the moment you walk past the high ceiling entry, the view will take your breath away. The glass lined living space boats Pell windows that sets a tone for wanting to sit back and relax. There are two full kitchens- one that provides a scenic look of the water while cooking, the other is perfect for meal prepping for the big meals. At the water, you\'ll find two boat slips, one containing a boat a lift. The area around the boat house and bulk head have been dredged for deep water access. This home sets the mood for vacation, full time occupancy, and short terms rentals are allowed. You will quickly find yourself wanting to grab a fishing pole and stay. The home will also convey with all the contents seen!' ,`Acres` = '0.5751' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LAKE CONROE HEIGHTS 01, BLOCK 1, LOT 13,14' ,`LotDesciption` = 'Cleared,Waterfront' ,`LotSize` = '25050' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '35' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'PARMLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'LYNN LUCAS MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Right Side,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Lake Conroe Heights 01' ,`TaxAmount` = '11069' ,`TaxRate` = '1.8448' ,`WaterSewer` = 'Aerobic,Septic Tank,Well' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669652334' WHERE `Matrix_Unique_ID` = '211393657' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T20:17:41.990' ,`MLSNumber` = '29512647' ,`ListAgentFullName` = 'Judy Langston' ,`ListOfficeName` = 'Nacol Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.616443' ,`Longitude` = '-95.022661' ,`PhotoCount` = '31' ,`PostalCode` = '77331' ,`RoomCount` = '4' ,`ListPrice` = '59900.00' ,`Status` = 'Active' ,`StreetName` = 'Janning' ,`StreetNumber` = '781' ,`StreetSuffix` = 'Street' ,`City` = 'Coldspring' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'One of Best Values in San Jacinto County. Has two metal outbuilding, Garage/Workshop. Bathroom in one of metal buildings. Huge beautiful Mature trees. Three lots on Janning Street under chain link fencing. Trinity River at one end of road and Lake Livingston Dam at other end. Private boat ramp for property owner\'s only into Trinity River and can launch your boat free into Lake Livingston at nearby Marina if you pay your maintenance fee. Large country kitchen with lots of cabinet space, One large bath in house has tub w/shower as well as bath in workshop with shower. Front and Back Stairs with covered porches. One car garage plus carport. One of best buys in County.' ,`Acres` = '0.48' ,`Area` = '64' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = 'Lots 1043, 1044 & 1045 Camilla Twin Harbors, Sec. 4' ,`LotDesciption` = 'Cleared,Subdivision Lot,Wooded' ,`LotSize` = '20996' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '96' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '101 - Coldspring-Oakhurst Consolidated' ,`SchoolElementary` = 'JAMES STREET ELEMENTARY SCHOOL' ,`SchoolHigh` = 'COLDSPRING-OAKHURST HIGH SCHOOL' ,`SchoolMiddle` = 'LINCOLN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = '' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Camilla Twin Harbors' ,`TaxAmount` = '429' ,`TaxRate` = '1.6254' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669652334' WHERE `Matrix_Unique_ID` = '211406741' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T19:09:58.543' ,`MLSNumber` = '82307687' ,`ListAgentFullName` = 'Kathy Carlisle' ,`ListOfficeName` = 'RCR Properties Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.058019' ,`Longitude` = '-95.445386' ,`PhotoCount` = '32' ,`PostalCode` = '77566' ,`RoomCount` = '12' ,`ListPrice` = '355000.00' ,`Status` = 'Active' ,`StreetName` = 'Arrowwood' ,`StreetNumber` = '129' ,`StreetSuffix` = 'Street' ,`City` = 'Lake Jackson' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3068' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to beautiful 129 Arrowwood in Lake Jackson!-best of both- country living, but minutes away shopping, restaurants. Walk in the formal dinning /study and a oversize family room with a gas/log fire place. With a breakfast nook and a nice size kitchen with plenty of cabinets . This kitchen has so much charm with painted knobs on a few of the knobs and the walk in pantry with a glass door to see what\'s waiting for you .Huge primary bedroom and a En -suite bath with a touch of vintage style. Walk upstairs and find a oversize game room to make memories for all the entertaining you can do. Three bedrooms upstairs and extra room in the closets. This Tanglewood neighborhood is tucked away with all the mature trees and runs along Oyster Creek. Splash in your pool at the end of the day! Want last long and quickly make your appt. New windows all through out this entire beautiful home.' ,`Acres` = '0.3927' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Jackson' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TANGLEWOOD SEC 4 (LAKE JACKSON), BLOCK 10, LOT 15' ,`LotDesciption` = 'Water View,Waterfront' ,`LotSize` = '17106' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'BRANNEN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRAZOSWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'LAKE JACKSON INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,No Photos/No Videos,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Tanglewood Lake Jackson' ,`TaxAmount` = '7618' ,`TaxRate` = '2.3371' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1981' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669652334' WHERE `Matrix_Unique_ID` = '211422224' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T20:42:53.710' ,`MLSNumber` = '98073062' ,`ListAgentFullName` = 'Tonya Brown' ,`ListOfficeName` = 'Compass RE Texas, LLCKaty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.947223' ,`Longitude` = '-95.677659' ,`PhotoCount` = '38' ,`PostalCode` = '77433' ,`RoomCount` = '8' ,`ListPrice` = '489900.00' ,`Status` = 'Active' ,`StreetName` = 'Streamertail' ,`StreetNumber` = '11750' ,`StreetSuffix` = 'Circle' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2788' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home to Alder Trails. This home has been well-maintained and rivals new construction in the area. The decorative brick / stone elevation with soffit lighting and covered front porch invites you to enter the foyer with high ceilings, a formal dining and open passage to the kitchen. The large kitchen / breakfast room feature an open concept and the family room offers a high wall of windows, great natural light and a gas log fireplace. The primary bedroom is down and boasts a well-appointed en suite. There’s also a powder bathroom on the main floor. Upstairs you’ll find 2 additional bedrooms, 2 full bathrooms, a media room with surround sound pre-wire (in lieu of the 4th bed opt) and ovesized game room. Situated on an oversized semi-corner lot with no rear neighbors, a spacious but private backyard and extended covered patio are ready to host your favorite recreational activities or just to relax. The community amenities and top rated elementary school are a short walk away.' ,`Acres` = '0.159' ,`Area` = '25' ,`BuilderName` = 'Taylor Morrison' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1 BLK 1 ALDER TRAILS SEC 4' ,`LotDesciption` = 'Cleared,Corner,Subdivision Lot' ,`LotSize` = '6924' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'WOODARD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'SPILLANE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Alder Trails Sec 4' ,`TaxAmount` = '8839' ,`TaxRate` = '2.711' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669652335' WHERE `Matrix_Unique_ID` = '211792712' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T20:01:52.837' ,`MLSNumber` = '22447782' ,`ListAgentFullName` = 'Roxie Krisher Hippard' ,`ListOfficeName` = 'Krisher-McKay, Inc., REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.812344' ,`Longitude` = '-94.838595' ,`PhotoCount` = '30' ,`PostalCode` = '77523' ,`RoomCount` = '7' ,`ListPrice` = '278000.00' ,`Status` = 'Active' ,`StreetName` = 'Barron' ,`StreetNumber` = '5422' ,`StreetSuffix` = 'Road' ,`City` = 'Cove' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1782' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great one story home with open floorplan on a corner lot. Large breakfast room opens into the kitchen. Granite countertops. Breakfast bar. High ceilings. Oversized living room. Work from home in your own study with French doors or let the kids enjoy a play room or gameroom. Indoor utility room. Gunite pool.' ,`Acres` = '0.231' ,`Area` = '53' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Chambers County West' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 11 BK 7 JOSEPHS COVE SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10062' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '325' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '6 - Barbers Hill' ,`SchoolElementary` = 'BARBERS HILL SOUTH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BARBERS HILL HIGH SCHOOL' ,`SchoolMiddle` = 'BARBERS HILL SOUTH MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Joseph\'s Cove Sec 3' ,`TaxAmount` = '3795' ,`TaxRate` = '1.7058' ,`WaterSewer` = 'Other Water/Sewer,Public Sewer' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669652335' WHERE `Matrix_Unique_ID` = '212090180' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T20:15:13.263' ,`MLSNumber` = '36508799' ,`ListAgentFullName` = 'Deb Ambrosi' ,`ListOfficeName` = 'Ambrosi Realty INC.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.705785' ,`Longitude` = '-95.873164' ,`PhotoCount` = '42' ,`PostalCode` = '77441' ,`RoomCount` = '6' ,`ListPrice` = '415000.00' ,`Status` = 'Active' ,`StreetName` = 'Hickory Manor' ,`StreetNumber` = '29006' ,`StreetSuffix` = 'Lane' ,`City` = 'Fulshear' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1801' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Excellent ALMOST NEW BUILD opportunity in coveted Bonterra at Cross Creek! Popular SABLEWOOD Floor plan on corner lot with many upgraded features including: PLANTATION SHUTTERS THROUGHOUT, STUDY, EXTENDED COVERED PATIO, LIGHTING, BAY WINDOW IN PRIMARY, CABINET HARDWARE + GORGEOUS FLOORING. This floor plan features a wide open common areas inside and an EXTENDED PATIO is optimal for entertaining or simply relaxing, inside and outside. Roomy open concept kitchen features an upgraded granite island, stainless appliances and step-in pantry. Owner\'s suite is privately tucked away and includes a large bath with dual sinks, large shower plus a walk-in closet that is unusually spacious and plenty of room for extensive wardrobe. Bonterra is a 55+community for buyers ready to take advantage of RESORT STYLE LIVING! This is truly a like NEW HOME as it was not lived in, without waiting for new build completion! CALL TODAY FOR A TOUR OF THE HOME AND CLUBHOUSE.' ,`Acres` = '0.1534' ,`Area` = '30' ,`BuilderName` = 'Taylor Morrison' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'BONTERRA AT CROSS CREEK RANCH SEC 5, BLOCK 3, LOT 21' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '6684' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2925' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'HUGGINS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Bonterra At Cross Creek Ranch' ,`TaxAmount` = '1201' ,`TaxRate` = '3.3362' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669652335' WHERE `Matrix_Unique_ID` = '212430689' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T19:56:08.227' ,`MLSNumber` = '54027416' ,`ListAgentFullName` = 'Christy Buck' ,`ListOfficeName` = 'Infinity Real Estate Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.419483' ,`Longitude` = '-95.436850' ,`PhotoCount` = '50' ,`PostalCode` = '77583' ,`RoomCount` = '9' ,`ListPrice` = '1950000.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 758' ,`StreetNumber` = '2510' ,`StreetSuffix` = '' ,`City` = 'Rosharon' ,`BathsFull` = '5' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3039' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Country living on 20 acres! The one story primary home features 3 bedrooms and 3 1/2 bath, plus office. Secondary rooms have their own private restrooms. Kitchen has commercial KitchenAid appliances that will stay. 12 foot ceilings, stained concrete floors, wired camera system, granite countertops, solar screens on windows. 5800 + SQ FT Shop features a beautifully finished 1 bedroom, 1.5 bathroom apartment. Apt Kitchen has granite counter top and black stainless steel appliances that will stay. The shop has six 12\' x 12\' overhead doors. Shop also has a half bathroom and upstairs storage loft. Pool is surrounded by cool decking, pool house has air conditioned full restroom and dog bath. Irrigation system on trees w/ timers. Property features a Generac generator, 3 stall dog kennel w/ automatic water system and concrete trough, 7 foot privacy fence around pool area, stocked pond with dedicated well. 3-stall horse barn w/ tack and feed room.' ,`Acres` = '20' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'A0512 HT & BRR TR 452-452A ACR 10.0 & TR 453 ACR 10.0' ,`LotDesciption` = 'Other' ,`LotSize` = '871200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'H T & B R R' ,`TaxAmount` = '9296' ,`TaxRate` = '2.2507' ,`WaterSewer` = 'Aerobic' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669652335' WHERE `Matrix_Unique_ID` = '212431786' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T19:49:37.380' ,`MLSNumber` = '4374505' ,`ListAgentFullName` = 'Mary Pendleton-Brown' ,`ListOfficeName` = 'White Ivy Real Estate' ,`SellingAgentFullName` = 'Heath Wilson' ,`SellingOfficeName` = 'Realty ONE Group Iconic' ,`Latitude` = '31.003215' ,`Longitude` = '-95.305779' ,`PhotoCount` = '42' ,`PostalCode` = '75862' ,`RoomCount` = '7' ,`ListPrice` = '159500.00' ,`Status` = 'Option Pending' ,`StreetName` = 'State Highway 94' ,`StreetNumber` = '9928' ,`StreetSuffix` = '' ,`City` = 'Trinity' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2042' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BEING SOLD AS IS WHERE IS. This spacious home is almost completely finished and is located on 1.77 Acres of BEAUTIFUL UNRESTRICTED LAND. Located between Trinity and Groveton - it is close to schools; restaurants; Blueberry Farm; public boat ramps for access to Trinity River and LAKE LIVINGTON and State and National Parks. This home is so spacious with 2,042 sq. ft. living space. Sports large Den/Family Room; Livingroom open to kitchen, Dining Room and laundry room. Seller has completed most of the remodel. Brand new A/C; Newer Water Heater; New texture and paint most walls and ceilings. Completely Finished 1st Bath. All New Vinyl-Plank flooring awaits installation. With 2 Detached garages 1 double car and 1 single. This would be perfect for a forever home; a vacation home or as an Investment rental or Flip. You Don\'t Want to Miss This Opportunity!' ,`Acres` = '1.77' ,`Area` = '42' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Trinity Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'THREE RIDGE SECTION 1, LOT 10' ,`LotDesciption` = 'Other' ,`LotSize` = '77101' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '59 - Groveton' ,`SchoolElementary` = 'GROVETON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GROVETON J H-H S' ,`SchoolMiddle` = 'GROVETON J H-H S' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Three Ridge Sec 1' ,`TaxAmount` = '2339' ,`TaxRate` = '1.6133' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669652335' WHERE `Matrix_Unique_ID` = '212514375' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T20:26:39.007' ,`MLSNumber` = '44090240' ,`ListAgentFullName` = 'Carolina Beltran' ,`ListOfficeName` = 'Matrix Realty Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.432978' ,`Longitude` = '-95.415044' ,`PhotoCount` = '7' ,`PostalCode` = '77583' ,`RoomCount` = '4' ,`ListPrice` = '499900.00' ,`Status` = 'Active' ,`StreetName` = 'Hopper' ,`StreetNumber` = '3623' ,`StreetSuffix` = 'Street' ,`City` = 'Iowa Colony' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3028' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This immaculate Perry Home features 4 bedrooms and 3 full, located in the community of Meridiana. . As you open the front door you are welcomed by the private study. The kitchen features white cabinetry with granite countertops, SS appliances and a large kitchen island with room for bar seating. The family room includes wood flooring and large windows, spacious master suite. The master bath includes a large walk-in shower, separate garden tub and walk-in closet. This floorplan also includes two flex spaces perfect for a game room and media room.' ,`Acres` = '0.1719' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'MERIDIANA SEC 71 (A0513 HT&BRR) (IOWA COLONY) BLK 1 LOT 34' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '7488' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1050' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Meridiana Sec 71' ,`TaxAmount` = '15238' ,`TaxRate` = '3.6249' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669652336' WHERE `Matrix_Unique_ID` = '212999735' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T20:24:01.060' ,`MLSNumber` = '66996686' ,`ListAgentFullName` = 'Colette Franz' ,`ListOfficeName` = 'Compass RE Texas, LLCKaty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.838649' ,`Longitude` = '-95.443136' ,`PhotoCount` = '49' ,`PostalCode` = '77018' ,`RoomCount` = '4' ,`ListPrice` = '1390000.00' ,`Status` = 'Active' ,`StreetName` = 'Candlelight Place' ,`StreetNumber` = '1819' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4245' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come see this NEW CONSTRUCTION - RECENTLY COMPLETED -custom finished Modern Transitional Farmhouse. Four bedrooms, 4.5 bath, game room, study, Texas -sized open floor plan, plenty room for a really nice pool (built by others) & a TEXAS sized outdoor living space! Most recent community of 61 homes built by Lancaster Homes in Oak Forest. All zoned to OFE, one entrance in-n-out, social community, deed restricted and quiet. Oversized 2 + garage, extra large living spaces, Kitchen Aid appliances , open living spaces with custom finishes throughout.' ,`Acres` = '0.1818' ,`Area` = '9' ,`BuilderName` = 'Lancaster Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Oak Forest East Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 22 CANDLELIGHT PLACE SEC 4' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '7921' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '675' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Aluminum,Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'OAK FOREST ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'BLACK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Candlelight Place' ,`TaxAmount` = '6200' ,`TaxRate` = '2.3994' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669652336' WHERE `Matrix_Unique_ID` = '213256580' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T19:10:30.460' ,`MLSNumber` = '94155531' ,`ListAgentFullName` = 'Elizabeth Mader' ,`ListOfficeName` = 'RE/MAX GO' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '33.410454' ,`Longitude` = '-94.190851' ,`PhotoCount` = '44' ,`PostalCode` = '75501' ,`RoomCount` = '11' ,`ListPrice` = '380000.00' ,`Status` = 'Active' ,`StreetName` = 'Timberlane' ,`StreetNumber` = '13' ,`StreetSuffix` = 'Street' ,`City` = 'Texarkana' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3821' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fall in love w/ this charming, newly updated, brick home nestled in Echo Hills Estates subdivision in REDWATER ISD! This 4 BED/4 BATH home is complete w/ an extended private driveway, a large back patio w/ sun shade awning & above ground pool. The home has multiple new updates and features including a kitchen w/ stainless steel appliances & center island open to large living & dining area. The home boasts gorgeous stained concrete floors, a wine room, & large bedrooms on 2nd floor w/ children’s private play room, & closed den that could easily be converted to a fifth bedroom. The home sits on an expansive 1.47 acre lot, and has a large fenced backyard for privacy. NO HOA! Come home to comfort & all the space you\'ve been looking for! Book a showing today!' ,`Acres` = '1.47' ,`Area` = '84' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ECHO HILLS ESTATES LOT 13 2022-408 01/11/22 BLK/TRACT 2 1.47' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '64033' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Above Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '858 - Redwater' ,`SchoolElementary` = '' ,`SchoolHigh` = 'REDWATER HIGH SCHOOL' ,`SchoolMiddle` = 'REDWATER JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Echo Hills Estates' ,`TaxAmount` = '5589' ,`TaxRate` = '1.7385' ,`WaterSewer` = 'Aerobic' ,`YearBuilt` = '1990' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669652336' WHERE `Matrix_Unique_ID` = '213345915' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T19:52:15.857' ,`MLSNumber` = '88892775' ,`ListAgentFullName` = 'Greg Bennett' ,`ListOfficeName` = 'Greg Bennett Fine Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.624872' ,`Longitude` = '-95.584309' ,`PhotoCount` = '19' ,`PostalCode` = '77477' ,`RoomCount` = '9' ,`ListPrice` = '362000.00' ,`Status` = 'Active' ,`StreetName` = 'Country Club' ,`StreetNumber` = '3326' ,`StreetSuffix` = 'Boulevard' ,`City` = 'Stafford' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2300' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Handsome One Story in Sugar Creek! Three Beds, 2.5 Baths. High vaulted ceilings in the Master Bedroom and Family Room. Trayed ceiling in Formal Dining. Many updates including Master Bath with Large shower, raised cabinets, Frame-less shower door, Sitting area, two closets. Wood Flooring in Family and Dining areas, Tile in all other areas except Bedrooms that have new carpet. Plantation Shutters on all windows except (bathrooms & Bed 2). Kitchen has ample room with access to Dining and Breakfast room, utility and backyard. All appliances: including refrigerator, washer & dryer can convey. French doors off family room to the rear covered patio with Stone paver decking. The backyard is good sized, fully fenced with side yard storage and garage access at rear. Long, wide and straight driveway for easy access to finished garage and off-street parking. Recent water heater and AC. New Plumbing PEX supply lines installed. Drywall was opened to retrofit and will be repaired.' ,`Acres` = '0.2176' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate,Home Protection Plan,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Stafford Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SUGAR CREEK SEC 28, BLOCK 4, LOT 7' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot' ,`LotSize` = '9480' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '50 - Stafford' ,`SchoolElementary` = 'STAFFORD ELEMENTARY SCHOOL (STAFFORD MSD)' ,`SchoolHigh` = 'STAFFORD HIGH SCHOOL' ,`SchoolMiddle` = 'STAFFORD INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sugar Creek' ,`TaxAmount` = '5577' ,`TaxRate` = '1.9342' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669652336' WHERE `Matrix_Unique_ID` = '213427172' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T20:24:50.073' ,`MLSNumber` = '23198951' ,`ListAgentFullName` = 'Connie Santiago' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.056864' ,`Longitude` = '-95.560896' ,`PhotoCount` = '50' ,`PostalCode` = '77379' ,`RoomCount` = '11' ,`ListPrice` = '439990.00' ,`Status` = 'Active' ,`StreetName` = 'Gunters Ridge' ,`StreetNumber` = '20002' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3220' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 1.5 story, near athletic complex/pool. Brick elevation, double wide driveway w/extra parking & lovely landscaping. Welcoming entry w/high ceilings crown molding, hardwood floors throughout. 4 bd down including the primary. formal dining room, spacious den features open concept living w/fireplace, a wall of windows overlooking backyard. Large island kitchen with granite countertops, dual stainless sinks, updated SS gas range, new stainless steel Frigidaire oven, microwave & dishwasher. Fresh paint all interior incl. doors, French doors to primary suite w/trey ceiling, another set of French doors to en-suite w/whirlpool tub, separate shower & dual vanities. Spacious game room, another bedroom plus full bath upstairs. Step outside onto covered patio with lush landscaping. Grass for kids and pets to play. Gleannloch Farms amenities include: 3 pools & splash pad, tennis courts, lakes, boat house, dog park, equestrian center, walking trails& 27-hole Gleannloch Pines golf course.' ,`Acres` = '0.1731' ,`Area` = '14' ,`BuilderName` = 'Dr Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein/Tomball' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 10 BLK 3 GLEANNLOCH FARMS SEC 30' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot' ,`LotSize` = '7542' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'FRANK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN CAIN HIGH SCHOOL' ,`SchoolMiddle` = 'DOERRE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Gleannloch Farms' ,`TaxAmount` = '7457' ,`TaxRate` = '2.7315' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2009' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669652337' WHERE `Matrix_Unique_ID` = '213488603' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T20:10:38.213' ,`MLSNumber` = '46038029' ,`ListAgentFullName` = 'Gillus Blanchard' ,`ListOfficeName` = 'Connect Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.045568' ,`Longitude` = '-97.677597' ,`PhotoCount` = '35' ,`PostalCode` = '76542' ,`RoomCount` = '9' ,`ListPrice` = '350000.00' ,`Status` = 'Active' ,`StreetName` = 'Serpentine' ,`StreetNumber` = '6310' ,`StreetSuffix` = 'Drive' ,`City` = 'Killeen' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2454' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.22' ,`Area` = '83' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'WHITE ROCK ESTATES PHASE EIGHT, BLOCK 024, LOT 0013' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9583' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '648 - Killeen' ,`SchoolElementary` = 'TIMBER RIDGE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HARKER HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'LIBERTY HILL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'White Rock Estates Ph Eight' ,`TaxAmount` = '6218' ,`TaxRate` = '2.2526' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669652337' WHERE `Matrix_Unique_ID` = '213977918' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T19:31:08.050' ,`MLSNumber` = '94697888' ,`ListAgentFullName` = 'Elisa Rocha' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = 'Lesly Torres' ,`SellingOfficeName` = 'Coldwell Banker Realty' ,`Latitude` = '29.924263' ,`Longitude` = '-95.091050' ,`PhotoCount` = '24' ,`PostalCode` = '77532' ,`RoomCount` = '9' ,`ListPrice` = '250000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Oakdale Canyon' ,`StreetNumber` = '16711' ,`StreetSuffix` = 'Trace' ,`City` = 'Crosby' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1660' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Simply charming, with plenty of space and upgrades! This three-bedroom, two-bathroom home features an open living area with functional tile flooring throughout the main living areas. The well-equipped kitchen is complete with a breakfast bar, granite countertops, stainless-steel appliances including a gas range, added island with additional storage, water filtration faucet, and an eat-in breakfast area. The primary suite is spacious, offering ample space for large furniture. The primary bathroom features dual sinks, classic chrome fixtures, a garden tub for soaking, a walk-in shower, and plenty of closet storage. Two additional secondary suites offer ample room for large furniture and full hallway bathroom access. Outdoors, find a covered patio area, and an oversized, fully-fenced backyard with greenbelt location. Enjoy access to the neighborhood pool, or consider playing a round of golf at the Newport Golf and Country Club!' ,`Acres` = '0.1661' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Crosby Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 30 BLK 1 NEWPORT SEC 12' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '7234' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '55' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '12 - Crosby' ,`SchoolElementary` = 'CROSBY ELEMENTARY SCHOOL (CROSBY)' ,`SchoolHigh` = 'CROSBY HIGH SCHOOL' ,`SchoolMiddle` = 'CROSBY MIDDLE SCHOOL (CROSBY)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Newport Sec 12' ,`TaxAmount` = '5403' ,`TaxRate` = '2.7105' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669652337' WHERE `Matrix_Unique_ID` = '213983076' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T19:52:49.160' ,`MLSNumber` = '83776583' ,`ListAgentFullName` = 'Scarlett Snell' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.116225' ,`Longitude` = '-95.677388' ,`PhotoCount` = '47' ,`PostalCode` = '77355' ,`RoomCount` = '12' ,`ListPrice` = '750000.00' ,`Status` = 'Active' ,`StreetName` = 'Decker Prairie Rosehl' ,`StreetNumber` = '25518' ,`StreetSuffix` = 'Road' ,`City` = 'Magnolia' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3871' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Sprawling 2-acre privately gated, country estate conveniently located in Montgomery County AND the highly acclaimed Tomball ISD. The 4-bed/3 bath is approximately 3,800sf with 4 separate, yet connected garages, a 4-car carport and a stocked pond for fishing! Ideal for indoor and outdoor entertainment. The stone and brick exterior is complete with covered front and back porches. The home was renovated in 2021/2022 to provide an open dining, kitchen, and living area. The kitchen boasts an island cooktop, bar seating, a designated desk, window seat and a spacious 10’x6’ walk in shelved pantry. The owner’s suite maintains an abundance of space including ‘two’ walk-in closets. A large game room, office, mud/laundry rooms are valuable additions to the home. The slated floor patio room has a wide range of possibilities. Don’t miss coming to see all this estate has to offer.' ,`Acres` = '2.004' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Tomball' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'A0013 - EDWARDS JOHN H, TRACT 15-F, ACRES 2.004' ,`LotDesciption` = 'Cleared,Water View' ,`LotSize` = '87294' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'DECKER PRAIRIE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'TOMBALL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'EDWARDS JOHN H' ,`TaxAmount` = '6613' ,`TaxRate` = '1.9215' ,`WaterSewer` = 'Well' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669652337' WHERE `Matrix_Unique_ID` = '214044445' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T19:22:52.047' ,`MLSNumber` = '8770513' ,`ListAgentFullName` = 'James Dambeck' ,`ListOfficeName` = 'RE/MAX Compass' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.855023' ,`Longitude` = '-95.716763' ,`PhotoCount` = '33' ,`PostalCode` = '77449' ,`RoomCount` = '7' ,`ListPrice` = '279900.00' ,`Status` = 'Active' ,`StreetName` = 'Coldfield' ,`StreetNumber` = '19722' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2071' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'OPEN FLOOR PLAN. CLOSE TO SHOPPING. GREAT SCHOOLS. OPPORTUNITY TO BUY IN THIS AREA UNDER 300K! READY TO MOVR IN. METICULOUSLY MAINTAINED.AWESOME NEIGHBORS. COME SEE NOW. HVAC AND ROOF JUST 2 YEARS OLD. REFRIGERATOR STAYS WITH PROPERTY.' ,`Acres` = '0.1251' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 34 BLK 2 PLANTATION LAKES SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5450' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'EMERY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS LAKES HIGH SCHOOL' ,`SchoolMiddle` = 'ROWE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Colonial' ,`Subdivision` = 'Plantation Lakes Sec 01' ,`TaxAmount` = '5817' ,`TaxRate` = '3.011' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669652338' WHERE `Matrix_Unique_ID` = '214066099' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T19:58:00.013' ,`MLSNumber` = '20327692' ,`ListAgentFullName` = 'Leslie Free' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.015101' ,`Longitude` = '-95.178496' ,`PhotoCount` = '40' ,`PostalCode` = '77346' ,`RoomCount` = '11' ,`ListPrice` = '374900.00' ,`Status` = 'Active' ,`StreetName` = 'Greenfield' ,`StreetNumber` = '20819' ,`StreetSuffix` = 'Trail' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2723' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This wonderful home can be yours just in time for the holidays! You\'ll love walking into this inviting 2 story Foyer with an open Formal Dining room to the left & a Study/Office with French doors for privacy to the right. The large Family room is open to Kitchen & Breakfast room, all with great views of the backyard & pool too! The Primary bedroom & bathroom are spacious & has double vanities, a separate shower, tub & 2 walk-in closets. Located on the second floor is a game room, 3 secondary bedrooms & a full bathroom. The backyard has plenty of green space, a new deck & back fence. Roof was replaced in August 2022, water heater 2016, exterior paint & AC/compressor 2018. Conveniently located close to Lake Houston, San Jacinto River, greenbelts, pool, parks, shopping & restaurants! Has never flooded.' ,`Acres` = '0.1701' ,`Area` = '1' ,`BuilderName` = 'Village' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Kingwood South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 10 BLK 3 KINGS RIVER VILLAGE SEC 2' ,`LotDesciption` = 'In Golf Course Community' ,`LotSize` = '7408' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '475' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'GREENTREE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KINGWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'CREEKWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Kings River Village' ,`TaxAmount` = '6832' ,`TaxRate` = '2.453' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1994' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669652338' WHERE `Matrix_Unique_ID` = '214067767' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T20:01:49.793' ,`MLSNumber` = '88127877' ,`ListAgentFullName` = 'Stephen Wilhite' ,`ListOfficeName` = 'Keller Williams Realty - Clear Lake/ NASA' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.127161' ,`Longitude` = '-95.066861' ,`PhotoCount` = '48' ,`PostalCode` = '77554' ,`RoomCount` = '11' ,`ListPrice` = '359500.00' ,`Status` = 'Active' ,`StreetName` = '1st' ,`StreetNumber` = '4022' ,`StreetSuffix` = 'Street' ,`City` = 'Galveston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1748' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Only about a 5 minute walk or 1 minute car ride from the beach, this coastal gem positioned on a 20,000 sq. ft. lot makes the perfect vacation home or rental property. The home comes fully furnished & sleeps 11. Upstairs has 2 bedrooms & a full bathroom w/ a spacious kitchen & living room. Laundry hook-ups available up & downstairs. Sit on the covered deck & enjoy peek-a-boo views of the beach & bay, listen to the crashing waves & spot sea birds from the nearby bird sanctuary. Downstairs is a bonus area w/ 6’ 3” ceilings boasting a living room, kitchen, full bathroom, laundry room, & bedroom. The property has multiple storage units for housing your beach toys & an outdoor shower w/ sink & hot & cold water. The home is fully stocked & ready to go with EVERYTHING INCLUDED! The alarm system is wired to arm the whole house or upstairs/downstairs separately. The optional HOA provides a boat ramp & pavilion. Enjoy volleyball, ping pong, pool, or head to the beach at this chateau by the sea!' ,`Acres` = '0.4591' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West End' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 121 HALL & JONES SUR N 1/2 OF LOT 15 (15-1) BAY HARBOR' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '20000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Bay Harbor' ,`TaxAmount` = '5566' ,`TaxRate` = '2.0324' ,`WaterSewer` = 'Aerobic,Public Water,Septic Tank,Water District' ,`YearBuilt` = '1959' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669652338' WHERE `Matrix_Unique_ID` = '214209738' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T19:20:29.483' ,`MLSNumber` = '93445758' ,`ListAgentFullName` = 'Donna Mitchell' ,`ListOfficeName` = 'Birdsong Real Estate' ,`SellingAgentFullName` = 'Donna Mitchell' ,`SellingOfficeName` = 'Birdsong Real Estate' ,`Latitude` = '29.126480' ,`Longitude` = '-95.743816' ,`PhotoCount` = '22' ,`PostalCode` = '77480' ,`RoomCount` = '7' ,`ListPrice` = '425000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'County Road 3' ,`StreetNumber` = '6664' ,`StreetSuffix` = '' ,`City` = 'Sweeny' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1966' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Put your brand on this rustic country property. This 3/2/2 sits on OVER 20 Acres and is A RARE FIND. Acreage features mature, native trees and will provide a private setting to watch wildlife on the back porch or buyer can clear acreage and have the opportunity for livestock. This home\'s floorplan provides access to the patio and view of the beautiful acreage and nature. You will appreciate the circle drive, detached garage and many options this home offers. Give me a call to grab this amazing opportunity to live the rustic country life you have always dreamed of. THIS PROPERTY HAS NEVER FLOODED. Call for your viewing TODAY!' ,`Acres` = '20.05' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'West of the Brazos' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'A0118 ZENO PHILLIPS TRACT 3F1P ACRES 20.05' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '873378' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '10 - Columbia-Brazoria' ,`SchoolElementary` = '' ,`SchoolHigh` = 'COLUMBIA HIGH SCHOOL' ,`SchoolMiddle` = 'WEST BRAZOS JUNIOR HIGH' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Zeno Phillips' ,`TaxAmount` = '4876' ,`TaxRate` = '1.5937' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1977' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669652338' WHERE `Matrix_Unique_ID` = '214412352' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T20:33:22.940' ,`MLSNumber` = '34610278' ,`ListAgentFullName` = 'Mark Dimas' ,`ListOfficeName` = 'Mark Dimas Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.858433' ,`Longitude` = '-95.625001' ,`PhotoCount` = '50' ,`PostalCode` = '77084' ,`RoomCount` = '8' ,`ListPrice` = '324990.00' ,`Status` = 'Active' ,`StreetName` = 'Charlestown Colony' ,`StreetNumber` = '5615' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '2533' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Lovely 2-story home located in the Charlestown Colony subdivision with 5 bedrooms, 2.5 baths, attached 2-car garage, neutral paint, carpet, tile & hardwood flooring, & ceiling fans! The first floor offers a half bath, in-house utility room, living room, formal dining room, & cozy family room with fireplace! The eat-in kitchen boasts recessed lighting, granite countertops, subway tile backsplash, island, shaker-style cabinets, \r\n& stainless steel appliances! Upstairs opens to 4 secondary bedrooms & a full bath! The primary bedroom features two separate, attached closets and an en-suite bath with a jetted tub, separate shower, 2 separate sinks with vanities, & a walk-in closet! Enjoy the lovely backyard, which offers a spacious covered patio! Zoned to highly acclaimed Cy-Fair ISD schools, this home is located near numerous restaurants & shopping; within proximity to Hwy 6, Hwy 290 & Beltway 8!' ,`Acres` = '0.1723' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Eldridge North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 17 BLK 4 CHARLESTOWN COLONY SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7504' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '375' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'HORNE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'TRUITT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Charlestown Colony Sec 02' ,`TaxAmount` = '6120' ,`TaxRate` = '2.591' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1991' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669652339' WHERE `Matrix_Unique_ID` = '214430089' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T20:47:42.083' ,`MLSNumber` = '69266874' ,`ListAgentFullName` = 'Aaron Sonnier' ,`ListOfficeName` = 'Martha Turner Sotheby\'s International Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.749475' ,`Longitude` = '-95.097327' ,`PhotoCount` = '50' ,`PostalCode` = '77351' ,`RoomCount` = '11' ,`ListPrice` = '799000.00' ,`Status` = 'Active' ,`StreetName` = 'Indian Hill' ,`StreetNumber` = '1357' ,`StreetSuffix` = 'Boulevard' ,`City` = 'Livingston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2676' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Must See! New Construction Farmhouse w/ Lake View. Open concept living/dining/kitchen floor plan. Quartz counters throughout, subway tile backsplash, w/ wood, tile & carpet floors. S/S LG appliances w/ fridge W/D stove & D/W. High ceilings w/ soaring cathedral. Spiral stair to Gameroom Loft & utility. Large front porch w/ ceiling fan to entertain & enjoy Lake View. Large Primary w/ ensuite large bath w/ enclosed wet room w/ shower & soaker tub w/ frameless glass door. Quartz counters w/ built ins & large walkin closet. 2 secondary bedrooms w/ Jack & Jill bath 3rd full bath in hallway including Office/Study or 4th bed w/ views of Lake. Large Carriage house 25\'x38\' 2 14\' auto doors to store 2 RV\'s/large boats including 50 AMP RV plug. Plenty of parking front & back access 2 streets. Fully wired for internet & media. Citadel Security System cameras interactive panel & handheld smart pad. Located Indian Hills .33 acre lot peninsula. Boat launch a mile away. Short Term Rentals allowed.' ,`Acres` = '0.3384' ,`Area` = '44' ,`BuilderName` = 'Par3 Group, LLC' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'INDIAN HILL HEIGHTS SECTION 1 BLK 9 LOT 3 & 26' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '14741' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '103 - Livingston' ,`SchoolElementary` = 'LISD OPEN ENROLL' ,`SchoolHigh` = 'LIVINGSTON HIGH SCHOOL' ,`SchoolMiddle` = 'LIVINGSTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Indian Hill Heights' ,`TaxAmount` = '1152' ,`TaxRate` = '1.742' ,`WaterSewer` = 'Aerobic,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669652339' WHERE `Matrix_Unique_ID` = '214467447' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T20:24:43.240' ,`MLSNumber` = '90013715' ,`ListAgentFullName` = 'Lynn Rao' ,`ListOfficeName` = 'AlphaMax Realty Inc.' ,`SellingAgentFullName` = 'Sissy Quarfordt' ,`SellingOfficeName` = 'Keller Williams Woodlands' ,`Latitude` = '30.197821' ,`Longitude` = '-95.584531' ,`PhotoCount` = '38' ,`PostalCode` = '77382' ,`RoomCount` = '6' ,`ListPrice` = '370000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Panterra' ,`StreetNumber` = '51' ,`StreetSuffix` = 'Way' ,`City` = 'The Woodlands' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2065' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A lovely 3 bedrooms, 2.5 bathrooms, 2 car attached garage home. High ceilings. Granite in the kitchen and master bath. Stainless steel appliances in the kitchen. Walking distance to Deretchin Elementary which is a top rated Conroe ISD school. Walking distance to the 24 hour emergency care. Walking distance to Walmart shopping center, stores, banks and restaurants. A great place to live.' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Section 74 Block 19 Lot 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'DERETCHIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'THE WOODLANDS HIGH SCHOOL' ,`SchoolMiddle` = 'MCCULLOUGH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Village Stering Ridge' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669652339' WHERE `Matrix_Unique_ID` = '214468765' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T19:47:01.667' ,`MLSNumber` = '92153223' ,`ListAgentFullName` = 'Michele Kimmons' ,`ListOfficeName` = 'Michele Kimmons Properties,LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.037446' ,`Longitude` = '-95.621951' ,`PhotoCount` = '40' ,`PostalCode` = '77377' ,`RoomCount` = '11' ,`ListPrice` = '399888.00' ,`Status` = 'Active' ,`StreetName` = 'Point Arbor' ,`StreetNumber` = '12511' ,`StreetSuffix` = 'Court' ,`City` = 'Tomball' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2313' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Wonderful 3/2/3 David Weekly home in a beautiful neighborhood w/many small ponds. This single story home is located in the cul-de-sac w/an oversized lot. The home has a great layout w/high ceilings, study up at front of home, large dining room, & a split bedroom plan. The spacious open concept living/breakfast/kitchen area has a grand feel to it w/high ceiling plenty of room to move around. This property contains many extras & upgrades, such as a built-in desk, oversized island, reverse osmosis system, pot & pan drawers, shoe rack, & a covered patio. Newly installed granite is in the kitchen & laundry room. A 3 car garage allows extra parking & storage space. This home also has a newer roof. Much room for entertaining in the backyard or space for a pool. Also the back covered patio is plumbed for an outdoor kitchen. In 2021 a new roof was installed, new water heater & washer also installed. Tomball award wining schools are important for this area. Close to entertainment & SH 249.' ,`Acres` = '0.2438' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Tomball South/Lakewood' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 20 BLK 2 VILLAGES OF NORTHPOINTE SEC 15' ,`LotDesciption` = 'Cleared,Cul-De-Sac,Subdivision Lot' ,`LotSize` = '10618' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'CANYON POINTE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL MEMORIAL H S' ,`SchoolMiddle` = 'GRAND LAKES JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Villages/Northpointe Sec 15' ,`TaxAmount` = '7969' ,`TaxRate` = '2.7964' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2011' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669652339' WHERE `Matrix_Unique_ID` = '214487679' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T19:52:35.637' ,`MLSNumber` = '34048036' ,`ListAgentFullName` = 'Aidee Sanchez' ,`ListOfficeName` = 'JPAR Houston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.180994' ,`Longitude` = '-95.500285' ,`PhotoCount` = '34' ,`PostalCode` = '77381' ,`RoomCount` = '7' ,`ListPrice` = '599000.00' ,`Status` = 'Active' ,`StreetName` = 'Placid Hill' ,`StreetNumber` = '18' ,`StreetSuffix` = 'Circle' ,`City` = 'The Woodlands' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2165' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful & conveniently situated in the Heart of The Woodlands! This home has been completely remodeled with exceptional construction and meticulous attention to detail. Enter through the stunning foyer that flows into the family room boasting natural light from every direction. Kitchen includes stainless steel appliances & polish nickel finishes that compliment & give this all white kitchen a crisp & flawless look! Retreat into your master suite with spa-like master bathroom featuring a large frameless shower, double shower heads, soaking tub, double vanity, & GRAND MASTER CLOSET with soaring vaulted ceilings! Make all of your fantasies come true with this stunner! Upstairs features 3 additional bedrooms, which include an office. Large outdoor deck overlooks the back yard & features plenty of space for outdoor lounging & entertaining! New exterior doors, A/C, air ducts, & water heater. LOCATION, LOCATION, LOCATION - easy & quick access to all the amenities The Woodlands has to offer!' ,`Acres` = '0.2078' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'WDLNDS VIL COCHRANS CR03, BLOCK 1, LOT 22' ,`LotDesciption` = 'Wooded' ,`LotSize` = '9050' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'DAVID ELEMENTARY SCHOOL' ,`SchoolHigh` = 'THE WOODLANDS COLLEGE PARK HIGH SCHOOL' ,`SchoolMiddle` = 'KNOX JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Wdlnds Village Cochrans Cr 03' ,`TaxAmount` = '6451' ,`TaxRate` = '2.1811' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1984' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669652339' WHERE `Matrix_Unique_ID` = '214498228' --> 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','214499154','1669652340','214499154','2022-11-27T20:18:56.243','98358969','Christy Buck','Infinity Real Estate Group','','','29.530737','-95.484910','32','77545','6','290000.00','Active','Elm Stream','3911','Court','Fresno','2','0','4','2018','Single-Family','Looking for the perfect place to call home? Set on a quiet cul-de-sac, this adorable 1 story, 4 bedroom / 2 bath home is waiting on you! Custom touches everywhere! Great split floorplan with inviting entry. Formal dining room featuring designer paint accent wall & beautiful light fixture will accommodate plenty of guests for the holidays. The light & bright kitchen features granite countertops, tile backsplash, stainless appliances, plenty of storage,& quaint breakfast area - all open to family room. Living area boasts vaulted ceilings, laminate floors, & beautiful stacked stone fireplace w/ wooden mantel. Large primary bedroom w/ en-suite has shiplap wall w/ double sinks, garden tub, & separate shower - all with recent fixtures. 3 additional bedrooms & full bath. Recent A/C - 2020, Water heater - 2016, all toilets replaced, added attic access in garage,& fence recently replaced. Low taxes, no flooding. Don\'t miss out on this 1 story gem! Schedule your private tour today!','0.162','38','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gas Connections','1','Missouri City Area','Central Gas','1','TEAL RUN SEC 11, BLOCK 1, LOT 43','Cul-De-Sac,Subdivision Lot','7055','Appraisal District','','430','0','','2','Gas Oven','0','','','Gas Range','','Composition','19 - Fort Bend','GOODMAN ELEMENTARY SCHOOL (FORT BEND)','HIGHTOWER HIGH SCHOOL','LAKE OLYMPIA MIDDLE SCHOOL','Appointment Required,Supra Keybox','Appraisal District','1','Traditional','Teal Run Sec 11','4950','2.4829','Water District','2002','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T20:08:54.850' ,`MLSNumber` = '12067665' ,`ListAgentFullName` = 'Shermae Lopez' ,`ListOfficeName` = 'New Home Star Texas, LLC' ,`SellingAgentFullName` = 'Shermae Lopez' ,`SellingOfficeName` = 'New Home Star Texas, LLC' ,`Latitude` = '29.169884' ,`Longitude` = '-95.441698' ,`PhotoCount` = '6' ,`PostalCode` = '77515' ,`RoomCount` = '3' ,`ListPrice` = '161055.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'W Ash Street' ,`StreetNumber` = '723' ,`StreetSuffix` = '' ,`City` = 'Angleton' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1300' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This one Story Plan with 3 bedrooms, 2 baths, one story home is energy efficient, with an open Concept Kitchen overlooking the large living-dining combo, making this home perfect for entertaining. This home includes LED Lighting, and vinyl plank flooring in the living room, dining, kitchen, and baths. Moen fixtures in a timeless chrome finish are placed throughout the home. Lush carpeting in the bedrooms. Beautiful black appliance package included, home is engineered and inspected by a third-party engineer, has a seer HVAC system, double pane insulated Low-E windows, ENERGY EFFICIENT! Warranty: 1 yr workmanship & materials, 2 yr on all systems- plumbing, electrical, HVAC & other Mechanical Systems, 10 yr Major Structural components' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Censeo Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Angleton' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'JACKSON (ANGLETON) BLK 1 LOT 5' ,`LotDesciption` = 'Other' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '5 - Angleton' ,`SchoolElementary` = 'WESTSIDE ELEMENTARY SCHOOL (ANGLETON)' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'ANG AUBS ON WEST SIDE' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669652340' WHERE `Matrix_Unique_ID` = '214583069' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T20:15:58.427' ,`MLSNumber` = '98969771' ,`ListAgentFullName` = 'Macarena Korth' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.335704' ,`Longitude` = '-96.652005' ,`PhotoCount` = '18' ,`PostalCode` = '77879' ,`RoomCount` = '3' ,`ListPrice` = '70000.00' ,`Status` = 'Active' ,`StreetName` = 'Blackberry' ,`StreetNumber` = '497' ,`StreetSuffix` = 'Road' ,`City` = 'Somerville' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '840' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This half acre lot is located in Enchanted Oaks Subdivision. There is no HOA, low taxes and no known restrictions. The 14x60 mobile home is a fixer upper sold AS-IS. Mostly needing cosmetic repairs. New driveway. Community water with new water tap installed and Bluebonnet electricity. Close proximity to the lake to enjoy a relaxing day and watch deer walking by. 15 min to Somerville, 20 min to Caldwell, 35 min to Brenham. Property is vacant. Text or Call for questions.' ,`Acres` = '0.573' ,`Area` = '59' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = 'S2507 ENCHANTED OAKS PARK LOT 262, .573 ACRES' ,`LotDesciption` = 'Cleared' ,`LotSize` = '24960' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '158 - Somerville' ,`SchoolElementary` = 'SOMERVILLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SOMERVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'SOMERVILLE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Enchanted Oaks Park' ,`TaxAmount` = '423' ,`TaxRate` = '1.7844' ,`WaterSewer` = 'No Sewer,Public Water' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1669652340' WHERE `Matrix_Unique_ID` = '214638468' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T19:02:31.397' ,`MLSNumber` = '53515378' ,`ListAgentFullName` = 'Peggy Renee Ferrell-Sharp' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.000023' ,`Longitude` = '-95.631104' ,`PhotoCount` = '31' ,`PostalCode` = '77429' ,`RoomCount` = '8' ,`ListPrice` = '385000.00' ,`Status` = 'Active' ,`StreetName` = 'Merilee' ,`StreetNumber` = '13615' ,`StreetSuffix` = 'Court' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2571' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This Amazing one story brick home is located in the Highly desirable Longwood Neighborhood. This 4 Bedroom (or 3 with study), 3 full baths, formal living and dining room, Island High Grade Granite Kitchen, and large family room with wonderful bookshelves and entertainment center. Upgraded home has smart features -new thermostat and new garage doors operated from your phone (if you so desire!)The bedrooms and closets are large and the home flow is absolutely stunning-with soaring ceilings. Upgrades include hardwood flooring, crown molding, granite counters, and a large skylight in the kitchen. Outside private patio is covered and equipped with fan, speakers, and electric outlet for TV. You can\'t be in a more upscale community! Longwood is nestled in a highly acclaimed golf community which includes, parks, pools, walking trails and a highly recognized schools in the Cy-Fair School District. Don\'t let this one get away! Room sizes are approx. Refrigerator, washer and dryer included' ,`Acres` = '' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 7 Block 3 Sec 17 Longwood Village' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '7710' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1032' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'HAMILTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CY-FAIR HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Longwood' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669652340' WHERE `Matrix_Unique_ID` = '214670390' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T19:50:01.777' ,`MLSNumber` = '27012353' ,`ListAgentFullName` = 'Dorian Brown' ,`ListOfficeName` = 'Geek Realty Group' ,`SellingAgentFullName` = 'Martha Mendoza-Salazar' ,`SellingOfficeName` = 'HomeSmart' ,`Latitude` = '29.560114' ,`Longitude` = '-95.765417' ,`PhotoCount` = '17' ,`PostalCode` = '77469' ,`RoomCount` = '5' ,`ListPrice` = '260000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Crestwood' ,`StreetNumber` = '2104' ,`StreetSuffix` = 'Drive' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1603' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Huge Lot over 10,000 Square Feet with Mature Trees.This house was designed with the first time homebuyer in mind that wants something a little different then what\'s on the market.A little modern, a little retro, with a little old Richmond charm.Office with solid wood french doors off the entry. New vinyl wood flooring in entire house. Fresh paint inside and out.new dishwasher, Double ovens in kitchen with under cabinet lighting. Your own fig tree in back yard.Double sinks in primary bath along with oversized shower.New fans and Fixtures. Beautiful Beams in the living area, with Built ins. 2 inch thick Granite in the kitchen with back splash, Double pane windows through the house, Recent water heater, New Garage Doors, Recent Piping in attic, over sized Shed of 16ftx12ft , as well as 19x11 Sunroom.smoke/ carbon monoxide detecter.Updated electrical panel in 2019.Oversized Garage of 20x29.Cold Ac, No flooding ever. Make your appointment today.' ,`Acres` = '0.2314' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Owner/Agent' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'CLAIRMONT ACRES, LOT 22' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10080' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '0' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Wood Shingle' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'SMITH ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'LAMAR CONSOLIDATED HIGH SCHOOL' ,`SchoolMiddle` = 'WESSENDORF/LAMAR JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Clairmont Acres' ,`TaxAmount` = '3564' ,`TaxRate` = '2.3748' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669652340' WHERE `Matrix_Unique_ID` = '214747764' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T19:47:47.870' ,`MLSNumber` = '3179836' ,`ListAgentFullName` = 'Kori Schmidt' ,`ListOfficeName` = 'Fathom Realty' ,`SellingAgentFullName` = 'Sommer Kelley' ,`SellingOfficeName` = 'Mega Realty' ,`Latitude` = '29.359814' ,`Longitude` = '-95.036478' ,`PhotoCount` = '28' ,`PostalCode` = '77563' ,`RoomCount` = '3' ,`ListPrice` = '175000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Highland' ,`StreetNumber` = '113' ,`StreetSuffix` = 'Drive' ,`City` = 'Hitchcock' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1200' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'You\'re not going to want to miss this newly renovated home!! This home features new floors throughout, granite countertops, brand-new cabinets, remodeled bathroom, and much more! The sliding glass door off the living room is great for a little side patio to enjoy your morning coffee. This home has tons of natural light! All of the bedrooms are in the back of the home. Every bedroom has its own AC unit, so no need to fight over the house temperature. The backyard is a great size for entertaining! The laundry area is finished out with tile flooring in the garage and could be closed off to make it an official room. Less than 1/2 a mile away from Hitchcock Primary school! Easy access to Hwy 6 and I-45. Schedule your private showing today!' ,`Acres` = '0.2059' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hitchcock' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 71 P GAYATT SUR LOT 90 GREENWOOD' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8971' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '26 - Hitchcock' ,`SchoolElementary` = 'HITCHCOCK PRIMARY/STEWART ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HITCHCOCK HIGH SCHOOL' ,`SchoolMiddle` = 'CROSBY MIDDLE SCHOOL (HITCHCOCK)' ,`ShowInstructions` = 'Lockbox Front,No Supra Keybox,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Greenwood 1' ,`TaxAmount` = '2894' ,`TaxRate` = '2.3428' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669652341' WHERE `Matrix_Unique_ID` = '214811472' --> 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','214887624','1669652341','214887624','2022-11-27T19:32:57.090','95575186','Michan Murray','Keller Williams Realty - Memor','','','29.928453','-95.085270','29','77532','7','255000.00','Active','Midships','17019','Way','Crosby','2','0','4','1808','Single-Family','Welcome to NEWPORT!! This home is truly one of a kind, located in the desirable Newport Community. Numerous updates include fresh paint throughout, a fully fenced backyard, an extended driveway, fresh landscaping, solar screens on all windows, and an extra storage building in the backyard. The kitchen is beautiful, with granite countertops and a complementary backsplash. The Primary retreat is open and bright with a cozy bench window seat, en suite bath with jetted tub, and separate shower. The backyard is fully fenced with great space for entertaining. Newport features County Club Golf, Pool, Gym, Tennis Courts, Horse, and Stable Arena, Numerous Playgrounds, a Private Storage Facility, as well as Private Access to Lake Houston and San Jacinto River.','0.1792','1','Kara Custom Homes','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','','Wood Burning Fireplace','1','Crosby Area','Central Electric','1','LT 23 BLK 11 NEWPORT SEC 6','Cleared,In Golf Course Community,Subdivision Lot','7808','Appraisal District','','660','0','','2','Gas Oven','0','','','Electric Range','','Wood Shingle','12 - Crosby','NEWPORT ELEMENTARY SCHOOL','CROSBY HIGH SCHOOL','CROSBY MIDDLE SCHOOL (CROSBY)','Appointment Required','Appraisal District','1','Ranch,Traditional','Newport Sec 06','6185','2.7105','Water District','2006','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T20:22:14.030' ,`MLSNumber` = '11513688' ,`ListAgentFullName` = 'Valerie Ward' ,`ListOfficeName` = 'Texas United Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.014980' ,`Longitude` = '-95.317947' ,`PhotoCount` = '18' ,`PostalCode` = '77338' ,`RoomCount` = '3' ,`ListPrice` = '239900.00' ,`Status` = 'Active' ,`StreetName` = 'Maple Fox' ,`StreetNumber` = '7011' ,`StreetSuffix` = 'Drive' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1693' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This spacious 4 bedroom ranch awaits your finishing touches. Features an open living/dining room, white kitchen cabinets, granite counters, white subway tile backsplash, stainless appliances, spacious bedrooms, a large backyard and ceiling fans in every room. Whew! Schedule today! You won\'t be disappointed.' ,`Acres` = '0.1584' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Humble Area West' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 11 BLK 7 FOXWOOD SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6900' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '325' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'CYPRESSWOOD ELEMENTARY SCHOOL (ALDINE)' ,`SchoolHigh` = 'NIMITZ HIGH SCHOOL (ALDINE)' ,`SchoolMiddle` = 'JONES MIDDLE SCHOOL (ALDINE)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Foxwood' ,`TaxAmount` = '4363' ,`TaxRate` = '2.7734' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1977' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669652341' WHERE `Matrix_Unique_ID` = '214923603' --> 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','214947631','1669652341','214947631','2022-11-27T20:11:28.850','43363545','Tara Baker','JLA Realty','','','30.174446','-95.172975','26','77357','7','199900.00','Active','Southwood','1815','Drive','New Caney','2','0','3','1129','Single-Family','Updated and Upgraded but NEVER FLOODED single story in Woodway Forest! Don\'t be fooled by the SQFT, it\'s bigger than you think! Three bedrooms, two full bathrooms, two car garage and a must see huge, covered patio deck! All the major components have been recently updated...NEW WINDOWS 2021, NEW ROOF 2020, NEW AC 2018/DUCT WORK 2022, HOT WATER HEATER 2019, NEW VINYL FLOORS in BEDROOMS 2020, NEW FENCE 2022, CROWN MOLDING & UPDATED DOORS 2016, KITCHEN CABINETS 2006, BATHROOM TUB/SINK/VANITY 2005, and huge 25x21 COVERED DECK 2020! No carpet! Nice size backyard. Zoned to highly rated New Caney schools. Easy access to Highway 59 and 242. Schedule to view it today!','','40','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','Freestanding','1','Porter/New Caney East','Central Gas','0','Woodway Forest 01, Block 1, Lot 4 Partial Replat A','Subdivision Lot','','','','0','0','','2','Double Oven','0','','','Electric Cooktop','','Composition','39 - New Caney','DOGWOOD ELEMENTARY SCHOOL (NEW CANEY)','NEW CANEY HIGH SCHOOL','KEEFER CROSSING MIDDLE SCHOOL','Accompany,Appointment Required,Supra Keybox','Appraisal District','1','Traditional','Woodway Forest','','2.4398','Public Water','1978','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T19:13:04.350' ,`MLSNumber` = '16808041' ,`ListAgentFullName` = 'Karla Gonzalez-Bravo' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.587930' ,`Longitude` = '-95.194198' ,`PhotoCount` = '15' ,`PostalCode` = '77089' ,`RoomCount` = '6' ,`ListPrice` = '230000.00' ,`Status` = 'Active' ,`StreetName` = 'Ryewater' ,`StreetNumber` = '12203' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1104' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully renovated 3 bedroom, 2 bathroom home in the Scarsdale neighborhood of South Houston. The home was fully gutted and features an updated kitchen, bathrooms and all new PEX plumbing lines. New electrical wiring with new a electrical panel, a new roof, HVAC as well as a new furnace. Come see this home for yourself!' ,`Acres` = '0.1616' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Southbelt/Ellington' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 36 BLK 30 SCARSDALE SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7040' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '94' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'BURNETT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DOBIE HIGH SCHOOL' ,`SchoolMiddle` = 'THOMPSON INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Scarsdale Sec 03' ,`TaxAmount` = '4206' ,`TaxRate` = '2.6863' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1976' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669652341' WHERE `Matrix_Unique_ID` = '214994414' --> 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','214996439','1669652342','214996439','2022-11-27T19:17:59.353','73483207','Bruce Sellers','Keller Williams Advtge Realty','','','30.411956','-95.616860','50','77356','14','1499000.00','Active','Benthaven','92','','Montgomery','4','1','4','4315','Single-Family','Located on Benthaven Isle, an exclusive gated enclave within the already gated country club community of Bentwater on Lake Conroe, you\'re one of three dozen homes separated from the main subdivision by a 200\' bridge. This is about as private as it gets. Surrounded by multi-million dollar homes, you\'re one of only a half dozen properties on the inner island. With water views, the backyard beyond your pool appears enormous, backing up to a manicured park area with its walkway and open spaces, all maintained by the POA. The home itself is recently remodeled top to bottom with high-end fixtures/finishes. Plus a 30\'x30\' screened outdoor living area/summer kitchen was added. This home is one of one. Elegantly appointed open floorplan is exceptional. \r\nNothing else quite like it in Bentwater. Country club lifestyle, Lake Conroe recreation, & gated privacy. Plus, you\'re just minutes from all the shopping, dining and world-class medical facility amenities of The Woodlands. Gotta see this one.','0.471','39','Paul Meyer Custom','','Electric Dryer Connections,Washer Connections','','Estate,Mud,Other Disclosures,Sellers Disclosure','1','Gas Connections,Gaslog Fireplace','2','Lake Conroe Area','Central Gas,Zoned','1','S261593 - BENTWATER 93, BLOCK 2, LOT 9','Cul-De-Sac,Greenbelt,In Golf Course Community,Water View','20516','Appraisal District','','2396','0','','3','Gas Oven,Single Oven','1','Gunite,In Ground','','Gas Cooktop','','Composition','37 - Montgomery','LINCOLN ELEMENTARY SCHOOL (MONTGOMERY)','MONTGOMERY HIGH SCHOOL','MONTGOMERY JUNIOR HIGH SCHOOL','Accompany,Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox','Appraisal','2','Traditional','Bentwater','17272','2.2439','Water District','2007','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','215026962','1669652342','215026962','2022-11-27T20:50:30.997','894677','Teresa Sartin','Keller Williams Woodlands','Odessa Long','Walzel Properties','30.183191','-95.573786','49','77382','13','625000.00','Option Pending','Concord Valley','110','Circle','Spring','3','0','4','2975','Single-Family','MULTIPLE OFFERS, HIGHEST/BEST DUE BY 5PM SATURDAY 11/26/2022\r\nLOVELY ONE STORY HOME IN A GREAT NEIGHBORHOOD, NEXT TO COULSON TOUGH ELM.,LOADS OF UPGRADES, STONE FIREPLACE,UNDER COUNTER LIGHTING,GLAZE ON MAPLE CABINETS,SS APPLIANCES,GRANITE IN THE KITCHEN AND BATHROOMS. GLASS BLOCK/ROCK STONE INLAY IN MASTER BATH, WOOD FLOORING IN THE HALL,STUDY AND FAMILY,UTILITY SINK,RADIANT BARRIER,COMPUTER NICHE. GUEST ROOM W/PRIVATE BATH. WALK TO SCHOOLS OR TO THE PARK AND SWIMMING POOL. BIKE TO THE YMCA AND LIBRARY CLOSE BY. COMPARE TO NEW CONSTRUCTION!','0.2202','15','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Exclusions,Mud,Sellers Disclosure','1','Gas Connections,Gaslog Fireplace','1','The Woodlands','Central Gas','0','WDLNDS VIL STERLING RIDGE 25, BLOCK 2, LOT 3','Subdivision Lot','9593','Appraisal District','','','0','','3','Double Oven,Electric Oven','1','Gunite,In Ground','','','','Composition','11 - Conroe','TOUGH ELEMENTARY SCHOOL','THE WOODLANDS HIGH SCHOOL','MCCULLOUGH JUNIOR HIGH SCHOOL','Appointment Required,Leave Business Card,Supra Keybox','Appraisal District','1','Traditional','Wdlnds Village Sterling Ridge 25','11113','2.1816','Public Sewer,Water District','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','215047443','1669652342','215047443','2022-11-27T19:38:43.680','25028300','Ebony Onyemu','Texas Premier Realty','','','29.297266','-94.806218','9','77550','7','400000.00','Active','Sealy','3501','Street','Galveston','2','0','5','2236','Single-Family','Location Location Location! The home is minutes away from the strand, sea wall, Galveston College and Texas A&M. Schedule your private showing today! Two-story home ready for your renovation/redo located in Galveston\'s East End Historical District. More pictures coming momentarily. The showings will start on 12/02/2022','0.0499','33','','','','','No Disclosures','','','','Harborside','Central Electric,Central Gas','0','ABST 628 M B MENARD SUR PT OF LOT 7 (7-2) BLK 215 GALVESTON','Corner','2173','Appraisal District','','','0','','2','','0','','','','','Wood Shingle','22 - Galveston','GISD OPEN ENROLL','BALL HIGH SCHOOL','GISD OPEN ENROLL','Appointment Required,Lockbox Front','Appraisal District','2','Contemporary/Modern','Galveston Townsite','3858','2.0662','Public Water','2012','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','215061630','1669652342','215061630','2022-11-27T19:48:17.090','24650581','Marie Gilbert','RE/MAX Signature','','','29.749252','-95.588515','34','77077','13','638000.00','Active','Cedar Pass','11827','Drive','Houston','3','1','4','2633','Single-Family','Totally redesigned! Modern, chic aesthetic! High-end finishes. No detail unfinished. Large front yard with mature trees. Open concept floor plan. Wood style flooring. Living with towering ceilings, cozy gas fireplace, built-ins and stunning wall of windows with poolside views. Gorgeous Island kitchen with apron sink, pro-style gas cooking, stainless steel appliances and attached breakfast room with wine fridge and built-ins. Home office with built-in desk and storage. Primary bedroom down with outdoor views and en-suite offering oversized frame-less shower and double vanities. Spacious secondary bedrooms with plenty of closets and storage space. Beautifully redone secondary baths. Backyard with patio, sparkling pool and green space. Great location. Easy Access to Briar Forest, Beltway 8, West Park Tollway, I-10 & Highway 6. Close to hike and bike trails. Shopping, dining and entertainment nearby. Westside High!','','31','','','Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gaslog Fireplace','1','Energy Corridor','Central Gas','1','LT 6 BLK 11 COUNTRY VILLAGE SEC 2 R/P','Subdivision Lot','8924','Appraisal District','','820','0','','2','Gas Oven','1','In Ground','','Gas Range','','Composition','27 - Houston','ASHFORD/SHADOWBRIAR ELEMENTARY SCHOOL','WESTSIDE HIGH SCHOOL','WEST BRIAR MIDDLE SCHOOL','Appointment Required','Appraisal District','2','Contemporary/Modern','COUNTRY VILLAGE','','','Public Sewer,Public Water','1976','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','215078349','1669652342','215078349','2022-11-27T20:13:38.047','81141786','Chris Gordon Garza','Keller Williams Realty - Memor','Stephanie Ebarra','eXp Realty, LLC','30.151488','-95.405054','31','77385','6','285000.00','Option Pending','Winding Creek','2610','Way','Conroe','2','0','3','1657','Single-Family','Welcome to 2610 Winding Creek Way , Conroe, TX 77385. This stunning three bedroom two bath with two car garage is situated on 5400 square foot lot backing up the greenbelt. As you make your way in you will find an office or formal dining room whichever best fits your needs. Next you will enter the open kitchen that has painted cabinets, recent dishwasher and oven(2022). After that you will enter the breakfast area that opens up to the living room. Secondary bedrooms share one full bath with shower/tub combo. Primary bedroom over looks the backyard with nice walk in closet. The Primary bathroom has been updated (2019) with a nice sleek shower. You won\'t want to miss this opportunity. Home has never flooded.','0.124','15','','','','','Mud','1','','0','Spring Northeast','Central Gas','1','S612180 - IMPERIAL OAKS PARK 12A, BLOCK 1, LOT 18','Greenbelt,Subdivision Lot','5400','Appraisal District','','600','0','','2','Gas Oven','0','','','Gas Range','','Composition','11 - Conroe','KAUFMAN ELEMENTARY SCHOOL','OAK RIDGE HIGH SCHOOL','IRONS JUNIOR HIGH SCHOOL','Accompany,Appointment Required,Supra Keybox','Appraisal District','1','Traditional','Imperial Oaks Park 12a','7097','3.3087','Water District','2008','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','215083273','1669652342','215083273','2022-11-27T19:19:36.880','62181011','Stacey Howard','White Glove Realty','','','29.524670','-95.028426','24','77565','6','265000.00','Active','Delores','1111','Street','Kemah','2','0','3','1459','Single-Family','Adorable one story home in Kemah! Located at the end of an oversized quiet culdesac! Open floor plan with high ceilings in the over sized living area. There is plenty of storage throughout the home. Kitchen includes a breakfast bar with plenty of cabinets and counter space. NEW roof 2022 and NEW AC 2021. You will love the relaxing covered back patio with fire pit area. Backyard includes storage shed and a chicken coop. Pool is being removed and replaced with sod. New Roof and New AC!','0.1791','33','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','0','League City','Central Gas','0','ABST 18 M MULDOON SUR LOT 17 SOUTH KEMAH ADDN','Cul-De-Sac','7800','Appraisal District','','','0','','0','Electric Oven','0','','','Electric Cooktop','','Composition','9 - Clear Creek','STEWART ELEMENTARY SCHOOL (CLEAR CREEK)','CLEAR FALLS HIGH SCHOOL','BAYSIDE INTERMEDIATE SCHOOL','Appointment Required,Supra Keybox','Appraisal District','1','Traditional','South Kemah','4314','2.0134','Public Water,Water District','1996','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','215093724','1669652342','215093724','2022-11-27T19:38:28.830','75540573','Gilbert Tovar','Mark Dimas Properties','','','29.874340','-95.664705','31','77084','7','275000.00','Active','Blend Stone','16806','','Houston','2','0','3','1531','Single-Family','2022’s Final Blow-Out Deal of the Year is here! Cozy 1-story located in a cul-de-sac lot in NW Houston is going be an awesome start for the coming year! This home has it all! Quartz kitchen counter tops with accenting quartz backsplash, New kitchen cabinets with soft closing doors & drawers, Lazy Susan, Farmers sink, New stainless-steel appliances, Brushed nickel faucets & fixtures, recessed lighting, vaulted ceilings, new water resistant laminate flooring, fully updated Primary & Guest baths with new tubs & toilets, tub tile surround, new ceiling fans, 5-inch baseboards and so much more! If you need more conceiving: how about a New roof w/Techshield installed in 2020, new siding 2020 and new energy efficient windows 2020. Your going to want to make your appointment now! Call today!','','8','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Gaslog Fireplace','1','Bear Creek South','Central Gas','1','LT 23 BLK 5','Cul-De-Sac,Subdivision Lot','7000','Appraisal District','','410','0','','2','Gas Oven,Single Oven','0','','','Freestanding Range,Gas Range','','Composition','13 - Cypress-Fairbanks','HOLMSLEY ELEMENTARY SCHOOL','LANGHAM CREEK HIGH SCHOOL','KAHLA MIDDLE SCHOOL','Lockbox Front,Supra Keybox','Appraisal District','1','Traditional','STONE CREEK','5554','3.071','Water District','1982','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215111302','1669652342','215111302','2022-11-27T20:00:59.110','88623946','Juli Mahaney','BHGRE Gary Greene','','','29.630087','-95.740901','2','77406','11','585000.00','Active','Thompson Crossing','2119','Drive','Richmond','4','2','4','4732','Single-Family','Custom estate home in the highly desired neighborhood of Pecan Grove. The 4 bedroom, 2 half bath, 5 car garage house is in the Pecan Forest section near the golf course. The flexible floor plan allows for many different options for room usage. The outdoor oasis features a large athletic Pebbletec pool with a HUGE spa, new heater and pool equipment 2021. New roof 2021. Large foyer with high ceilings. Both formal living and dining room. Kitchen is open to the breakfast and family room. Primary bedroom down and 3 secondary bedrooms up with 2 additional rooms that could be used as bedrooms. Contact me today for a private showing! ','0.3118','37','Bayou Bend Custom Ho','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gaslog Fireplace','2','Fort Bend County North/Richmond','Central Gas','1','PECAN GROVE PLANTATION SEC 15, BLOCK 4, LOT 1','Corner,In Golf Course Community,Subdivision Lot','13582','Appraisal District','','209','0','','5','Electric Oven,Single Oven','1','Heated,In Ground','','Gas Range','','Composition','19 - Fort Bend','PECAN GROVE ELEMENTARY SCHOOL','TRAVIS HIGH SCHOOL (FORT BEND)','BOWIE MIDDLE SCHOOL (FORT BEND)','Appointment Required,Supra Keybox','Appraisal District','2','Colonial,Traditional','Pecan Grove Plantation Sec 15','11754','2.2979','Water District','1991','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','215114029','1669652342','215114029','2022-11-27T19:03:54.870','87381519','Michael Afshari','Compass RE Texas, LLC','','','29.734263','-95.368165','39','77004','12','494700.00','Active','Francis','2120','Street','Houston','3','1','3','2104','Single-Family','Corner home & is Move-In Ready! 2120 Francis Street features a freestanding 3 level residence w private driveway by coveted building firm, City Choice Homes. The home showcases a timeless aesthetic across 3 levels w 3 bedrooms, 3.5 baths & oversized covered balcony on second level. Enter the foyer open to all 3 levels leading to a generous en-suite guest room w walk-in closet. Ascend to the 2nd level boasting a sunlit Great Room with wine bar spanning over 30’ opening to the balcony & an island kitchen outfitted w top tier appliances, shaker style cabinetry & quartz countertops. 3rd level: Owner’s suite, en-suite guest room & utility room. The Owners wing features coffered 10’ ceilings & massive walk-in closet w built-ins. Owner’s bath consists of a freestanding soaking tub, dual vanities trimmed with high end plumbing fixtures & substantial glass enclosed shower & private water closet. Swiss flooring throughout home, all en-suite bedrooms, private driveway with covered porte-cachere.','','4','City Choice Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','No Disclosures','1','','0','University Area','Central Gas','1','LT 1 BLK 1 PARK AT FRANCIS','Corner','1625','Appraisal District','','1500','1','To Be Built/Under Construction','2','Freestanding Oven,Gas Oven','0','','','Gas Range','','Composition','27 - Houston','BLACKSHEAR ELEMENTARY SCHOOL (HOUSTON)','YATES HIGH SCHOOL','CULLEN MIDDLE SCHOOL (HOUSTON)','Appointment Required,Lockbox Front,Request Online Appointment','Builder','3','Contemporary/Modern,Other Style','Park at Francis','','','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','215114307','1669652342','215114307','2022-11-27T19:48:06.607','70564627','Justin Dees','Lifestyles Realty, Inc.','','','30.066899','-95.376136','20','77373','8','285000.00','Active','Sawmill','23823','Pass','Spring','2','0','3','2125','Single-Family','Fully renovated home in Spring, Texas. Located in Breckenridge Forest Subdivision. This 3 bed 2 bath 2100 sq. ft home has new tile flooring, paint, hardware, countertops, faucets, sinks, toilets and a bonus/office room off the master bedroom. Close to 1960\' and 99\'. Close to the Woodlands, restaurants, malls, and other businesses.','0.1446','12','','','','','Other Disclosures','','','1','Spring East','Central Electric,Central Gas','1','LT 24 BLK 1 BRECKENRIDGE FOREST SEC 2','Cleared,Subdivision Lot','6297','Appraisal District','','','0','','2','','0','','','','','Composition','48 - Spring','GLORIA MARSHALL ELEMENTARY SCHOOL','SPRING HIGH SCHOOL','RICKY C BAILEY M S','Lockbox Front,Vacant/Unoccupied','Appraisal District','1','Traditional','Breckenridge Forest Sec 02','6772','2.8117','Public Sewer,Public Water','2005','Appraisal District'); --> New record created successfully