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-10-07T22:48:10.143' ,`MLSNumber` = '27651620' ,`ListAgentFullName` = 'Gurbinder Randhawa' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.812790' ,`Longitude` = '-94.976328' ,`PhotoCount` = '17' ,`PostalCode` = '77521' ,`RoomCount` = '5' ,`ListPrice` = '570000.00' ,`Status` = 'Active' ,`StreetName` = 'Seabird' ,`StreetNumber` = '5443' ,`StreetSuffix` = 'Street' ,`City` = 'Baytown' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4201' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'You will fall in love with this stunning 2 story 5 Bedroom house with an open floor plan located in the outstanding Springfields Estates Subdivision. House is currently rented, and lease expires on Feb 28, 2023. Tenants need 2-hour advance notice before schedule a showing. This house features a spacious living room with fireplace, formal dining room, gorgeous kitchen with granite countertops, game room, media room, and a study room. Enjoy the primary suite with a deep soaking tub, separate shower, double sink/vanity area and large walk-in closet. Relax with family and friends in the large backyard with covered patio. This beautiful house is located close to shopping and famous restaurants. Call today for your private showing appointment!' ,`Acres` = '0.1431' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 14 BLK 1 SPRINGFIELD ESTATES SEC 11' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6235' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '340' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'VICTORIA WALKER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GOOSE CREEK MEMORIAL' ,`SchoolMiddle` = 'HIGHLANDS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Springfield Estates Sub Sec 8' ,`TaxAmount` = '8906' ,`TaxRate` = '3.095' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665221990' WHERE `Matrix_Unique_ID` = '207450917' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-07T22:36:11.930' ,`MLSNumber` = '53872986' ,`ListAgentFullName` = 'Stacey Weber-Rubio' ,`ListOfficeName` = 'Sand N Sea Properties, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.203500' ,`Longitude` = '-94.939106' ,`PhotoCount` = '39' ,`PostalCode` = '77554' ,`RoomCount` = '9' ,`ListPrice` = '669000.00' ,`Status` = 'Active' ,`StreetName` = 'Pirates' ,`StreetNumber` = '4127' ,`StreetSuffix` = 'Drive' ,`City` = 'Galveston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1280' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beachside cottage enjoys Gulf views and is just a short stroll to the sand! You\'ll love basking in the nostalgia of days gone by at the beach, in this cottage. Upstairs offers 2 large bedrooms, a huge laundry and storage room, a full bath and open, easy living that boasts access from multiple points to the huge, wrap around deck! The breakfast bar offers extra seating and the bamboo floors throughout are perfect for the beach! Need more space? The ground floor has a large guest suite with a private, full bath! Also on the ground level 2 good sized storage rooms, lots of covered entertainment space, complete with 4 full sized swings for relaxing and hanging out. There\'s even an outdoor shower and fish cleaning sink! House is being sold furnished with a few exclusions, even the beach toys are included! This house is a must see!' ,`Acres` = '0.157' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West End' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 121 PAGE 46 LOT 3 BLK 15 PIRATES BEACH SEC 2' ,`LotDesciption` = 'Water View' ,`LotSize` = '6840' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style,Traditional' ,`Subdivision` = 'Pirates Beach 2' ,`TaxAmount` = '6780' ,`TaxRate` = '2.0324' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1977' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665221990' WHERE `Matrix_Unique_ID` = '207798307' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-07T22:09:00.793' ,`MLSNumber` = '51418515' ,`ListAgentFullName` = 'Sherry McNabb' ,`ListOfficeName` = 'Nest Ahead' ,`SellingAgentFullName` = 'Jerome Young' ,`SellingOfficeName` = 'Texas Living Company' ,`Latitude` = '29.754355' ,`Longitude` = '-95.743574' ,`PhotoCount` = '40' ,`PostalCode` = '77450' ,`RoomCount` = '10' ,`ListPrice` = '445000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Westcliffe Falls' ,`StreetNumber` = '21619' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3227' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous 2 story brick home with a sparkling pool & spa, generous green space, & a potential garage apartment all perfectly situated on a sprawling lot (over 1/3 acre) on a double cul-de-sac street! The open kitchen boasts granite countertops, a gas cooktop, stainless steel appliances & a built-in refrigerator. You will even have a butler’s pantry! The primary bedroom suite is downstairs with windows looking out to the pool, & there are three spacious bedrooms upstairs as well, along with a huge game room! This home has an attractive low tax rate & is zoned to excellent Katy ISD schools. Community amenities include a park, tennis court, & new splash pad! If you are looking for a great home on a quiet street, backyard oasis, amazing schools, & a prime location, look no further. You will be just minutes away from the Grand 99 Parkway, 1-10, and Westpark Tollway. Local amenities such as groceries, restaurants, shopping, & entertainment are also conveniently close to your new home.' ,`Acres` = '0.3711' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 49 BLK 1 MEMORIAL PARKWAY SEC 17' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '16165' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '525' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'HAYES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TAYLOR HIGH SCHOOL (KATY)' ,`SchoolMiddle` = 'MCMEANS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Oak Park Trails' ,`TaxAmount` = '7914' ,`TaxRate` = '2.4133' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1993' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665221990' WHERE `Matrix_Unique_ID` = '210012608' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-07T22:46:49.790' ,`MLSNumber` = '5796126' ,`ListAgentFullName` = 'Andrea Rivera' ,`ListOfficeName` = 'RE/MAX Universal' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.930882' ,`Longitude` = '-95.574542' ,`PhotoCount` = '29' ,`PostalCode` = '77064' ,`RoomCount` = '8' ,`ListPrice` = '226900.00' ,`Status` = 'Active' ,`StreetName` = 'Golden Sunshine' ,`StreetNumber` = '10218' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1829' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 10218 Golden Sunshine Drive in the well-established and desirable neighborhood of Harvest Bend! This house could be your dream home! This 3 bedroom/ 2 full bathroom home is surrounded by mature trees in the front and backyard that provide shade for outdoor entertaining! HVAC & Water Heater are less than 5 years old, new PEX pipes throughout the entire home, new laminate flooring, built-in shelves in the living and dining room, new kitchen cabinets, new electric cook-top, and large windows all throughout the home that bring in tons of natural lighting inside. This home is conveniently located near 1960, 249, beltway 8, and 290. Come see this home and put your own personal tastes into it. Priced to sell!' ,`Acres` = '0.1687' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Willowbrook South' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 3 & N 2 FT OF LT 2 & S 1 FT LT 4 BLK 1 HARVEST BEND SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7350' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '407' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'FRANCONE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'CAMPBELL MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Harvest Bend Sec 01' ,`TaxAmount` = '4381' ,`TaxRate` = '2.5587' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665221991' WHERE `Matrix_Unique_ID` = '210039585' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-07T23:36:51.040' ,`MLSNumber` = '89591498' ,`ListAgentFullName` = 'Andrea Cooksey' ,`ListOfficeName` = 'Exit Realty 360' ,`SellingAgentFullName` = 'Chandra Ware' ,`SellingOfficeName` = 'Sapphire Realty' ,`Latitude` = '29.774064' ,`Longitude` = '-95.406805' ,`PhotoCount` = '32' ,`PostalCode` = '77007' ,`RoomCount` = '10' ,`ListPrice` = '475000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Maxie' ,`StreetNumber` = '4517' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1317' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A Listing with options prime location minutes from Downtown sport venues, Memorial Park Houston Galleria, Local neighborhood restaurants, sprawling new development all around. This cute historical cottage 2 plus a study or 3 bedroom 2 full baths updated kitchen, hardwood floors and a great back yard. Or it is your perfect development spot to create your own new paradise in a prime location. Room dimensions are approx. Owner finally decided to sell so hurray location location location one of the few last full home sites in the area.' ,`Acres` = '0.1171' ,`Area` = '16' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Rice Military/Washington Corridor' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'TRS 8 & 9 BLK 84 BRUNNER' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5100' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'MEMORIAL ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Brunner' ,`TaxAmount` = '6654' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1925' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665221991' WHERE `Matrix_Unique_ID` = '210608427' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-07T22:36:32.473' ,`MLSNumber` = '98718011' ,`ListAgentFullName` = 'Bonnie Ford' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.811651' ,`Longitude` = '-95.481365' ,`PhotoCount` = '15' ,`PostalCode` = '77055' ,`RoomCount` = '8' ,`ListPrice` = '555000.00' ,`Status` = 'Active' ,`StreetName` = 'Fall Run Park' ,`StreetNumber` = '2215' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2406' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Private Driveway can accommodate full size SUV or Truck. Front yard, back yard, side yard. Home Office. Located in a gated community of 35 homes, with a perfectly located Greenspace, this Modern style home offers 3BR\'s, 2.5 BA\'s and high-end finishes throughout! This home includes extensive recessed lighting, 8\' doors throughout, 10\' ceilings, Quartzite and Quartz counters and premium engineered wood flooring. Front and Back Lawn Maintenance included in HOA! Chefs\' kitchen features natural stone counters, a large island, a stainless steel appliance package & plenty of storage cabinetry including deep pots and pans drawers, Soft Close cabinets, and drawers. Built-in pest control system, full yard sprinkler system, 5.1 surround sound pre-wire and alarm pre-wire.\r\n\r\nApproximate completion date: May 15, 2022.' ,`Acres` = '' ,`Area` = '24' ,`BuilderName` = 'Fall Harbor Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 31 BLK 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '3467' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'TREASURE FOREST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTHBROOK HIGH SCHOOL' ,`SchoolMiddle` = 'LANDRUM MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Fall Run Park' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665221991' WHERE `Matrix_Unique_ID` = '211373791' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-07T22:07:27.833' ,`MLSNumber` = '83267399' ,`ListAgentFullName` = 'Mario Negron' ,`ListOfficeName` = 'Century Communities Houston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.074711' ,`Longitude` = '-95.237092' ,`PhotoCount` = '21' ,`PostalCode` = '77365' ,`RoomCount` = '4' ,`ListPrice` = '278160.00' ,`Status` = 'Active' ,`StreetName` = 'Auburn Cabin' ,`StreetNumber` = '22331' ,`StreetSuffix` = 'Lane' ,`City` = 'Porter' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1557' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Brand new construction by Century Communities! Estimated completion is December 2022. This home comes with great features including granite countertops throughout, tankless water heater, full sod front and back, covered patio, separate tub and shower, home automation powered by Google, and more! \r\n\r\nElevation - C\r\nInterior - 3' ,`Acres` = '' ,`Area` = '40' ,`BuilderName` = 'Century Communities' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Porter/New Caney East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 8, Block 1, Section 14' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '790' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'KINGS MANOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PORTER HIGH SCHOOL (NEW CANEY)' ,`SchoolMiddle` = 'WOODRIDGE FOREST MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Woodridge Forest' ,`TaxAmount` = '' ,`TaxRate` = '3.68' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665221991' WHERE `Matrix_Unique_ID` = '211617008' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-07T22:08:16.430' ,`MLSNumber` = '19670115' ,`ListAgentFullName` = 'Mario Negron' ,`ListOfficeName` = 'Century Communities Houston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.074599' ,`Longitude` = '-95.237135' ,`PhotoCount` = '18' ,`PostalCode` = '77365' ,`RoomCount` = '5' ,`ListPrice` = '290745.00' ,`Status` = 'Active' ,`StreetName` = 'Auburn Cabin' ,`StreetNumber` = '22335' ,`StreetSuffix` = 'Lane' ,`City` = 'Porter' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1602' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful brand new home by Century Communities! Great features in this home include granite countertops in kitchen and all baths, 42 inch cabinets, whirlpool brand appliances, tankless water heater, covered patio, separate tub and shower, full sod front and back, home automation powered by Google, coach lights and more! \r\n\r\nElevation: D\r\nInterior Color Package: 3' ,`Acres` = '' ,`Area` = '40' ,`BuilderName` = 'Century Communities' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Porter/New Caney East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 7, Block 1, Section 14' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '790' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'KINGS MANOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PORTER HIGH SCHOOL (NEW CANEY)' ,`SchoolMiddle` = 'WOODRIDGE FOREST MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Woodridge Forest' ,`TaxAmount` = '' ,`TaxRate` = '3.68' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665221991' WHERE `Matrix_Unique_ID` = '211617817' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-07T22:11:40.130' ,`MLSNumber` = '63781713' ,`ListAgentFullName` = 'Justin McClung' ,`ListOfficeName` = 'Keller Williams Woodlands' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.066946' ,`Longitude` = '-95.585580' ,`PhotoCount` = '49' ,`PostalCode` = '77375' ,`RoomCount` = '17' ,`ListPrice` = '650000.00' ,`Status` = 'Active' ,`StreetName` = 'Olde Mint House' ,`StreetNumber` = '11106' ,`StreetSuffix` = 'Lane' ,`City` = 'Tomball' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4452' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning 2-story custom home situated on an almost 1-acre lot in the quiet gated community of Albury Manor! Inside you are welcomed by beautiful arches, architectural detail and high ceilings. The spacious family room provides a perfect space for entertaining, featuring gas-log fireplace and sprawling views of the backyard. The inviting kitchen has been updated to include stainless steel upgraded appliances, refaced cabinetry, recessed lighting, soft-close drawers and an updated pantry. Numerous entertaining areas throughout the 1st floor including the den, breakfast room and flex room. Also on the 1st floor is the sizable primary suite with updated resort-style primary bath, as well as a \"hobby room\" that could be a 5th bedroom. Upstairs boasts a spacious game room, 3 secondary bedrooms and 2 secondary bathrooms. Outside you will find a sprawling backyard with multiple patio areas. This home is a one-of-a-kind gem with a country feeling, but within the suburbs!' ,`Acres` = '0.8421' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Spring/Klein/Tomball' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 21 ALBURY MANOR U/R ABST 70 E SMITH' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '36682' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '870' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'BERNSHAUSEN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN CAIN HIGH SCHOOL' ,`SchoolMiddle` = 'ULRICH INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Albury Manor' ,`TaxAmount` = '8715' ,`TaxRate` = '2.1373' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '1985' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665221992' WHERE `Matrix_Unique_ID` = '211634602' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-07T22:28:09.690' ,`MLSNumber` = '48998216' ,`ListAgentFullName` = 'Faye Ausmus' ,`ListOfficeName` = 'Ausmus Premier Properties, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.435121' ,`Longitude` = '-95.622451' ,`PhotoCount` = '15' ,`PostalCode` = '77356' ,`RoomCount` = '7' ,`ListPrice` = '583662.00' ,`Status` = 'Active' ,`StreetName` = 'Pine Branch' ,`StreetNumber` = '153' ,`StreetSuffix` = '' ,`City` = 'Montgomery' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2827' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful Modern Craftsman style Home. Backs up to a wooded area. Large family room to enjoy interaction with family and friends while cooking Modern Gas Fireplace, High Ceilings, 8\' Doors throughout. Large Windows for Natural Light. Large Back Porch facing the woods. The Kitchen features a 9\' Island, Quartz counters, 42\" Custom Built Cabinets, Easy Glide Doors and Drawers. . Bronze or black hardware and light fixtures throughout. Stone and Stucco exterior (attached floor plan subject to change without notice by builder)' ,`Acres` = '0.2388' ,`Area` = '39' ,`BuilderName` = 'SKA' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S261540 - BENTWATER 40, BLOCK 1, LOT 20' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot' ,`LotSize` = '10400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1300' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'LINCOLN ELEMENTARY SCHOOL (MONTGOMERY)' ,`SchoolHigh` = 'MONTGOMERY HIGH SCHOOL' ,`SchoolMiddle` = 'MONTGOMERY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Craftsman' ,`Subdivision` = 'Bentwater' ,`TaxAmount` = '569' ,`TaxRate` = '2.1898' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665221992' WHERE `Matrix_Unique_ID` = '211877006' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-07T22:44:57.940' ,`MLSNumber` = '26659439' ,`ListAgentFullName` = 'Claudia Johnson' ,`ListOfficeName` = 'Nextgen Real Estate Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.829737' ,`Longitude` = '-95.736489' ,`PhotoCount` = '18' ,`PostalCode` = '77449' ,`RoomCount` = '5' ,`ListPrice` = '299999.00' ,`Status` = 'Active' ,`StreetName` = 'Clay Landing' ,`StreetNumber` = '20814' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2214' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully maintained 4bed/2.5 bath home zoned to the highly sought after Katy ISD! Sellers have done an extensive upgrade list which includes; brand new A/C, brand new roof, Foundation repair, new light fixtures, new appliances, brand new carpet, and new paint throughout. The first floor features a combo living/dining area, utility room, half bath, and a massive backyard with large covered patio and no back neighbors!! All bedrooms upstairs including a bonus game room. The primary bedroom is huge! This bedroom has two large closets, built in vanity, shower/tub combo, and plenty of storage space. Home has never flooded and located entirely out of a flood zone. Call or text to schedule your private showing today!' ,`Acres` = '0.1212' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 6 BLK 1 BRIDGEWATER MEADOW SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5281' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'MCROBERTS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MORTON RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'MCDONALD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Bridgewater Mdw Sec 01' ,`TaxAmount` = '5510' ,`TaxRate` = '2.8233' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665221992' WHERE `Matrix_Unique_ID` = '211890016' --> 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','212021840','1665221992','212021840','2022-10-07T23:14:19.207','67418790','Andrea Buchhold','Realty United','','','29.400413','-95.239443','43','77511','4','415000.00','Active','Pecan','2714','Street','Alvin','4','0','5','2753','Single-Family','This beautiful fully remodeled Mid-Century Style Ranch home is move in ready! Compete with a large master suite, Mother in law suite, 2 living rooms, granite counter tops, & so much more! The POOL and covered patio makes your backyard oasis perfect for entertaining. This home sits on a cul-de-sac with a large driveway & plenty of parking. No HOA! Minutes away from the highway & major roads. Perfect for families, those who love to entertain, as a long term rental, or even a short term rental! So many extras you don\'t want to miss this gem!','0.327','5','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','Wood Burning Fireplace','1','Alvin South','Central Electric','0','MEYERLAND (ALVIN), LOT 25 SEC 2','Cul-De-Sac,Subdivision Lot','14244','Survey','','','0','','0','Electric Oven','1','In Ground','','Electric Cooktop','','Composition','3 - Alvin','WALT DISNEY ELEMENTARY SCHOOL','ALVIN HIGH SCHOOL','ALVIN JUNIOR HIGH SCHOOL','Accompany,Appointment Required,Leave Business Card,Supra Keybox,Vacant/Unoccupied','Appraisal District','1','Contemporary/Modern,Other Style,Ranch','Meyerland Alvin','7054','2.8854','Public Sewer,Public Water','1968','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-07T22:40:06.487' ,`MLSNumber` = '74738264' ,`ListAgentFullName` = 'Violeta Bessiere' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.006198' ,`Longitude` = '-95.475457' ,`PhotoCount` = '47' ,`PostalCode` = '77068' ,`RoomCount` = '8' ,`ListPrice` = '639999.00' ,`Status` = 'Active' ,`StreetName` = 'Twin Fountains' ,`StreetNumber` = '2830' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3398' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous custom built 3 Bed, 3 1/2 bath home nestled in the exclusive community of The Fountains of Northgate Forest subdivision! Northgate Forest, is a 440-acre master planned residential golf community located just 18 miles north of downtown Houston. The Fountains community is the latest and final golf-course-fronting collection of homesites to be developed in Northgate Forest. This spacious floor plan has open-concept kitchen, exclusive wet bar open to family room and dinning, fireplace, rare to find custom built Alder wood cabinets and engineered wood floors, travertine tiles and a large covered outdoor patio set up for an outdoor kitchen. Professionally landscaped this incredible custom home in an exclusive neighborhood could be yours!' ,`Acres` = '0.1803' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '1960/Cypress Creek North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 7 BLK 1 FOUNTAINS OF NORTHGATE FOREST' ,`LotDesciption` = 'In Golf Course Community,On Golf Course' ,`LotSize` = '7856' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '3000' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'PAT REYNOLDS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTFIELD HIGH SCHOOL' ,`SchoolMiddle` = 'EDWIN M WELLS MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Mediterranean' ,`Subdivision` = 'FOUNTAINS OF NORTHGATE FOREST' ,`TaxAmount` = '11844' ,`TaxRate` = '2.7092' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1665221992' WHERE `Matrix_Unique_ID` = '212067713' --> 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','212256102','1665221992','212256102','2022-10-07T23:05:40.717','74887169','Angelica Vazquez','City Insight Houston','','','29.603002','-95.454065','31','77053','3','185000.00','Active','Macridge','4911','Boulevard','Houston','2','0','3','1250','Single-Family','Come check out this home! Easy access to the beltway and 288! Measurements are approximate, please verify!','0.1515','18','','','','','Sellers Disclosure,Tenant Occupied','','','','Five Corners','Central Gas','1','LT 69 BLK 2 BRIARWICK SEC 1','Other','6600','Appraisal District','','82','0','','0','','0','','','Electric Cooktop','','Composition','27 - Houston','REAGAN K-8 EDUCATION CENTER','MADISON HIGH SCHOOL (HOUSTON)','REAGAN K-8 EDUCATION CENTER','Appointment Required,Leave Business Card,Request Online Appointment','Appraisal District','1','Other Style,Traditional','Briarwick Sec 01','2129','2.3307','Public Sewer,Public Water','1966','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-07T22:52:01.287' ,`MLSNumber` = '17352282' ,`ListAgentFullName` = 'Cindy Boutwell' ,`ListOfficeName` = 'Boutwell Properties LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.991109' ,`Longitude` = '-95.637883' ,`PhotoCount` = '46' ,`PostalCode` = '77429' ,`RoomCount` = '10' ,`ListPrice` = '525000.00' ,`Status` = 'Active' ,`StreetName` = 'Cantwell' ,`StreetNumber` = '14818' ,`StreetSuffix` = 'Bend' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3396' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This Beautiful two story home has 4 bedrooms, 3 and a half baths and a oversized 2 car garage. Located in the highly desirable Longwood Village Subdivision. The home is located right on the Longwood golf course with a LARGE lot, big enough to add a pool and still have the desired grassy area for kids and pets to play! Lets not forget that newly added 1,000 sqft concrete stamped patio! Perfect for hosting guests! The large island kitchen offers generous storage space with its many cabinets and butlers pantry. Kitchen also has updated stainless steel appliances. The master bedroom is its own retreat within the home with a stunning view overlooking the golf course. The attached master bath complements this retreat feel with its jetted tub, separate shower and his and her walk-in closets. The spacious utility/ laundry room is a perfect space for food storage and a second fridge/freezer. Home also includes a breakfast room, dinning room, game room and office/study. Schedule a showing today!' ,`Acres` = '0.2532' ,`Area` = '10' ,`BuilderName` = 'David Weekley' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 3 LONGWOOD VILLAGE SEC 9' ,`LotDesciption` = 'Cul-De-Sac,In Golf Course Community,On Golf Course,Subdivision Lot' ,`LotSize` = '11030' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1070' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection 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` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Longwood Village' ,`TaxAmount` = '9873' ,`TaxRate` = '2.4837' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '1997' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665221992' WHERE `Matrix_Unique_ID` = '212463375' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-07T22:33:57.130' ,`MLSNumber` = '11819318' ,`ListAgentFullName` = 'Jennifer Pena' ,`ListOfficeName` = 'UTR TEXAS, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.494703' ,`Longitude` = '-95.059767' ,`PhotoCount` = '49' ,`PostalCode` = '77573' ,`RoomCount` = '5' ,`ListPrice` = '419900.00' ,`Status` = 'Active' ,`StreetName` = 'Yaletzi' ,`StreetNumber` = '2627' ,`StreetSuffix` = 'Lane' ,`City` = 'League City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1889' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this beautiful one story 3 bedroom + study home with a gorgeous pool in the sought after Tuscan Lakes Community! Enormous cul-de-sac lot with no back neighbors. As you enter the home you will immediately appreciate the abundance of natural light, high ceilings and open concept. Gourmet kitchen including stainless steel appliances, granite counter tops, ceramic tile, large island, and barstool seating. This home features a spacious family room with gas fireplace tons of windows overlooking the backyard. Primary bedroom is spacious with neutral colors and backyard/pool views. Relaxing primary bathroom with dual vanities, tile flooring, separate soaking tub and walk- in shower. Secondary bedrooms are spacious with ample closet space. The ultimate backyard oasis awaits you with your very own private pool, palapa, and plenty of yard to entertain. Community features walking trails, pool, splash pad. Prime location close to I 45, 146 & 96. Call today to schedule your showing!' ,`Acres` = '0.2898' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'TUSCAN LAKES SEC SF 55-2 SE & 60-2 SE (2017) ABST 19, BLOCK' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '12624' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '475' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Above Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'SILBERNAGEL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'DUNBAR MIDDLE SCHOOL (DICKINSON)' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Tuscan Lakes Sec Sf 55-2 Se & 60' ,`TaxAmount` = '9216' ,`TaxRate` = '3.2297' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665221993' WHERE `Matrix_Unique_ID` = '212469529' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-07T23:21:35.957' ,`MLSNumber` = '64122485' ,`ListAgentFullName` = 'David Levin' ,`ListOfficeName` = 'RE/MAX Grand' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.692200' ,`Longitude` = '-95.827502' ,`PhotoCount` = '34' ,`PostalCode` = '77406' ,`RoomCount` = '7' ,`ListPrice` = '385000.00' ,`Status` = 'Active' ,`StreetName` = 'Sandermeyer' ,`StreetNumber` = '11406' ,`StreetSuffix` = 'Drive' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2176' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home!!! This is a stunningly elegant LAKEFRONT Beazer Home in the gated community of Westheimer Lakes. The home features a grand foyer with 11\' ceilings, 3 large bedrooms, 2 full baths, with a split & open living floor plan. The large kitchen comes with an abundance of 42\" custom wood cabinetry, SS appliances and sleek granite countertops. The expansive 23\'x16\' family room is sure to impress with a full wall of windows overlooking the entire lake adding tons of natural lighting. You will enjoy plenty of privacy, a walk in closet & serene lakefront views from your 15\'x14\' master suite, or just simply wind the day down on your backyard patio. Westheimer Lakes is a master planned community with easy access to a all major hwys, shopping, HEB, and entertainment. Low 2.5% tax rate! This energy efficient home has been kept in immaculate condition by the original owners and will rival any new home build!' ,`Acres` = '0.1987' ,`Area` = '37' ,`BuilderName` = 'Beazer Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'CANYON SPRINGS AT WESTHEIMER LAKES SEC 1, BLOCK 2, LOT 24' ,`LotDesciption` = 'Subdivision Lot,Water View,Waterfront' ,`LotSize` = '8657' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1150' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'BENTLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Canyon Spgs At Westheimer Lakes' ,`TaxAmount` = '6270' ,`TaxRate` = '2.5248' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665221993' WHERE `Matrix_Unique_ID` = '212486621' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-07T23:16:49.043' ,`MLSNumber` = '34444437' ,`ListAgentFullName` = 'Lisa Flores' ,`ListOfficeName` = 'RE/MAX Grand' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.549242' ,`Longitude` = '-95.763773' ,`PhotoCount` = '47' ,`PostalCode` = '77471' ,`RoomCount` = '12' ,`ListPrice` = '448000.00' ,`Status` = 'Active' ,`StreetName` = 'Fisher Bend' ,`StreetNumber` = '6319' ,`StreetSuffix` = 'Lane' ,`City` = 'Rosenberg' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3537' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'LIVE IN LUXURY AND GET IT ALL WITHOUT BREAKING THE BANK! EXQUISITE WESTIN HOME ADORNED WITH DETAIL & CHARACTER THROUGHOUT THE HOME,EVEN DOWN TO THE HAMMERED COPPER SINK IN POWDERROOM! HARDWOODS, GRANITE,CUSTOM UPGRADES THROUGHOUT SPARKS BUYERS THAT TRULY ENJOY A HOME GARNISHED WITH TASTEFUL ARCHITECT!LOCATED CLOSE TO SHOPPING,RESTAURANTS,PARKS,DOGGIE PARKS,NEIGHBORHOOD POOL. EASY ACCESS TO HWY 59 & 99. PICTURES DO SAY A 1,000 WORDS! LET YOUR HONEY SEE THIS HOME AND LOOK NO MORE! HONEY I\'M HOME!!' ,`Acres` = '0.1797' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'THE RESERVE AT BRAZOS TOWN CENTER SEC 1, BLOCK 5, LOT 17' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7828' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '950' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'PHELAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR CONSOLIDATED HIGH SCHOOL' ,`SchoolMiddle` = 'WESSENDORF/LAMAR JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'The Reserve At Brazos Town Center Sec 1' ,`TaxAmount` = '8438' ,`TaxRate` = '2.7148' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2011' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665221993' WHERE `Matrix_Unique_ID` = '212526592' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-07T22:28:55.977' ,`MLSNumber` = '10320848' ,`ListAgentFullName` = 'Yvette Williams' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.810373' ,`Longitude` = '-94.896018' ,`PhotoCount` = '27' ,`PostalCode` = '77523' ,`RoomCount` = '10' ,`ListPrice` = '314999.00' ,`Status` = 'Active' ,`StreetName` = 'Laurel' ,`StreetNumber` = '8102' ,`StreetSuffix` = 'Lane' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2649' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Country Meadows: This spacious 4 bedroom home comes with a large game room and offers an extra bonus room above the garage. Backyard is completely fenced in and has a covered back patio. Desired corner lot. Roof replaced in 2015. Check out the 3-D tour link and take a virtual walk-thru.' ,`Acres` = '0.174' ,`Area` = '53' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Baytown/Chambers County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 43 COUNTRY MEADOWS SEC 4' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '7579' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '175' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'CLARK ELEMENTARY SCHOOL (GOOSE CREEK)' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (GOOSE CREEK)' ,`SchoolMiddle` = 'GENTRY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Country Mdws Sec 4' ,`TaxAmount` = '7039' ,`TaxRate` = '2.8882' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665221993' WHERE `Matrix_Unique_ID` = '212570168' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-07T22:04:37.750' ,`MLSNumber` = '16321694' ,`ListAgentFullName` = 'Greg Bennett' ,`ListOfficeName` = 'Greg Bennett Fine Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.622290' ,`Longitude` = '-95.588778' ,`PhotoCount` = '43' ,`PostalCode` = '77478' ,`RoomCount` = '9' ,`ListPrice` = '465000.00' ,`Status` = 'Active' ,`StreetName` = 'Fox Briar' ,`StreetNumber` = '403' ,`StreetSuffix` = 'Lane' ,`City` = 'Sugar Land' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3617' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'We are proud to present this Sugar Land Meticulously Maintained home in Sugar Creek! This 3617 square foot 2 story 4 bedroom 3+ bath has 3 living areas! The Living room is 22x20 with plenty of light from the large picture window! The Family room is graced with handsome wainscoting (wood paneling) faux beams, a fireplace w/inviting hearth, large window w/ views to the back & patio. This flows into the Breakfast room, kitchen, & wet bar. The Kitchen\'s handsome cabinetry is graced by granite countertops & white appliances: Double ovens & gas cooktop. Next, 2 Large Bedrooms on the first floor! The Master Bdrm at the end of the hallway for privacy grants outdoor access through private doors. Master Bath has double sinks, a Large shower, walk-in closets plus a sit down make-up vanity. Upstairs find two large bedrooms, a large game room & Jack & Jill Bath. Outside backyard is set up for many activities from gardening, victory garden, workshop in the oversized garage with storage' ,`Acres` = '0.2114' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SUGAR CREEK SEC 10, BLOCK 3, LOT H & (PTS) 24,25' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot' ,`LotSize` = '9209' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'DULLES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DULLES HIGH SCHOOL' ,`SchoolMiddle` = 'DULLES MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sugar Creek' ,`TaxAmount` = '7873' ,`TaxRate` = '2.0094' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1975' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665221993' WHERE `Matrix_Unique_ID` = '212608314' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-07T22:23:18.690' ,`MLSNumber` = '16437968' ,`ListAgentFullName` = 'Melissa Rod' ,`ListOfficeName` = 'The Real Estate Service' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.631703' ,`Longitude` = '-95.791439' ,`PhotoCount` = '49' ,`PostalCode` = '77406' ,`RoomCount` = '11' ,`ListPrice` = '625000.00' ,`Status` = 'Active' ,`StreetName` = 'Silverbelle' ,`StreetNumber` = '4711' ,`StreetSuffix` = 'Court' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2663' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 4711 Silverbelle Court/Woods Edge Subdivision. This magnificent brick, 4 bedrooms, 2 baths, 3 car garage, split floor plan sits on 1.71 +/- acres with beautiful towering trees, stables, tack room and dog kennel facilities. The grand foyer takes you directly into the family area with floor to ceiling wood burning fireplace, raised ceiling and skylights. The fomal dining room flows easiliy into the kitchen area boasting granite counters, electric cooktop, oven, dishwasher, fridge and microwave then leads to the breakfast room, laundry room and door to covered porch/pool area. Amazing sunroom allows natural light to enter while relaxing and enjoying your morning cup of coffee and beautiful view of your inground pool and green space. You will love this master suite which includes built-ins, jetted tub, separate shower, double vanities & walk in closet. Spacious bedrooms, bath with double vanities & tub/shower combo compliment the guest wing of this home. So much to offer!' ,`Acres` = '1.71' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'WOODS EDGE SEC 1, LOT 5, ACRES 1.71' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '74488' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '85' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'FROST ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'FOSTER HIGH SCHOOL' ,`SchoolMiddle` = 'WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Back' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Woods Edge Sec 1' ,`TaxAmount` = '7663' ,`TaxRate` = '1.6948' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1990' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665221993' WHERE `Matrix_Unique_ID` = '212633269' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-07T22:08:52.667' ,`MLSNumber` = '56591804' ,`ListAgentFullName` = 'Uriel Rodriguez' ,`ListOfficeName` = 'Realty World Elite Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.003803' ,`Longitude` = '-95.172741' ,`PhotoCount` = '49' ,`PostalCode` = '77346' ,`RoomCount` = '10' ,`ListPrice` = '510000.00' ,`Status` = 'Active' ,`StreetName` = 'Harvest Glen' ,`StreetNumber` = '6906' ,`StreetSuffix` = 'Drive' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2933' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Nestled in the desired Pinehurst of Atascocita subdivision. This well maintained home, welcomes you upon entrance with its soaring ceiling in foyer. The many features and updates will make you fall in love at first sight.\r\nHome features beautiful upgraded hardwood flooring with a large living room area, surround sound and plantation shutters throughout home. The primary retreat located in the first floor features dual vanities, separate shower, large garden tub and large walk in closet. There are 3 bedrooms upstairs, a full bathroom and a huge game room for entertainment. Backyard oasis features a custom built outdoor patio with stone flooring, heated pool and spa with inside lights that change color at night.\r\nThree car garage with built in 220volt outlet for compressor or generator usage.\r\nRefrigerator, washer and dryer not included.\r\nSchedule your appointment today and make this your forever Home!' ,`Acres` = '' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Atascocita North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 5 BLK 32 PINEHURST OF ATASCOCITA 8 AMND' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10801' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'PINEFOREST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ATASCOCITA HIGH SCHOOL' ,`SchoolMiddle` = 'ATASCOCITA MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Pinehurst/Atascocita Sec 8' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665221994' WHERE `Matrix_Unique_ID` = '212647514' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-07T22:23:19.470' ,`MLSNumber` = '89408758' ,`ListAgentFullName` = 'Calvin Davis' ,`ListOfficeName` = 'Texas Premier Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.015983' ,`Longitude` = '-95.552782' ,`PhotoCount` = '32' ,`PostalCode` = '77379' ,`RoomCount` = '8' ,`ListPrice` = '319000.00' ,`Status` = 'Active' ,`StreetName` = 'Megan Springs' ,`StreetNumber` = '17314' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2346' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to this elegant One story home on a beautiful lot, boasting 4 bedrooms. Located in the highly sought after neighborhood of Champion Springs Village! From the moment you enter, you will be amazed at all the upgrades this lovely home has to offer, including crown molding in the entry way and high ceilings. Formal dining room is right off the kitchen....No need for formal dining, no problem you can turn this into a study. The kitchen has plenty of room to entertain and is open to the living room. The owners suite is privately tucked away in the back corner of the home, which includes an oversized ensuite. Fresh paint on all the walls and trims to make this an easy move in. The large backyard has a covered and extended patio, which is great for entertaining. This family friendly neighborhood features excellent schools, a community pool, catch and release pond, park, trails, restaurants close by & more!' ,`Acres` = '0.1653' ,`Area` = '13' ,`BuilderName` = 'Pulte Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 7 BLK 2 CHAMPION SPRINGS VILLAGE' ,`LotDesciption` = 'Other' ,`LotSize` = '7200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '680' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'KRAHN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN CAIN HIGH SCHOOL' ,`SchoolMiddle` = 'KLEB INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Champion Spgs Village' ,`TaxAmount` = '4995' ,`TaxRate` = '2.3266' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665221994' WHERE `Matrix_Unique_ID` = '212729334' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-07T23:56:01.030' ,`MLSNumber` = '15209088' ,`ListAgentFullName` = 'Gary Swafford' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = 'Kim Paquette' ,`SellingOfficeName` = 'W Realty & Investment Group' ,`Latitude` = '29.779081' ,`Longitude` = '-95.689713' ,`PhotoCount` = '44' ,`PostalCode` = '77094' ,`RoomCount` = '9' ,`ListPrice` = '375000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Brookes Bend' ,`StreetNumber` = '18019' ,`StreetSuffix` = 'Bend' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2101' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful Trendmaker one story home in highly desirable Green Trails Crossing, just minutes from I-10 and the Energy Corridor. The many features include large open living area with gas log fireplace, formal dining room and private study with french doors. The eat-in kitchen includes an island with cooktop, breakfast bar, 42 inch cabinets, granite counter tops and stainless steel appliances. Serene master suite with adjacent bonus room for private retreat, library, work out space or nursery. Gorgeous master bath with oversized frameless shower and garden whirlpool tub. Roof replaced (2021), oven (2021), Never flooded per seller. Clean and well maintained.\r\nKaty ISD !!' ,`Acres` = '0.1515' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 10 BLK 2 GREEN TRAILS CROSSING SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1148' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'PATTISON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TAYLOR HIGH SCHOOL (KATY)' ,`SchoolMiddle` = 'MCMEANS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Green Trails Crossing' ,`TaxAmount` = '7231' ,`TaxRate` = '2.3533' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1996' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665221994' WHERE `Matrix_Unique_ID` = '212747884' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-07T22:19:59.497' ,`MLSNumber` = '77010776' ,`ListAgentFullName` = 'Evelyn Deharde' ,`ListOfficeName` = 'Texas 1st Choice Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.409342' ,`Longitude` = '-95.042446' ,`PhotoCount` = '35' ,`PostalCode` = '77568' ,`RoomCount` = '9' ,`ListPrice` = '299500.00' ,`Status` = 'Active' ,`StreetName` = 'Trawler' ,`StreetNumber` = '2826' ,`StreetSuffix` = 'Place' ,`City` = 'La Marque' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1650' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to Seacrest Subdivision! This beautiful 2017 LGI Home has had 1 owner only!! It is a 3-bedroom 2.5 bath with a taste of Paradise in the Backyard! This home has many upgrades, including Quartz Countertops with Granite Backsplash in the kitchen. The kitchen cabinets were recently painted! The flooring downstairs has been ugraded and the Custom Pool and Pergola were added in 2021. Sellers are leaving the refrigerator and the TV wall mounts. This community has Walking Trails, Disc Golf Course, Splash Pad, Pavillion, Playground and a Park! You are in a perfect location to be minutes away from Houston and Galveston! Not in a flood zone and No Back Neighbors!! Call to make an appointment today!!' ,`Acres` = '0.1351' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 10 BLK 3 SEACREST SEC 1 (2018) ABST 11' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '5883' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '375' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'LOBIT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'LOBIT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Seacrest Sec 1' ,`TaxAmount` = '7081' ,`TaxRate` = '3.5512' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665221994' WHERE `Matrix_Unique_ID` = '212775458' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-07T23:39:37.867' ,`MLSNumber` = '10079416' ,`ListAgentFullName` = 'Gayla Gayden' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.532927' ,`Longitude` = '-95.061078' ,`PhotoCount` = '50' ,`PostalCode` = '77573' ,`RoomCount` = '15' ,`ListPrice` = '499900.00' ,`Status` = 'Active' ,`StreetName` = 'Scottsdale' ,`StreetNumber` = '2331' ,`StreetSuffix` = 'Court' ,`City` = 'League City' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3535' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to South Shore Harbour Golf Community. The Ultimate in Private Communities W/Controlled Gated Access & 24-Hour Guard! No Flooding during any of the Storms! This Custom Home is Located On Corner Cul De Sac Lot W/2 1/2 Detached Deep Bay Garage & Workshop! Grand Entry W/High Ceilings & Custom Light Fixtures throughout! Amazing Study W/Fireplace! Elegant Formal Dining W/Butler Bar! Family Rm W/Corner Fireplace that flows into the Gourmet Kitchen & Casual Dining! Gourmet Kitchen Boast Dramatic Tall Custom Cabinets W/Pull Out Doors, Beautiful Granite Counters, Stainless Steel Built In Appliances, Wet Bar, Walk In Pantry & More! Media/Game Rm Down W/Entertainment Center W/Granite Counters & Custom Cabinets! Private Suite Down W/ Private Bathrm for Disabled Access W/Huge Shower! Owners Suite W/High Ceilings, Custom Floors & Spa Bathrm W/Huge His & Her Sinks Vanity, Body Spa Shower, Deep Whirlpool Tub & Custom Walk In Closet! Upstairs 2 Private Bedrms & Full Bathrm! Huge Covered Patio!' ,`Acres` = '0.2433' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 18 M MULDOON SUR LOT 9 BLK 1 SOUTH SHORE HARBOUR SEC 20' ,`LotDesciption` = 'Corner,Cul-De-Sac,In Golf Course Community,Subdivision Lot,Wooded' ,`LotSize` = '10599' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '115' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'FERGUSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'CLEAR CREEK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'South Shore Harbour' ,`TaxAmount` = '8825' ,`TaxRate` = '2.0697' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665221994' WHERE `Matrix_Unique_ID` = '212814869' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-07T23:26:51.803' ,`MLSNumber` = '7862058' ,`ListAgentFullName` = 'Sarah Llanes' ,`ListOfficeName` = 'TBT Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.037343' ,`Longitude` = '-95.420956' ,`PhotoCount` = '21' ,`PostalCode` = '77531' ,`RoomCount` = '6' ,`ListPrice` = '380000.00' ,`Status` = 'Active' ,`StreetName` = 'Woodridge' ,`StreetNumber` = '108' ,`StreetSuffix` = 'Crossing' ,`City` = 'Clute' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2272' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 108 Woodridge Crossing in the highly desirable Woodshore Subdivision. A lovely neighborhood with great sidewalks for those evening strolls. This beautiful, fully brick home features 3 bedrooms, 2 bathrooms and a large study with all the upgrades. Enjoy cool mornings with your coffee on the covered back porch with custom roll down shades on each side. Ensuite bath not only has soaker tub but includes a separate walk-in super shower with built in bench. Beautiful double recessed ceiling in the dining room adds elegance to the already 12 ft ceilings throughout the home. Main living area is wired for sound and custom sound system stays. Carpet in main living areas replaced in August 2022. Third car garage bay is a great upgrade to the home providing extra room for storage & leaving a full size garage for all your parking needs. You won\'t want to miss this high quality home!' ,`Acres` = '0.1724' ,`Area` = '5' ,`BuilderName` = 'Castlerock Community' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Clute' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'WOODSHORE SEC 2 (A0066 J E GROCE) (CLUTE) BLK 1 LOT 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7510' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '0' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'POLK ELEMENTARY SCHOOL (BRAZOSPORT)' ,`SchoolHigh` = 'BRAZOSWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'CLUTE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodshore Sec 2 A0066 J E Gro' ,`TaxAmount` = '8470' ,`TaxRate` = '2.6231' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665221995' WHERE `Matrix_Unique_ID` = '212843359' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-07T23:18:09.680' ,`MLSNumber` = '24049029' ,`ListAgentFullName` = 'Lisa Flores' ,`ListOfficeName` = 'RE/MAX Grand' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.826063' ,`Longitude` = '-95.723963' ,`PhotoCount` = '46' ,`PostalCode` = '77449' ,`RoomCount` = '10' ,`ListPrice` = '340000.00' ,`Status` = 'Active' ,`StreetName` = 'Avery Point' ,`StreetNumber` = '20307' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3413' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'THIS STUNNING HOME WILL LET YOU EMBRACE THE OPEN SPACE IN THE LIVING ROOM THAT COMES WITH A FIREPLACE THAT HAS A TILE BACK SPLASH AND A SHINY CRISP WHITE WOOD MANTEL. A 5 BEDROOM HOME THAT HAVE GENEROUS SPACE IN EACH OF THEM. A PRIMARY SUITE LOCATED IN THE FIRST FLOOR COMES WITH ITS OWN BATH. UPSTAIRS ARE MORE BEDROOMS AND BATHS, AND THE MEDIA ROOM. THE KITCHEN FEATURES A LARGE ISLAND WITH ABUNDANT STORAGE SPACE. THE BREAKFAST ROOM HAS A BEAUTIFUL LIGHT FIXTURE AND THREE PERFECTLY PLACED WINDOWS THAT WILL ALLOW THE FLOW OF NATURAL LIGHT. THIS HUGE HOUSE HAS BEEN METICULOUSLY MAINTAINED AND CARED FOR. COME AND SCHEDULE YOUR VISIT TODAY!' ,`Acres` = '0.1516' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 5 BLK 4 WESTFIELD TERRA SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6604' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '440' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'MCROBERTS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MORTON RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'MCDONALD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Westfield Terra' ,`TaxAmount` = '6352' ,`TaxRate` = '2.3983' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665221995' WHERE `Matrix_Unique_ID` = '212872269' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-07T23:05:43.040' ,`MLSNumber` = '33717325' ,`ListAgentFullName` = 'Jermaine Salazar' ,`ListOfficeName` = 'Ai Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.665106' ,`Longitude` = '-95.011614' ,`PhotoCount` = '27' ,`PostalCode` = '77571' ,`RoomCount` = '3' ,`ListPrice` = '275000.00' ,`Status` = 'Active' ,`StreetName` = 'Ohio' ,`StreetNumber` = '319' ,`StreetSuffix` = 'Street' ,`City` = 'La Porte' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1022' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to this charming remodeled home! This home features tons of upgrades inside, a new wood fence combined with a sliding wrought iron fence for easy access to the back, and a new driveway! Come take a look at this cozy home in La Porte!' ,`Acres` = '0.4304' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'La Porte/Shoreacres' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 9 THRU 14 BLK 65 BAY FRONT TO LA PORTE' ,`LotDesciption` = 'Cleared,Corner' ,`LotSize` = '18750' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '35 - La Porte' ,`SchoolElementary` = 'LA PORTE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA PORTE HIGH SCHOOL' ,`SchoolMiddle` = 'LA PORTE J H' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Bay Front La Porte' ,`TaxAmount` = '2090' ,`TaxRate` = '2.7208' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665221995' WHERE `Matrix_Unique_ID` = '212957142' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-07T22:51:04.363' ,`MLSNumber` = '57556110' ,`ListAgentFullName` = 'Mia Strnad' ,`ListOfficeName` = 'City Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.090696' ,`Longitude` = '-95.698304' ,`PhotoCount` = '24' ,`PostalCode` = '77377' ,`RoomCount` = '7' ,`ListPrice` = '305000.00' ,`Status` = 'Active' ,`StreetName` = 'Rosebush Hill' ,`StreetNumber` = '22650' ,`StreetSuffix` = 'Road' ,`City` = 'Tomball' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1689' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'LOCATION!!! Gorgeous new one story home, has a very smart layout for family togetherness, also perfect for entertaining, oversized island in the kitchen, lots of natural light coming in, beautiful floors. Backyard door is from the kitchen - makes it easy to entertain family and guests inside or outside. Home is located few minutes from highway, great Tomball school disctrict, elementary school very close by. Tons of shopping 11 minutes away and HEB coming soon.' ,`Acres` = '' ,`Area` = '35' ,`BuilderName` = 'Colina Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Tomball' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Rosehill Meadow Section 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4900' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '580' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'ROSEHILL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'TOMBALL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Rosehill Meadow Sec 1' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1665221995' WHERE `Matrix_Unique_ID` = '212957429' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-07T22:27:24.747' ,`MLSNumber` = '21471469' ,`ListAgentFullName` = 'Kasia Mccormick' ,`ListOfficeName` = 'Compass RE Texas, LLCHeights' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.783805' ,`Longitude` = '-95.393946' ,`PhotoCount` = '50' ,`PostalCode` = '77007' ,`RoomCount` = '9' ,`ListPrice` = '1150000.00' ,`Status` = 'Active' ,`StreetName` = 'Arlington' ,`StreetNumber` = '712' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2662' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautifully renovated historic Heights 4BD/3BA shines with expansive living space, a wonderful indoor-outdoor layout and lovely architectural details throughout. A manicured yard and covered porch invite you inside to discover hardwood floors, tall ceilings, handsome millwork and large windows with stained glass and shutters. An open-plan living/dining room flows to an exceptional gourmet kitchen. An adjacent family room opens to a screened-in porch. Enjoy al fresco entertaining in the easy-care yard featuring a brick patio, turf lawn and planter beds. A bedroom suite on this level features a WIC and private bath. A secondary bedroom, guest bath, study, laundry and mudroom complete the main level. Above, a barn door reveals a sprawling owner\'s retreat/game room with an en suite spa bathroom. The long driveway and large attached two-car garage provide ample parking for vehicles. Outstanding tree-lined street close to the Heights Trail, parks, restaurants and Harvard Elementary.' ,`Acres` = '0.1515' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 15 BLK 257 HOUSTON HEIGHTS' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HARVARD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Houston Heights Add' ,`TaxAmount` = '23830' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1920' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665221995' WHERE `Matrix_Unique_ID` = '212977158' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-07T22:52:01.287' ,`MLSNumber` = '63319801' ,`ListAgentFullName` = 'Agata Krawczyk' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.741162' ,`Longitude` = '-95.800485' ,`PhotoCount` = '23' ,`PostalCode` = '77494' ,`RoomCount` = '6' ,`ListPrice` = '345000.00' ,`Status` = 'Active' ,`StreetName` = 'Lily Ranch' ,`StreetNumber` = '3526' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1731' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming and extremely well maintained one story 3 bed/2 bath home located on a wide, quiet cul-de-sac with a front covered porch overlooking the beautiful greenbelt. Tile floor throughout the house, granite counter tops and a walking distance to a near by Supermarket, Starbucks, walking trails and more. Perfect rental property or your forever home. Zoned to exemplary KISD schools. Refrigerator, washer & dryer negotiable. Never flooded! Home is ready for you!\r\nShowings will be allowed only at the Open House on Friday and Saturday.' ,`Acres` = '0.142' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'KATY CREEK RANCH SEC 6, BLOCK 2, LOT 27' ,`LotDesciption` = 'Cul-De-Sac,Greenbelt,Subdivision Lot' ,`LotSize` = '6184' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '410' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'RYLANDER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CINCO RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'CINCO RANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Temporarily No Showings' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Katy Creek Ranch Sec 6' ,`TaxAmount` = '5085' ,`TaxRate` = '2.3545' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2010' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665221996' WHERE `Matrix_Unique_ID` = '213006503' --> 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','213115385','1665221996','213115385','2022-10-07T22:47:09.337','95200613','Christopher Guillotte','BHGRE Gary Greene','','','29.809081','-94.978503','32','77521','4','274999.00','Active','Clear Sea','7415','Circle','Baytown','2','1','3','2140','Single-Family','EXTRA LARGE BACKYARD! Not only are you within 2 minutes of I-10, you are also within minutes of just about any restaurant or retail of your choosing. ALL BEDROOMS Up with a beautiful and relaxing primary bath with tons of closet space. EXTENDED covered back patio with plenty of room to entertain. Updated flooring throughout the home and solar screens to help keep the house cool during those HOT summer days. Updated appliances with tons of cabinet space and walk-in pantry. Check out the spacious office space for all of remote working needs or use it as a game room where the kids can play with friends. This home won\'t last long. Hurry! Call the agent for your private tour.','0.2498','2','','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Gaslog Fireplace','1','Baytown/Harris County','Central Gas','1','LT 5 PRESTON PLACE SEC 3','Cul-De-Sac,Subdivision Lot','10881','Appraisal District','','290','0','','2','Gas Oven','0','','','Gas Cooktop','','Composition','23 - Goose Creek Consolidated','VICTORIA WALKER ELEMENTARY SCHOOL','GOOSE CREEK MEMORIAL','HIGHLANDS JUNIOR HIGH SCHOOL','Appointment Required,Lockbox Front,Supra Keybox','Appraisal','2','Traditional','Preston Place','6146','3.095','Public Sewer,Public Water','2005','Appraisal'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-07T22:22:09.660' ,`MLSNumber` = '38789423' ,`ListAgentFullName` = 'Nusrat Ghafoor' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.775373' ,`Longitude` = '-95.172782' ,`PhotoCount` = '35' ,`PostalCode` = '77015' ,`RoomCount` = '3' ,`ListPrice` = '179900.00' ,`Status` = 'Active' ,`StreetName` = 'Duncum' ,`StreetNumber` = '14148' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1063' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful completely updated 3-bedroom 2 bath home close to everything. Nice size living room and Dining room! Fully updated kitchen with Quartz countertops, backsplash and brand-new stainless-steel appliances! Two bedrooms have 2 fully updated attached full bathrooms! Laminate flooring throughout! No carpet! Huge Lot with plenty of parking space! Very close to I-10!' ,`Acres` = '0.1403' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 24 BLK 107 CLOVER LEAF SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6111' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '21 - Galena Park' ,`SchoolElementary` = 'CLOVERLEAF ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTH SHORE SENIOR HIGH SCHOOL' ,`SchoolMiddle` = 'NORTH SHORE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Clover Leaf Sec 01' ,`TaxAmount` = '1728' ,`TaxRate` = '2.5853' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665221996' WHERE `Matrix_Unique_ID` = '213131850' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-07T22:08:35.820' ,`MLSNumber` = '88123187' ,`ListAgentFullName` = 'Ann Stripling' ,`ListOfficeName` = 'United Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.779495' ,`Longitude` = '-95.761882' ,`PhotoCount` = '27' ,`PostalCode` = '77450' ,`RoomCount` = '9' ,`ListPrice` = '275000.00' ,`Status` = 'Active' ,`StreetName` = 'Provincial' ,`StreetNumber` = '22502' ,`StreetSuffix` = 'Boulevard' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1926' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Truly a diamond in the rough! The possibilities are endless for this charming 1-story that’s perfectly situated on a huge corner lot! In addition to being directly across from West Memorial Elementary, it sits adjacent to WM Jr. High and boasts a fabulous, heated pool and hot tub w/ plenty of space to build an outdoor kitchen or fireplace! The garage has insulated doors and 2 window units making it conversion ready. In addition to its prime location, the unique features such as formal entry; den & formal dining and extra-large secondary bedrooms make this home one-of-a-kind! It’s a must see! Don’t forget to ask about the non-realty items being offered!! Home is being sold As-Is.' ,`Acres` = '0.2351' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Southeast' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 23 BLK 18 WEST MEMORIAL SEC 2' ,`LotDesciption` = 'Corner,Other' ,`LotSize` = '10240' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '520' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'WEST MEMORIAL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TAYLOR HIGH SCHOOL (KATY)' ,`SchoolMiddle` = 'WEST MEMORIAL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Right Side,Request Online Appointment,Temporarily No Showings,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'West Memorial Sec 02' ,`TaxAmount` = '4194' ,`TaxRate` = '2.4233' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1974' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665221996' WHERE `Matrix_Unique_ID` = '213188241' --> 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','213208628','1665221996','213208628','2022-10-07T23:20:54.117','50811571','Ana Patricia Torres','Winhill Advisors - Kirby','','','29.860721','-95.443610','18','77091','3','220000.00','Active','BUNCHE','6702','Drive','Houston','2','0','3','1508','Single-Family','ABSOLUTELY BEAUTIFUL, 3 BEDROOM 2 BATH, ONE STORY HOME, NEW CONSTRUCTION, GRANITE THROUGHOUT THE KITCHEN AND BATHROOMS, OPEN CONCEPT WITH A LARGE ISLAND TABLE, AMPLE BACK YARD WITH PLENTY OF ROOM FOR PLAY OR PETS.','','9','','','Electric Dryer Connections,Gas Dryer Connections','','No Disclosures','1','','','Northwest Houston','Central Electric,Central Gas','0','TR 195 BLK 6 CARVER ESTATES','Other','4750','Appraisal District','','','0','','0','','0','','','','','Composition','1 - Aldine','ANDERSON ACADEMY','CARVER H S FOR APPLIED TECH/ENGINEERING/ARTS','DREW ACADEMY','Lockbox Front','Appraisal District','1','Traditional','CARVER ESTATES','','','Public Sewer,Public Water','2020','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-07T22:24:01.513' ,`MLSNumber` = '22345011' ,`ListAgentFullName` = 'Kelley Brouillette' ,`ListOfficeName` = 'Berkshire Hathaway HomeServices Premier Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.635574' ,`Longitude` = '-95.766749' ,`PhotoCount` = '33' ,`PostalCode` = '77406' ,`RoomCount` = '5' ,`ListPrice` = '349000.00' ,`Status` = 'Active' ,`StreetName` = 'Fox Vale' ,`StreetNumber` = '2911' ,`StreetSuffix` = 'Court' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1674' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Better than new Devon Builders\' home nestled on over-sized cul-de-sac and tree lined back yard. Stone and brick front elevation, with all four sides of the home brick! New extended back patio for entertaining. Home has wood tile flooring throughout all rooms except bedrooms and office with frize carpet. Granite on all counters! Upgraded tile in bath areas and shower. Office has French doors. Island kitchen with large walk-in pantry. 5 Burner gas cooktop and all stainless appliances. Tankless hot water heater! Front and back yard sprinkler system. Low E double paned windows, smart thermostat and smart home wired. Pride of ownership shows on this one!' ,`Acres` = '0.1824' ,`Area` = '37' ,`BuilderName` = 'Devon Street' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'MCCRARY MEADOWS SEC 2, BLOCK 1, LOT 70' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '7947' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'FROST ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'FOSTER HIGH SCHOOL' ,`SchoolMiddle` = 'WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Mccrary Meadows' ,`TaxAmount` = '3060' ,`TaxRate` = '2.8548' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665221996' WHERE `Matrix_Unique_ID` = '213210166' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-07T22:52:01.287' ,`MLSNumber` = '11559553' ,`ListAgentFullName` = 'Bertha Saenz' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.835671' ,`Longitude` = '-95.429539' ,`PhotoCount` = '23' ,`PostalCode` = '77018' ,`RoomCount` = '4' ,`ListPrice` = '375000.00' ,`Status` = 'Active' ,`StreetName` = 'Ella' ,`StreetNumber` = '4818' ,`StreetSuffix` = 'Boulevard' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1046' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charm, convenience, location; minutes from the loop and all of H-town\'s local attractions! This home features wood flooring in living/dining and bedroom areas; tile in wet areas. Updated kitchen with tile backsplash, granite countertops, stainless steel appliances; refrigerator and beverage chiller included; spacious backyard, covered patio, and garden beds ready for you to plant your favorite herbs and such! Call for your private tour today.' ,`Acres` = '0.1791' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Shepherd Park Plaza Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 5 BLK 36 OAK FOREST SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'DURHAM ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'BLACK MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Oak Forest Sec 03' ,`TaxAmount` = '7124' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665221996' WHERE `Matrix_Unique_ID` = '213226578' --> 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','213254899','1665221997','213254899','2022-10-07T22:25:33.177','3168773','Bao Ly','Camelot Realty','','','29.740816','-95.556295','39','77042','10','539900.00','Active','Piping Rock','10314','Lane','Houston','2','1','3','2993','Single-Family','Welcome Home to Briar Court! Upon arrival you are met with a circular driveway and a gated front courtyard! Interior of the home offers high ceilings, tiled floors, exposed staircase, lots of storage, an abundance of natural light, and a gas log fireplace. Kitchen has a cozy breakfast area, granite counters and a stainless steel refrigerator. Primary bedroom is tucked away on the first floor and is spacious with high ceilings. Primary ensuite bathroom has a large walk-in shower, double sinks and a walk-in closet. Upstairs you will find two bedrooms, one full bath and a gameroom! Low maintenance backyard includes a pool and covered patio. Community offers a clubhouse, pool and tennis courts. Just a short distance to I-10, City Centre, Memorial City Mall, medical care, restaurants and shopping!','0.126','22','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gaslog Fireplace','1','Briargrove Park/Walnutbend','Central Gas,Zoned','1','LT 11 BLK 6 BRIAR COURT','Subdivision Lot','5490','Appraisal District','','685','0','','2','Electric Oven','1','Gunite,In Ground','','Electric Cooktop','','Composition','27 - Houston','WALNUT BEND ELEMENTARY SCHOOL (HOUSTON)','WESTSIDE HIGH SCHOOL','REVERE MIDDLE SCHOOL','Appointment Required,Lockbox Front','Appraisal District','2','Traditional','Briar Court Corr','11005','2.3307','Public Sewer,Public Water','1982','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-07T23:35:51.387' ,`MLSNumber` = '2159048' ,`ListAgentFullName` = 'Kristen Novicke' ,`ListOfficeName` = 'Texas Trust Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.780982' ,`Longitude` = '-96.161741' ,`PhotoCount` = '24' ,`PostalCode` = '77474' ,`RoomCount` = '6' ,`ListPrice` = '319000.00' ,`Status` = 'Active' ,`StreetName` = '2nd' ,`StreetNumber` = '622' ,`StreetSuffix` = 'Street' ,`City` = 'Sealy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1462' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This Beautifully Remodeled Home is located right in the heart of Old Sealy! 3 Bedrooms and 3 Baths, Spacious living and kitchen, large bedrooms, all with very versatile design choices for the remodel. Beautiful wood floors, tile, countertops and paint colors. The large entryway which leads to the living spaces has so many decorating possibilities. This perfect home is situated near Downtown Sealy, schools, churches and city parks. Don\'t miss out on the opportunity to see this home in person!!' ,`Acres` = '0.2135' ,`Area` = '57' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'SEALY LANDS BLOCK 37 LOT 10 (WEST 1/2 & NORTH 1/2 OF LOT 10)' ,`LotDesciption` = 'Cleared' ,`LotSize` = '9300' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '109 - Sealy' ,`SchoolElementary` = 'SELMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SEALY HIGH SCHOOL' ,`SchoolMiddle` = 'SEALY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Sealy Lands' ,`TaxAmount` = '2245' ,`TaxRate` = '2.149' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1920' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665221997' WHERE `Matrix_Unique_ID` = '213279816' --> 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','213294372','1665221997','213294372','2022-10-07T22:49:03.807','55675927','Morgan Marley','Keller Williams RealtyNortheast','','','30.015582','-95.083160','50','77336','6','295000.00','Active','Hickory Manor','2134','Drive','Huffman','2','0','3','2157','Single-Family','This is what dreams are made of! Gorgeous 1-story fully renovated home now available in the heart of Huffman- NO HOA, LOW TAXES, HALF ACRE, and more! Class & charm collide in the design features with LVP flooring throughout, classic brick wood-burning fireplace, soaring ceilings w/ charming woodwork, modern kitchen w/ SS appliances, shaker cabinets, & QUARTZ counters- all overlooking the large backyard & open to the living room. Don\'t miss that WRAP-AROUND PORCH for those perfect R&R moments. Larger-than-life 2-STORY, 30X30 BARN/GARAGE w/ 350SF loft & 4-car covered parking & covered back patio. Private manual gate! Can you taste those workshop dreams?! Bonus GREENHOUSE in the back! NEW ROOF, new PEX plumbing, commercial-grade electrical conduit throughout, 2016 HVAC, new WATER FILTRATION system & all new sod & landscaping! Zoned to small-town & beloved Huffman ISD schools, easy access to FM2100 & FM1960, and minutes away from Lake Houston for boating/fishing & more!','0.4941','1','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','Wood Burning Fireplace','1','Huffman Area','Central Gas','0','LT 128 BLK 7 FOREST MANOR SEC 2','Subdivision Lot','21525','Appraisal District','','','0','','1','Electric Oven,Single Oven','0','','','Electric Range','','Composition','28 - Huffman','FALCON RIDGE ELEMENTARY SCHOOL','HARGRAVE HIGH SCHOOL','HUFFMAN MIDDLE SCHOOL','Appointment Required,No Supra Keybox,Request Online Appointment','Appraisal District','1','Contemporary/Modern,Traditional','Forest Manor','2648','2.0083','Public Water,Septic Tank','1984','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-07T22:08:25.337' ,`MLSNumber` = '64679515' ,`ListAgentFullName` = 'Sapana Patel' ,`ListOfficeName` = 'Keller Williams Realty -SW' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.564789' ,`Longitude` = '-95.625753' ,`PhotoCount` = '32' ,`PostalCode` = '77479' ,`RoomCount` = '13' ,`ListPrice` = '995000.00' ,`Status` = 'Active' ,`StreetName` = 'Alcorn Bend' ,`StreetNumber` = '3803' ,`StreetSuffix` = 'Drive' ,`City` = 'Sugar Land' ,`BathsFull` = '3' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '4524' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Exquisite Custom Home located on SWCC Golf Course and in highly desirable Alcorn Bend. Nestled in mature trees this elegant stucco boasts an elegant & stately elevation w\\ Three Car Garage & attractive Porte-cochere. Two-story Arched Entry w\\Travertine Flooring w/ open Foyer, a Formal Study w\\Floor to Ceiling Bookcases,& large Arched Window. Formal Dining w\\Custom Built-in China Cabinet. Formal Living w\\Double FP allows Golf Course Views. Large well laid out Chef\'s Kitchen boasts expansive Cabinets, Counter Space, Gas Cook-top, Double Ovens. Butler Pantry with Wet Bar. Coveted Walk-in Attic storage w/built ins. Balcony affords panoramic Golf course views. Nook for Grill located off Kitchen. 2 Powder Baths! You\'ll love the privacy of no back neighbors. New paint, tankless water heater, Three New A/C including a separate unit in the Primary Suite(added 4/22),3 Nest thermostats, new sprinkler system has separate foundation watering zone, new plantation shutters throughout the entire house' ,`Acres` = '0.2527' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Sugar Land South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'ALCORN BEND SEC 2, BLOCK 4, LOT 1' ,`LotDesciption` = 'On Golf Course,Subdivision Lot' ,`LotSize` = '11006' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '810' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'COLONY MEADOWS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEMENTS HIGH SCHOOL' ,`SchoolMiddle` = 'FORT SETTLEMENT MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Mediterranean' ,`Subdivision` = 'Alcorn Bend Sec 2' ,`TaxAmount` = '15496' ,`TaxRate` = '2.1584' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1993' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665221997' WHERE `Matrix_Unique_ID` = '213303029' --> 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','213307582','1665221997','213307582','2022-10-07T23:17:29.273','62035975','Flor Gonzales','Texas United Realty','','','29.644195','-95.141320','30','77505','5','335000.00','Active','Coldstream','6403','Drive','Pasadena','2','1','4','2481','Single-Family','Welcome Home to this beautiful 2 story 4-bedroom brick home in Village Grove. As you drive up to the home you are welcomed by amazing curb appeal with large trees. Spacious floorplan features high ceilings, large den, brick fireplace and good size kitchen with a breakfast area. Natural light throughout the home that fills the interior nicely. Primary bedroom features a large bathroom with a separate shower and oversized tub. On the 2nd level a large game room to spend quality time with the family. Minutes from major grocery stores, shopping malls, Beltway 8. Home sweet home is waiting for you!','0.169','6','','','Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gas Connections','1','Pasadena','Central Gas','1','LT 34 BLK 3 VILLAGE GROVE SEC 1','Cleared','7360','Appraisal District','','280','0','','2','Gas Oven','0','','','Gas Cooktop','','Composition','16 - Deer Park','FAIRMONT ELEMENTARY SCHOOL','DEER PARK HIGH SCHOOL','FAIRMONT JUNIOR HIGH SCHOOL','Accompany,Appointment Required,Supra Keybox','Appraisal District','2','Traditional','Village Grove Sec 01','6849','2.8798','Public Sewer,Public Water','1988','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-07T22:19:48.093' ,`MLSNumber` = '66738582' ,`ListAgentFullName` = 'KeMesha Hall' ,`ListOfficeName` = 'JPAR - The Sears Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.884095' ,`Longitude` = '-95.540235' ,`PhotoCount` = '34' ,`PostalCode` = '77040' ,`RoomCount` = '11' ,`ListPrice` = '549500.00' ,`Status` = 'Active' ,`StreetName` = 'Fern Wood' ,`StreetNumber` = '9526' ,`StreetSuffix` = 'Forest' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3456' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Are you looking for your “Staycation” Dream Home? This Superb home is located in the prestigious & gated Oak Lake Pointe community w/walking trail around the lake leading to the park & pool. As you enter into this 4 bedrooms, 3.5 bath spacious open floor plan, you’ll notice soaring ceilings, crown molding, & stunning vinyl plank flooring. This immaculate home is perfect for any family/social gathering or an escape oasis away from the day-to-day hassle. First-floor master is a true retreat with separate shower/tub & large walk-in closet. Upstairs features a spacious media/game room, 3 bedrooms, two bathrooms one of them a Jack and Jill. The backyard has a resort-quality backyard oasis with a sparkling pool, outdoor kitchen, fire pit, and plenty of green space for entertainment and no rear neighbors. Zoned by the highly acclaimed Cypress-Fairbanks ISD & close to Harmony School of Excellence. Easy access to major traffic corridors & LOW Tax Rate. Schedule your Private tour today!' ,`Acres` = '0.148' ,`Area` = '11' ,`BuilderName` = 'David Powers' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 1 OAK LAKE POINTE AMEND' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '6447' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1403' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Single Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Enclosed,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'POST ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'JERSEY VILLAGE HIGH SCHOOL' ,`SchoolMiddle` = 'COOK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Split Level,Traditional' ,`Subdivision` = 'Oak Lake Pointe Amd' ,`TaxAmount` = '9092' ,`TaxRate` = '2.323' ,`WaterSewer` = 'Public Water,Water District' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665221997' WHERE `Matrix_Unique_ID` = '213311547' --> 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','213319060','1665221997','213319060','2022-10-07T22:38:47.863','98730926','Jared Turner','LennarVillageBldr-JaredTurner','','','30.085540','-95.183273','6','77365','7','425000.00','Active','Sea Star','9414','Lane','Porter','2','0','3','2517','Single-Family','Brand New Lennar Fairway Collection home in Royal Brook at Kingwood! The gorgeous one-story Glenbrook-F floor plan by Lennar, with 3 bedrooms 2 baths and a 2-car garage, provides modern comfort and convenience. Down the foyer is a quiet study ideal for office work, followed by a spacious open-concept family room that merges into the well-equipped kitchen and airy dining room to deliver seamless everyday living. A large covered patio offers enviable outdoor fun and relaxation. In a privately situated corner is the owner’s suite with an attached bathroom and oversized walk-in closet, while at the front of the home are two secondary bedrooms.','','32','Lennar','','','','Mud','1','','','Kingwood East','Central Gas','1','SEC 0017 BLK 003 LOT 014','Subdivision Lot','','','','1200','1','To Be Built/Under Construction','2','','0','','','','','Composition','29 - Humble','SHADOW FOREST ELEMENTARY SCHOOL','KINGWOOD HIGH SCHOOL','RIVERWOOD MIDDLE SCHOOL','Appointment Required','Builder','1','Traditional','Kingwood Royal Brook','','2.58','Public Sewer,Water District','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','213329238','1665221997','213329238','2022-10-07T22:16:10.960','8128330','Nancy Ware','Coldwell Banker Realty, Cy-Fair Office','','','30.003319','-95.791327','35','77447','7','340000.00','Active','Casa Linda','31646','Drive','Hockley','2','0','4','2072','Single-Family','Beautiful home ready for immediate move in. Fantastic location, only a few minutes from 99 and Hwy 290. Located on a large corner lot with full sprinklers. Inside you will find fresh, trendy colors and tons of natural light. You will love the open living area with a kitchen that boasts all stainless appliances, gas cooktop, granite countertops and new island pendant lighting. The owner\'s suite bathroom has an oversized shower and spacious closet. There are three additional bedrooms and a home office. Some recent updated include 4\' shutters and blinds, electric garage door opener, recessed lighting, entry and kitchen island lighting, as well as shrubs, crepe myrtles and full yard sprinklers. Convenient to Houston Premium Outlet mall, dining, churches and hospitals.\r\nCall agent today for private showing.','0.1735','25','Gehan','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','','','Cypress South','Central Electric','1','LT 8 BLK 1 STONE CREEK RANCH SEC 9 R/P','Corner,Subdivision Lot','7556','Appraisal District','','950','0','','2','Electric Oven','0','In Ground','','Gas Cooktop','','Composition','55 - Waller','ROBERTS ROAD ELEMENTARY SCHOOL','WALLER HIGH SCHOOL','WALLER JUNIOR HIGH SCHOOL','Appointment Required,Supra Keybox','Appraisal District','1','Traditional','Stone Crk Ranch Sec 9 Rep 1','8184','3.1924','Water District','2019','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-07T22:04:20.870' ,`MLSNumber` = '22985150' ,`ListAgentFullName` = 'Brenda Quiroga' ,`ListOfficeName` = 'CORCORAN FERESTER REALTY' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.209969' ,`Longitude` = '-95.533083' ,`PhotoCount` = '24' ,`PostalCode` = '77382' ,`RoomCount` = '7' ,`ListPrice` = '399000.00' ,`Status` = 'Active' ,`StreetName` = 'Auburn Path Dr' ,`StreetNumber` = '31' ,`StreetSuffix` = 'Drive' ,`City` = 'The Woodlands' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2020' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fantastic one story home located on a private street less than 1 mile from Alden Bridge Shopping Center. Great open floor plan with high ceilings and an abundance of windows offering plenty of natural light. Formal dining currently used as a study/office. Kitchen and breakfast area open to family room making this home ideal for entertaining. Atrium off breakfast area is perfect for plants lovers. Large family room has built in bookshelves, tv/audio component cabinet, flush mount ceiling surround sound speakers and gas log fireplace. Tile flooring throughout and carpet in bedrooms only. Large primary bedroom has vaulted ceiling, over sized windows and walk in closet. Primary bathroom has another walk in closet, double vanities plus separate tub & shower. Ceiling fans in all bedrooms. Updates include indoor/outdoor paint in 2020. Roof replaced in 2014, AC replaced in 2015 & new water heater in 2017. Full sprinkler system. Walk/bike to shopping center, Lakeside Park & Buckalew Elementary.' ,`Acres` = '0.132' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Owner/Agent' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'WDLNDS VIL ALDEN BR 47, BLOCK 1, LOT 8' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5750' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'BUCKALEW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'THE WOODLANDS HIGH SCHOOL' ,`SchoolMiddle` = 'MCCULLOUGH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Wdlnds Village Alden Br 47' ,`TaxAmount` = '5420' ,`TaxRate` = '2.1811' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665221997' WHERE `Matrix_Unique_ID` = '213331076' --> 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','213345277','1665221997','213345277','2022-10-07T23:16:03.053','50297375','Binh Vo','RE/MAX Northwest, REALTORS','','','30.022987','-95.571458','0','77375','9','330000.00','Active','Memorial Falls','17611','Drive','Tomball','2','0','4','2148','Single-Family','This beautiful move-in ready home 1 story 4-bedroom 2 full baths in Memorial Springs near shopping, restaurants and freeways, located in Klein ISD. This house features high ceilings, island kitchen, formal dining room, granite countertop, 42\"cabinet, stainless steel appliances connected with large living area and cozy fireplace perfect for your family. With newly updated vinyl plank flooring in all bedrooms, fresh interior paint, vanity tops and faucets. Master bedroom Master bath has tub with separate shower, his and hers sinks and walk-in closet. Covered patio has gas line and water and drainage ready for your outdoor kitchen. Buyer(s) to verify all MLS information and the sqft of the home independently.','0.1267','14','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Freestanding,Gaslog Fireplace','1','Spring/Klein/Tomball','Central Gas','1','LT 3 BLK 8 MEMORIAL SPRINGS SEC 4','Subdivision Lot','5519','Appraisal District','','430','0','','2','Freestanding Oven,Gas Oven','0','','','Gas Cooktop,Gas Range','','Composition','32 - Klein','BLACKSHEAR ELEMENTARY SCHOOL (KLEIN)','KLEIN CAIN HIGH SCHOOL','ULRICH INTERMEDIATE SCHOOL','Leave Business Card,Lockbox Front,Supra Keybox','Appraisal District','1','Traditional','Memorial Spgs Sec 04','6129','2.4965','Public Sewer,Public Water','2011','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','213349626','1665221997','213349626','2022-10-07T23:11:01.633','69502874','Judy Tully','Vortex Realty','','','29.824158','-95.510156','25','77080','3','365000.00','Active','Knoll','3302','Street','Houston','2','1','3','1711','Single-Family','Charming , single story home located on a quite cul d sac in Binglewood subdivision of Spring Branch. This 3 bedroom, 2 bath is located in central location minutes from I-10, Hwy 290, and the Beltway access. This bright and airy open floor plan of formal living room, kitchen open to dining and den has been completely updated. Fresh paint, new flooring, new cabinets with soft close ,under cabinet lighting, granite in kitchen and main bath. Roof is 2 years, New AC 2017. All appliances convey, natural gas stand by generator included.\r\n\r\nOPEN HOUSE SUNDAY, 10/9/2022 12:00 NOON - 3:00','0.2603','24','','','Gas Dryer Connections,Washer Connections','','No Disclosures','1','','0','Spring Branch','Central Gas','0','LT 295 BLK 5 BINGLEWOOD SEC 3','Cul-De-Sac','11340','Appraisal District','','','0','','2','Gas Oven','0','','','Gas Range,Grill','','Composition','49 - Spring Branch','EDGEWOOD ELEMENTARY SCHOOL (SPRING BRANCH)','NORTHBROOK HIGH SCHOOL','NORTHBROOK MIDDLE SCHOOL','Leave Business Card,Lockbox Front,Vacant/Unoccupied','Appraisal District','1','Traditional','Binglewood Sec 03','4756','2.4415','Public Water','1957','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-07T23:45:10.593' ,`MLSNumber` = '57626037' ,`ListAgentFullName` = 'Leigh Beard' ,`ListOfficeName` = 'Coldwell Banker Realty, Cy-Fair Office' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.997800' ,`Longitude` = '-95.672279' ,`PhotoCount` = '50' ,`PostalCode` = '77429' ,`RoomCount` = '8' ,`ListPrice` = '319500.00' ,`Status` = 'Active' ,`StreetName` = 'Thistle Rock' ,`StreetNumber` = '15310' ,`StreetSuffix` = 'Lane' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2007' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful one story, 3/4 bedroom, 2 bath home has been lovingly cared for and maintained. Enter into the spacious formal living room with recently updated wood like laminate flooring that extend through to the kitchen & family room. Kitchen has stainless appliances, breakfast bar, serving buffet and cabinets extend all the way to the ceiling. Master bedroom is spacious and features a walk-in closet & en-suite bath. Secondary bedrooms have wood like laminate flooring, ceiling fans and 2 inch blinds. Additionally, there is an office that could be used as a 4th bedroom, soft water system, wrap around gutters, covered back patio, sprinkler system and a spacious fenced in back yard. Stablewood Farms features three community parks within walking distance, basketball court, community pool and splash pad. Home has never flooded. Showings start Saturday 10/8.' ,`Acres` = '0.1388' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 3 BLK 2 STABLEWOOD FARMS NORTH SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6045' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '665' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'FARNEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS WOODS HIGH SCHOOL' ,`SchoolMiddle` = 'GOODSON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Stablewood Farms' ,`TaxAmount` = '5783' ,`TaxRate` = '2.94' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665221997' WHERE `Matrix_Unique_ID` = '213351309' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-07T22:01:32.173' ,`MLSNumber` = '32637889' ,`ListAgentFullName` = 'Robert Kory' ,`ListOfficeName` = 'CENTURY 21 Western Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.839271' ,`Longitude` = '-95.789639' ,`PhotoCount` = '31' ,`PostalCode` = '77493' ,`RoomCount` = '10' ,`ListPrice` = '465000.00' ,`Status` = 'Active' ,`StreetName` = 'Rossini Opera' ,`StreetNumber` = '23831' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2620' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to your new home! This stunning home is located on an over-sized lot with no back neighbors. Featuring 4 Bedrooms and 2.5 Bathrooms, this home has an open concept floorplan with high ceilings and tons of natural light. Large kitchen with plenty storage space and Island. Great sized home office, secondary bedrooms & gameroom. Step into your backyard and find you own personal oasis. This lot has a large, heated, in-ground pool with tons of extra room to add an outdoor kitchen, basketball court or playground! Zoned to HIGHLY ACCLAIMED KISD SCHOOLS. Hurry and schedule your tour today!' ,`Acres` = '0.2647' ,`Area` = '25' ,`BuilderName` = 'DR HORTON' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 22 BLK 1 VENTANA LAKES SEC 12' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '11529' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'BETHKE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKDICK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Ventana Lakes Sec 12' ,`TaxAmount` = '9526' ,`TaxRate` = '3.2768' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665221998' WHERE `Matrix_Unique_ID` = '213369782' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-07T22:39:25.380' ,`MLSNumber` = '87060714' ,`ListAgentFullName` = 'Bonnie Ford' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.811242' ,`Longitude` = '-95.481358' ,`PhotoCount` = '10' ,`PostalCode` = '77055' ,`RoomCount` = '7' ,`ListPrice` = '535000.00' ,`Status` = 'Active' ,`StreetName` = 'West Fall Run Park Dr' ,`StreetNumber` = '2203' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2253' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Study/Home Office. Unobstructed views of the park. Home has a Front yard with it\'s own driveway. Open floor plan, minimum 10\' ceiling heights throughout, Soft Close cabinets and Drawers throughout. Under cabinet lighting in kitchen. High end natural stone and quartz, large kitchen Island, many upgrades. Beautiful gated community with green space centrally located for an open, spacious environment. Centrally located just a few minutes from 610, 290, I-10, The Galleria, Memorial City, Memorial Park.' ,`Acres` = '' ,`Area` = '24' ,`BuilderName` = 'Fall Harbor Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 28 BLK 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '3204' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'TREASURE FOREST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTHBROOK HIGH SCHOOL' ,`SchoolMiddle` = 'LANDRUM MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Fall Run Park' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665221998' WHERE `Matrix_Unique_ID` = '213387832' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-07T23:24:13.827' ,`MLSNumber` = '19149785' ,`ListAgentFullName` = 'Fadi Albana' ,`ListOfficeName` = 'George Kawaja' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.797406' ,`Longitude` = '-95.363050' ,`PhotoCount` = '40' ,`PostalCode` = '77009' ,`RoomCount` = '6' ,`ListPrice` = '489000.00' ,`Status` = 'Active' ,`StreetName` = 'Edison' ,`StreetNumber` = '4101' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2207' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '3 bed / 2.5 Bath | $499K | Built By Revolution Homes | 6 Minute Walk To MetroRail Moody Park Stop (Red Line) | Easy Access To Downtown And Medical Center Via Train | Short drive to I45 - 610 - I10 - 59 | Huge Backyard | Hand Scraped White Oak Flooring Throughout | Upgraded Bosch SS Appliances | All Solid Plywood Custom Cabinets With Soft Close Feature | All Solid Wood Trim Carpentry | Cambria Quartz Countertops | Herringbone Backsplash | Stand Alone Tub In Master Bathroom | Fully Tiled Shower Enclosure | Frameless Shower Surround | Miseno Faucets And Shower Trims | Designer Electrical Fixtures | Recessed LED Lighting Throughout l 16 SEER Dual-Zone HVAC System | All Cedar Fencing | Radiant Barrier Roofing Decking | High Energy Efficiency Rating (HERS) | NT Black Aluminum Low-E Windows l James Hardie Siding | 30 Year High Definition Shingles | Security and Alarm System | Wide Street With No Open Ditches | No HOA Fees | walk to Moody Park' ,`Acres` = '0.06313131' ,`Area` = '9' ,`BuilderName` = 'Revolution Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'Edison Heights, LOT 2, BLK 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2750' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LOOSCAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTHSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'MARSHALL MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Right Side,No Appointment Required,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Edison Heights' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665221998' WHERE `Matrix_Unique_ID` = '213394034' --> 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','213395923','1665221998','213395923','2022-10-07T22:36:03.800','46181658','Erica Barron','LennarVillageBldr-JaredTurner','','','30.037921','-95.799052','6','77447','8','293000.00','Active','Breckenridge Pass','24215','Lane','Hockley','2','0','4','1847','Single-Family','NEW! Lennar Homes Watermill Series, \"Rowan\'\' Plan with Elevation \'\'A\" in Becker Trace! Remarkable One Story with 4 Beds/2 Baths/2 Car Garage! A spacious open floorplan serves as the heart of this single-level home, allowing for seamless flow between the kitchen, dining room and Great Room. At the back of the home is the restful owner’s suite, featuring a cozy bedroom, en-suite bathroom and a walk-in closet. Three more bedrooms are situated off the entry foyer, while a versatile study provides a great space for working remotely.','','35','Lennar','','','','Mud','','','','Hockley','Central Gas','1','SEC 0002 BLK 001 LOT 004','Subdivision Lot','','','','750','1','To Be Built/Under Construction','2','','0','','','','','Composition','55 - Waller','EVELYN TURLINGTON ELEMENTARY SCHOOL','WALLER HIGH SCHOOL','SCHULTZ JUNIOR HIGH SCHOOL','Appointment Required','Builder','1','Traditional','Becker Trace','','3.56','Water District','2022','Builder'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-07T22:47:47.820' ,`MLSNumber` = '50522678' ,`ListAgentFullName` = 'Cody Baranowski' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.137752' ,`Longitude` = '-95.523736' ,`PhotoCount` = '42' ,`PostalCode` = '77389' ,`RoomCount` = '5' ,`ListPrice` = '470000.00' ,`Status` = 'Active' ,`StreetName` = 'Tillamook' ,`StreetNumber` = '15' ,`StreetSuffix` = 'Court' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2242' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A fantastic three-bedroom, two-bath home in Creekside Park, a five-minute walk to the 14-mile Spring Creek Nature Trail. Zoned to highly coveted Creekside Forest Elementary. Spend your time outdoors hiking and biking the miles of trails, swimming in any of the 13 Woodlands pools, or dining al-fresco at nearby restaurants. The home sits on a corner lot in a great cul-de-sac with oaks and crepe myrtles in backyard. Tile and hardwood flooring throughout. Enjoy barbeques in the summer and cozy winter nights by the fireplace. Fresh paint, plantation shutters, walk-in pantry, a study for working from home, and a custom laundry room. High end Thermador appliances with pro style range.' ,`Acres` = '0.1933' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 16 BLK 1 THE WOODLANDS VLG OF CREEKSIDE PARK 5' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '8421' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'CREEKSIDE FOREST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'CREEKSIDE PARK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'The Woodlands Creekside Park 05' ,`TaxAmount` = '8732' ,`TaxRate` = '2.6895' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665221998' WHERE `Matrix_Unique_ID` = '213406085' --> 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','213430351','1665221998','213430351','2022-10-07T23:51:52.820','84115528','Patrice Hightower','HomeSmart','','','29.707481','-95.369295','36','77021','10','725000.00','Active','Parkwood','3328','Drive','Houston','4','0','4','4764','Single-Family','Classic home on lovely street with stately houses and nearby park. Even Houston’s most famous pop superstar pays homage to this historic neighborhood! Owner lovingly maintained; for more modern look consider new decor/renovations. Large kitchen perfect for gatherings with family/friends. Living room gleaming hardwood floors just refinished. Dining room with adjacent butler’s pantry. Roomy bedrooms; balcony in primary. Landing on 2nd floor leads to large study/office. Bonus room ideal for playroom. Welcoming front porch, carport and gated driveway. Close to world-renowned Texas Medical Center hospitals. Major education centers - Rice, UH, Colleges of Medicine - are short drives away. Houston’s vibrant arts and cultural centers in the Museum District and Downtown are close neighbors. Greenspace in nearby Hermann Park - home to the Houston Zoo, Gardens, Golf Course and walking /running trails. All major professional sports venues are easily accessible by car or nearby Metro Rail system.','0.2089','4','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gaslog Fireplace,Wood Burning Fireplace','3','Riverside','Central Gas','0','TRS 13 & 14A BLK 51 RIVERSIDE TERRACE SEC 8','Patio Lot','9100','Appraisal District','','','0','','1','Double Oven','0','','','Gas Cooktop','','Composition','27 - Houston','THOMPSON ELEMENTARY SCHOOL (HOUSTON)','YATES HIGH SCHOOL','CULLEN MIDDLE SCHOOL (HOUSTON)','Appointment Required','Appraisal District','2','Traditional','Riverside Terrace Sec 08','9474','2.3307','Public Sewer,Public Water','1948','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','213444476','1665221998','213444476','2022-10-07T23:44:00.113','25551736','Mustafa Faiz','RE/MAX Signature','','','29.752937','-95.792984','19','77494','4','374995.00','Active','Bright Hollow','25314','Lane','Katy','2','1','4','2128','Single-Family','Zoned to award-winning sought-after schools, this beautiful 2-story home offers four spacious bedrooms, two and a half bathrooms, a cozy living room, dining room, breakfast area, and a game room upstairs. Master suite located downstairs along with utility/laundry room. Open and wide kitchen with granite countertops, clean flooring throughout out, and plenty of windows to welcome natural light fill the entire home. You have got to check out the serene garden in the backyard with the custom water fountain. Enjoy your morning meditation or gather your loved ones for a fun BBQ. This home has everything you are looking for!','0.1374','36','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Gas Connections,Wood Burning Fireplace','1','Katy - Southwest','Central Gas','1','PARKWAY OAKS SEC 4, BLOCK 3, LOT 12','Subdivision Lot','5984','Appraisal District','','500','0','','2','Gas Oven,Single Oven','0','','','Gas Range','','Composition','30 - Katy','RYLANDER ELEMENTARY SCHOOL','CINCO RANCH HIGH SCHOOL','CINCO RANCH JUNIOR HIGH SCHOOL','Appointment Required','Appraisal District','2','Traditional','Parkway Oaks Sec 4','6319','2.7295','Water District','2006','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213448611','1665221999','213448611','2022-10-07T23:54:02.360','40463193','John Badger','Realty Executives','','','30.162432','-95.418526','23','77385','5','245000.00','Active','Flamingo','1319','Street','Conroe','1','1','2','1011','Single-Family','Lake Chateau Woods: VERY popular. Always has been. So close to The Woodlands. A SOLID two bedroom, bath and a half home on two beautiful wooded lots that Seller says have never flooded. Roof is only 6 years old. Very nice and roomy Primary Bedroom with a half bath. The hall bath is just perfect for a home this size with a tub/shower. Excellent 2 car detached garage clad with Hardy plank siding. Perfect starter home for couple, Sweet simple kitchen and a single dining area that can handle a table larger than the one there now. The family room has excellent natural light and it\'s perfect for a basic furniture configuration. There\'s a great view to the spacious back yard. But here\'s something special: the left side yard is shady and big enough for another home. It\'s deed restricted but there\'s no homeowner\'s association or maintenancce fees. The subdivision is delightfully eclectic. Wide variety of homes from small ones like this one up to large homes that go for several hundred grand.','0.4628','15','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','1','Spring Northeast','Central Electric','0','S656007 - LAKE CHATEAU WOODS 07, BLOCK 4, LOT 3-C, 5-A','Cleared,Subdivision Lot,Wooded','20160','Appraisal District','','','0','','2','Electric Oven','0','','','Electric Range','','Composition','11 - Conroe','HOUSER ELEMENTARY SCHOOL','OAK RIDGE HIGH SCHOOL','IRONS JUNIOR HIGH SCHOOL','Lockbox Left Side,Supra Keybox','Appraisal','1','Ranch','Lake Chateau Woods','2468','2.1802','Public Sewer,Public Water','1974','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','213449155','1665221999','213449155','2022-10-07T22:22:36.697','82781948','Michelle Reyna','The Reyna Realty Group','','','29.816327','-95.399019','20','77018','11','450000.00','Active','33rd','118','Street','Houston','2','1','4','1939','Single-Family','Recent construction in the booming neighborhood of Independence Heights. This home has a stella layout with a 4th bedroom/flex room, currently being used as a home office. All appliances to stay. Many upgrades throughout with upgraded tile, designer fixtures, and bold powder bath wallpaper. Covered back patio also tiled. Huge backyard with plenty of room for a pool. Fully fenced with security. Walking distance to Whole Foods, Cottonwood, Orange Theory, Glo Nail spa, and more. This is a terrific walking neighborhood located just across the street from the equally serene Garden Oaks neighborhood. Park within walking distance. Priced to sell!','0.0597','9','','','','','Sellers Disclosure','','','','Northwest Houston','Central Gas','0','LT 18 BLK 79 INDEPENDENCE HEIGHTS PARK','Subdivision Lot','2600','Appraisal District','','','0','','2','','0','','','','','Composition','27 - Houston','BURRUS ELEMENTARY SCHOOL','WASHINGTON HIGH SCHOOL','HAMILTON MIDDLE SCHOOL (HOUSTON)','Appointment Required','Appraisal District','2','Traditional','Independence Heights Park','8274','2.3307','Public Sewer,Public Water','2018','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213449310','1665221999','213449310','2022-10-07T23:01:56.077','60741487','Marcy alBeirakdar','HomeSmart','','','29.468878','-95.103435','25','77539','13','350000.00','Active','Barrington Springs','3006','Lane','Dickinson','2','1','4','2452','Single-Family','Ready just for you! Beautiful open floor plan 4 Bedroom Anglia Built home with 2.5 bathrooms has a large game room upstairs along with all the secondary bedrooms and full bath room. All of the rooms are large 1 of the bedrooms is big enough to be used as an awesome home theater/media room. 2 car garage has extra storage space. Covered patio, pool sized back yard with no back neighbors. Perfect for outdoor activities and entertaining . Call to come and see it today!','0.1435','33','','','Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','League City','Central Gas','1','BAY VIEW SEC 3 (2017) ABST 19, BLOCK 1, LOT 13, ACRES 0.1435','Cleared','6250','Appraisal District','','500','0','','2','Gas Oven','0','','','Freestanding Range,Gas Cooktop','','Composition','17 - Dickinson','BAY COLONY ELEMENTARY SCHOOL','DICKINSON HIGH SCHOOL','DUNBAR MIDDLE SCHOOL (DICKINSON)','Appointment Required,Supra Keybox','Appraisal','2','Other Style','Bay View Sec 3','8619','2.8897','Public Sewer,Public Water','2016','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','213449527','1665221999','213449527','2022-10-07T22:03:02.480','36310422','David Fletcher','Keller Williams Arlington','','','31.431257','-94.821100','26','75969','0','235000.00','Active','US Highway 69','8205','View','Pollok','3','0','0','1716','Single-Family','Don\'t miss this 5 Bedroom 3 Bath home located in the heart of Central ISD. Home is located in between Central High School and Central Elementary off HWY 69. Home Features 5 bedrooms with closets 3 full baths and not mention an attached in-law suite all set up with its own entrance, full bath and living quarters and is handicap accessible. Home has been freshly painted inside and clean outside. A brand new central A/C system and Roof is less that 1 year old. Freshly cleaned and update Septic. Very clean and well taken care of. Call your favorite realtor and schedule your appointment today!','0.624','45','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','0','','','Angelina County','Central Electric','0','ABS 0830 EVANS J.,TRACT 19,ACRES .624,AKA LT 2 CENTRAL SPRIN','Cleared','27181','Appraisal District','','','0','','0','Gas Oven','0','','','Gas Cooktop','','Composition','267 - Central','CENTRAL ELEMENTARY SCHOOL (CENTRAL)','CENTRAL HIGH SCHOOL (CENTRAL)','CENTRAL JUNIOR HIGH SCHOOL (CENTRAL)','Appointment Required,Lockbox Front','Appraisal District','1','Traditional','Central Spring Subdivision','2641','1.717','Aerobic','2003','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','213449821','1665221999','213449821','2022-10-07T22:27:08.400','23956021','Kimberly Walt','RE/MAX RESULTS','','','29.506069','-94.978614','26','77518','4','129900.00','Active','2nd','4810','Street','Bacliff','2','0','2','910','Single-Family','Location is key, blocks from Galveston Bay if you love to fish, boat or just look at the water this is a great place for you. Well maintained with lots of personal touches. Former owner loved and cared for the property and added some great features including Oversized metal building on back side of double lot allows for you to park your boat or golf cart, owner created a great outdoor space under the attached carport to sit out and enjoy the outdoors with out the glare of the sun or the rain. Beautiful tree lined lot provides great shade to help keep the home cooler. Inside you have a large open living, dining, kitchen area and a split bedroom floor plan. Owner converted primary bath shower and made it a large walk in which makes it more handicap accessible. Call a Realtor to schedule a showing or obtain more information.','0.1435','33','','','Electric Dryer Connections,Washer Connections','','Estate,Mud,No Disclosures','','','','Bacliff/San Leon','Other Heating','0','ABST 164 E PAYNE SUR LOTS 3 & 4 BLK 34 CLIFTON BY THE SEA RE','Subdivision Lot','6250','Appraisal District','','','0','','0','Gas Oven','0','','','Gas Range','','Composition','17 - Dickinson','KENNETH E. LITTLE ELEMENTARY SCHOOL','DICKINSON HIGH SCHOOL','DUNBAR MIDDLE SCHOOL (DICKINSON)','Appointment Required','Appraisal District','1','Traditional','Clifton By The Sea','546','2.2342','Water District','1984','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','213450089','1665221999','213450089','2022-10-07T22:52:15.310','52296385','Jessica Kirk','Fathom Realty','','','30.281057','-95.560880','40','77316','4','550000.00','Active','Overland','278','Trace','Montgomery','3','0','4','3539','Single-Family','Designer home with custom upgrades galore! Stone accented hallway, fireplace & over sized Island.\r\nSpacious living area open to deluxe kitchen w/ SS Appliances including double ovens. Nice sized bedrooms with large closets! Formal Dining with tons of natural light. Game Room up adjacent to Media Room (wired for surround sound) Wood floors in main living areas. Unique floorplan with three large bedrooms downstairs with 4th bedroom upstairs along with. Large covered Front & Back patios. Located in the beautiful golfcourse community of Woodforest with amenities including amenities include parks, playfields, walking trails, splash pad, pool, and more!','0.1862','39','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Gas Connections,Gaslog Fireplace','1','Conroe Southwest','Central Gas','1','S965200 - WOODFOREST 01, BLOCK 1, LOT 73','Subdivision Lot','8112','Appraisal District','','1200','0','','2','Double Oven,Gas Oven','0','','','Gas Range','','Composition','11 - Conroe','STEWART ELEMENTARY SCHOOL (CONROE)','CONROE HIGH SCHOOL','PEET JUNIOR HIGH SCHOOL','Appointment Required,Lockbox Front,Request Online Appointment','Appraisal District','2','Traditional','Woodforest 01','9152','2.6888','Public Sewer,Water District','2011','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','213450691','1665221999','213450691','2022-10-07T23:22:23.003','94423687','Kathy Phelan','Brokerology Properties','','','29.816859','-95.279245','29','77028','4','530000.00','Active','Miley','8043','Street','Houston','1','1','4','5432','Single-Family','Resimercial Property!Can be used for Commercial use. Enormous 38x70 (2,660sqft) of WAREHOUSE with electricity,drainage system,concrete pavement all around the warehouse,outside restroom,office in warehouse and fully gated!For Businesses seeking warehouse and house/office space combined.Perfect for automotive shops,personal gym/fitness center,mixed martial arts training center,welders,metal fabricators,steel shops, mechanic,autobody,tire shops, grow house, work shop, possibilities are endless!NO RESTRICTIONS!Ample parking spaces.Leasing together with the warehouse is an adjacent 2,772sqft renovated 4 bedroom home with New Roof,New HVAC fully gated with spacious back yard deck.Makes for perfect live/work.Fast booming area, located close to Downtown Houston,offers easy access to 610,59HWY.Less than 10 miles to Downtown Houston. 15 miles to both George Bush Intercontinental Airport&Hobby Airport.12 miles to Texas Medical Center.Sqft of Property includes(warehouse 2,660sqf+house 2,772sqft).','0.1837','2','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','','','','Northeast Houston','Central Gas','0','LTS 14 & 15 BLK 4 LIBERTY ROAD MANOR SEC 2','Subdivision Lot','12000','Appraisal District','','','0','','2','','0','','','','','Composition','27 - Houston','ELMORE ELEMENTARY SCHOOL','KASHMERE HIGH SCHOOL','KEY MIDDLE SCHOOL','Appointment Required,Lockbox Front,Vacant/Unoccupied','Seller','1','Traditional','Quimby','','','Public Sewer,Public Water','1940','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','213450814','1665221999','213450814','2022-10-07T23:44:51.440','62011141','Cesar Calderon','Camelot Realty','','','29.681420','-95.346843','34','77033','2','140000.00','Active','Burma','4909','Road','Houston','1','0','2','780','Single-Family','Do not miss out! Come see this great opportunity before it\'s gone. You can update, renovate, expand or hold this property in the ever-developing South Park area. New construction and renovations are popping up left and right constantly bringing values up. Call now to schedule a tour today!','0.1463','3','','','','','Sellers Disclosure','','','','Medical Center South','No Heating','0','LT 4 BLK 4 SOUTH PARK 2 SOUTH PARK SEC 2','Subdivision Lot','6372','Appraisal District','','','0','','0','','0','','','','','Composition','27 - Houston','KELSO ELEMENTARY SCHOOL','WORTHING HIGH SCHOOL','ATTUCKS MIDDLE SCHOOL','Appointment Required,Lockbox Front,Request Online Appointment,Vacant/Unoccupied','Appraisal District','1','Traditional','South Park Sec 02','1624','2.3307','Public Sewer,Public Water','1950','Appraisal District'); --> New record created successfully