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-26T07:47:00.007' ,`MLSNumber` = '10891087' ,`ListAgentFullName` = 'Tina Langford' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.613046' ,`Longitude` = '-95.409179' ,`PhotoCount` = '17' ,`PostalCode` = '77047' ,`RoomCount` = '13' ,`ListPrice` = '329500.00' ,`Status` = 'Active' ,`StreetName` = 'Del Papa' ,`StreetNumber` = '13409' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3160' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Attention investors or small business owners! This gated property has a multitude of possibilities! Currently there are 2 \"fixer upper\" homes and a huge workshop on close to 1/2 acre. Conveniently located minutes from 45 & 59 and only 20 minutes from the medical center. Property being sold AS-IS.' ,`Acres` = '0.4362' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Five Corners' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'TRS 31C & 32C BLK 1 MONARCH ESTATES SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '19000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ALMEDA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WORTHING HIGH SCHOOL' ,`SchoolMiddle` = 'LAWSON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Monarch Estates Sec 03' ,`TaxAmount` = '3817' ,`TaxRate` = '2.4994' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '1940' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666789577' WHERE `Matrix_Unique_ID` = '203409394' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-26T07:22:49.923' ,`MLSNumber` = '68010634' ,`ListAgentFullName` = 'Cameron Crouch' ,`ListOfficeName` = 'Gulf Coast Properties' ,`SellingAgentFullName` = 'Jennifer Thomas' ,`SellingOfficeName` = 'Pinnacle Realty Advisors' ,`Latitude` = '29.406268' ,`Longitude` = '-95.419582' ,`PhotoCount` = '49' ,`PostalCode` = '77583' ,`RoomCount` = '10' ,`ListPrice` = '1167500.00' ,`Status` = 'Option Pending' ,`StreetName` = 'County Road 62' ,`StreetNumber` = '3515' ,`StreetSuffix` = '' ,`City` = 'Rosharon' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4823' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fabulous one story home sitting on 10 acres in Iowa Colony/Manvel Area. The home is located a couple minutes to 288, and close proximately to Hwy 6 and Beltway 8. Quick and easy drive to the medical center and all that Houston has to offer. This home features 4 bedrooms and 3 and a half bathrooms. The ornamental steel doors set the stage upon entry. The home incorporates a spacious living room with a stone fireplace, built-ins and large picture windows looking out to the backyard. This home is on spectacular scale with an easy flowing floor plan. The gourmet island kitchen is open to the living area. The study comes complete with built-in cabinetry. The gameroom and media room are on the right wing of the home and feature a wet bar and powder room. The large master suite is on the left wing of the home and includes a spa-like bathroom that features a fireplace, soaking tub, shower and a very large closet. This exceptional home is a must see.' ,`Acres` = '10' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Propane' ,`HOAMandatory` = '0' ,`Legal` = 'A0532 C M HAYS TRACT 519, 519A, 519B ACRES 10' ,`LotDesciption` = 'Cleared' ,`LotSize` = '217800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'C M Hays' ,`TaxAmount` = '13042' ,`TaxRate` = '2.7399' ,`WaterSewer` = 'Aerobic,Well' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666789578' WHERE `Matrix_Unique_ID` = '209641228' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-26T07:20:11.167' ,`MLSNumber` = '13153297' ,`ListAgentFullName` = 'Nolan Obey' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.352922' ,`Longitude` = '-94.177915' ,`PhotoCount` = '29' ,`PostalCode` = '77656' ,`RoomCount` = '2' ,`ListPrice` = '130000.00' ,`Status` = 'Active' ,`StreetName` = '6th' ,`StreetNumber` = '555' ,`StreetSuffix` = 'Street' ,`City` = 'Silsbee' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1152' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '2 bedrooms, 2 baths remodeled home in a great location! This home offers spacious rooms that are completely upgraded with new flooring, carpet, paint, fans and much more. This is a great starter home or the perfect property if you are looking to downsize. Schedule your showing today and make this property yours!' ,`Acres` = '0.18' ,`Area` = '49' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LOT 14 & PART OF 13 BLK 79 SANTA FE TOWNSITE P# S47-79-7 I#' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7841' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Wood Shingle' ,`SchoolDistrict` = '252 - Silsbee' ,`SchoolElementary` = 'SILSBEE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SILSBEE HIGH SCHOOL' ,`SchoolMiddle` = 'EDWARDS-JOHNSON MEMORIAL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Santa Fe Townsite' ,`TaxAmount` = '1513' ,`TaxRate` = '2.3756' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666789578' WHERE `Matrix_Unique_ID` = '210059893' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-26T07:31:43.580' ,`MLSNumber` = '10271657' ,`ListAgentFullName` = 'Victor Chelf' ,`ListOfficeName` = 'Coldwell Banker Realty, Cy-Fair Office' ,`SellingAgentFullName` = 'Dell Tamblyn' ,`SellingOfficeName` = 'RE/MAX Space Center-Clear Lake' ,`Latitude` = '29.866811' ,`Longitude` = '-95.642252' ,`PhotoCount` = '50' ,`PostalCode` = '77084' ,`RoomCount` = '13' ,`ListPrice` = '365000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Baxter' ,`StreetNumber` = '15426' ,`StreetSuffix` = 'Avenue' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '2481' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Smart home, minutes from exemplary Cy-Fair ISD schools, fully renovated in 2021-2022 from the roof to fence and everything in between including: new premium a/c unit and ducts, texture/paint (inside and out), granite countertops, custom built ins with accent lighting, seamless gutters, custom solar screens and blinds, breathtaking tile work with herringbone subway tile backsplash and limestone fireplace surround, Luxurious bathrooms with waterfall faucets, quiet water saver/multifunction toilets, spa shower heads, and large soaking tub. This smart home boasts an owned security system, led lighting throughout, premium stainless steel/ Energy Star appliances such as chef basin sink and a stove featuring griddle burner and oven that doubles as an air fryer! This home misses no details in modernization and convenience and has too many upgrades and items renovated to list!' ,`Acres` = '0.1435' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Eldridge North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 18 BLK 1 LANGHAM CREEK COLONY 2 PAR R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Above Ground' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'HORNE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'TRUITT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Langham Creek Colony 02 Prcl R' ,`TaxAmount` = '5682' ,`TaxRate` = '2.591' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666789578' WHERE `Matrix_Unique_ID` = '210065690' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-26T07:22:01.283' ,`MLSNumber` = '18785128' ,`ListAgentFullName` = 'Juliana Swisher' ,`ListOfficeName` = 'South Haus Living, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.733441' ,`Longitude` = '-95.399705' ,`PhotoCount` = '46' ,`PostalCode` = '77006' ,`RoomCount` = '13' ,`ListPrice` = '1899000.00' ,`Status` = 'Active' ,`StreetName` = 'Bonnie Brae' ,`StreetNumber` = '1601' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '3960' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'JUST COMPLETED as of 10/22! This gorgeous home offers all the features and amenities you\'d find in a brand-new build while keeping intact the beautiful classic architectural details. The brilliantly designed interior spaces feature spacious-sized bedrooms all with private ensuite baths, luxe finishes, a color palette comprised of soft neutral tones, a well-thought-out floor plan, and an abundance of natural light. Situated between Montrose and the Boulevard Oaks area, adjacent to Mandell Park, and a stone\'s throw to fine dining, shopping, the Museum District, excellent schools, and great walkability. Total restoration and renovation that rivals new construction. ' ,`Acres` = '0.1653' ,`Area` = '16' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Montrose' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 15 BLK 10 CASTLE COURT' ,`LotDesciption` = 'Corner' ,`LotSize` = '7200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'POE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LANIER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Castle Court' ,`TaxAmount` = '13054' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1930' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666789578' WHERE `Matrix_Unique_ID` = '210135982' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-26T06:08:25.550' ,`MLSNumber` = '85145732' ,`ListAgentFullName` = 'Jennifer Vidales' ,`ListOfficeName` = 'RE/MAX Opportunities' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.432416' ,`Longitude` = '-95.802186' ,`PhotoCount` = '26' ,`PostalCode` = '77461' ,`RoomCount` = '3' ,`ListPrice` = '200250.00' ,`Status` = 'Active' ,`StreetName` = 'Old Needville Fairchild' ,`StreetNumber` = '9818' ,`StreetSuffix` = 'Road' ,`City` = 'Needville' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1216' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to this adorable country start up. Mobile home is super cute inside with recent floors and cozy kitchen with lots of cabinet space. Located in the back you will find a 1 bedroom, 1 bathroom guest home with large covered patio. Large covered carport and 2 work/storage sheds. From a large enclosed vegetable garden to small area for chickens or small animals, this start up has it all. Playground/swing set stays. PROPANE TANK IS A RENTAL' ,`Acres` = '1.319' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas,Propane' ,`HOAMandatory` = '0' ,`Legal` = '0452 F H FRANZE, ACRES 1.319, MH LABEL #TEX0560919' ,`LotDesciption` = 'Other' ,`LotSize` = '57456' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '38 - Needville' ,`SchoolElementary` = 'NEEDVILLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NEEDVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'NEEDVILLE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'F H Franze' ,`TaxAmount` = '1393' ,`TaxRate` = '1.8957' ,`WaterSewer` = 'Aerobic,Well' ,`YearBuilt` = '1995' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666789578' WHERE `Matrix_Unique_ID` = '210348320' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-26T07:58:03.123' ,`MLSNumber` = '17368205' ,`ListAgentFullName` = 'Phyllis Orman' ,`ListOfficeName` = 'Real Estate Connection Int' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.957982' ,`Longitude` = '-95.272556' ,`PhotoCount` = '36' ,`PostalCode` = '77396' ,`RoomCount` = '13' ,`ListPrice` = '384900.00' ,`Status` = 'Active' ,`StreetName` = 'Oriole Lane' ,`StreetNumber` = '7702' ,`StreetSuffix` = '' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3204' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful one of a kind large two story home (3204 sq ft) ready for move in. The home features 4 bedrooms with 2.5 bath, dining room, study/office and upstairs game room. Open concept kitchen to family room with fireplace. Separate large dining room and private study/office downstairs located in front of home. Utility room downstairs. Beautiful tile flooring throughout down stairs and wood flooring upstairs. Primary bedroom is located off the living area with a large walk in closet, garden tub and shower. Upstairs finds kids retreat with 3 comfortable bedrooms with large windows for natural light and large game/ media room. Backyard has extended patio with added storage. Great location in Humble and No HOA. This property has easy access to shopping, restaurants, and Bush Intercontinental Airport. This home is a must see!!' ,`Acres` = '' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Humble Area East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 3 BLK 5 TIMBERWOOD SEC 9' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '6900' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'JACK M. FIELDS SR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HUMBLE HIGH SCHOOL' ,`SchoolMiddle` = 'ROSS STERLING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Timberwood' ,`TaxAmount` = '' ,`TaxRate` = '2.2965' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666789578' WHERE `Matrix_Unique_ID` = '210432080' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-26T07:16:07.853' ,`MLSNumber` = '24132044' ,`ListAgentFullName` = 'Michelle Marek' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.207827' ,`Longitude` = '-95.333916' ,`PhotoCount` = '16' ,`PostalCode` = '77302' ,`RoomCount` = '10' ,`ListPrice` = '759990.00' ,`Status` = 'Active' ,`StreetName` = 'Camillia' ,`StreetNumber` = '17366' ,`StreetSuffix` = 'Trail' ,`City` = 'Conroe' ,`BathsFull` = '5' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4347' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Enjoy resort-style living in the master planned community of ARTAVIA. From meditation and play areas to community gathering spaces, you will be thrilled by the possibilities that abound just minutes from your home. Enjoy the trails winding their way through the trees and along the boardwalk. Launch your kayak into the five-acre community lake. The brand-new Comal II plan features a traditional brick exterior, 5 bedrooms, 5.5 bathrooms and a 3-car garage. Chef\'s kitchen has Quartz countertops, SS upgraded appliances and custom cabinetry. It is the perfect home for entertaining with an open concept floor plan and covered patio with outdoor kitchen. Primary suite has a spa-like bath with dual sinks, freestanding bathtub, and award-winning walk-through shower. Beautiful finishes and selections throughout the home. Smart home features included with white glove service after closing. J. Patrick Homes recently awarded the GHBA Prism Awards - Volume Builder of the Year Grand Award.' ,`Acres` = '0.2562' ,`Area` = '19' ,`BuilderName` = 'J. Patrick Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'S216905 - ARTAVIA 05, BLOCK 2, LOT 13' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11534' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '995' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'SAN JACINTO ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CANEY CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MOORHEAD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Artavia 05' ,`TaxAmount` = '1799' ,`TaxRate` = '3.1988' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666789579' WHERE `Matrix_Unique_ID` = '210781383' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-26T07:40:50.493' ,`MLSNumber` = '32887675' ,`ListAgentFullName` = 'Hasiyet Keyim' ,`ListOfficeName` = 'Flyers' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.997642' ,`Longitude` = '-95.158352' ,`PhotoCount` = '44' ,`PostalCode` = '77346' ,`RoomCount` = '5' ,`ListPrice` = '399000.00' ,`Status` = 'Active' ,`StreetName` = 'Player Park' ,`StreetNumber` = '19134' ,`StreetSuffix` = 'Drive' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2756' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This custom built 4/2.5/2 home with sparkling pool & spa in the heart of Atascocita! Charming floorplan features Large kitchen with granite counters, Stainless Steel appliances, smooth surface cooktop & lots of cabinet space. Large den with see-thru fireplace views of the Pool and backyard. New wood floors. Master suite down. Large Gameroom & 3 spacious bedrooms up. Tropical paradise. Drive-thru garage!' ,`Acres` = '0.2767' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Atascocita South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 16 BLK 5 GOLFERS VILLAGE WALDEN ON LAKE HOUSTON PH 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '12052' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '275' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Slate' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'MAPLEBROOK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ATASCOCITA HIGH SCHOOL' ,`SchoolMiddle` = 'ATASCOCITA MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Walden On Lake Houston Ph 01' ,`TaxAmount` = '6410' ,`TaxRate` = '2.5885' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1984' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666789579' WHERE `Matrix_Unique_ID` = '211023588' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-26T07:08:46.893' ,`MLSNumber` = '83892847' ,`ListAgentFullName` = 'Nicole Tomczak' ,`ListOfficeName` = 'Solid Real Estate Services' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.248763' ,`Longitude` = '-95.439872' ,`PhotoCount` = '32' ,`PostalCode` = '77302' ,`RoomCount` = '8' ,`ListPrice` = '349000.00' ,`Status` = 'Active' ,`StreetName` = 'Roanoke' ,`StreetNumber` = '568' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2979' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BACK ON THE MARKET! Fully updated one story on the golf course in River Plantation! This 4 bedroom, 2.5 bath one story has a 3 car garage with extra climate controlled storage and a workshop. Think of all the entertaining you could do in this chef\'s kitchen, dining room, bar area, courtyard and extra wide driveway to accommodate all your guests. Recently updated appliances, roof, side fenced area and one brand new AC unit and one less than a year old!! Tile floors throughout, sprinkler system and LOW taxes!\r\nThis property is just shy of .5 acres and located on a quiet culdesac street just minutes from shopping, restaurants, The Woodlands and I45. Easy commute to Exxon, HP and SHSU! Highly rated CISD. Down the street from newly remodeled park and picnic area!\r\nThis home is very popular and will go quick again. Schedule your showing ASAP!' ,`Acres` = '0.439' ,`Area` = '19' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S832004 - RIVER PLANTATION 04, LOT 47' ,`LotDesciption` = 'In Golf Course Community,On Golf Course,Subdivision Lot' ,`LotSize` = '19125' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '203' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'WILKINSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'River Plantation 04' ,`TaxAmount` = '4919' ,`TaxRate` = '2.1648' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1972' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666789579' WHERE `Matrix_Unique_ID` = '211055810' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-26T07:27:21.487' ,`MLSNumber` = '70573674' ,`ListAgentFullName` = 'Melissa Wilson' ,`ListOfficeName` = 'MMW Realty Partners' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.682422' ,`Longitude` = '-95.735022' ,`PhotoCount` = '32' ,`PostalCode` = '77407' ,`RoomCount` = '4' ,`ListPrice` = '464900.00' ,`Status` = 'Active' ,`StreetName` = 'Laila Manor' ,`StreetNumber` = '20226' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2559' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stop your car and come view this lovely 4 bedroom,3 bathroom Coventry home! This home features roaring high ceilings with an open modern concept that includes a separate private office. This home includes a water softener and whole home 22k back up generator! No more sitting with the lights out while you hope Centerpoint crews make it to your street! This home also features a covered back patio. If you are looking for a convenient location in a great neighborhood near lots of shopping..... Book your appointment today!' ,`Acres` = '0.181' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'GRAND MISSION ESTATES SEC 24, BLOCK 4, LOT 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7883' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '895' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'SEGUIN ELEMENTARY (FORT BEND)' ,`SchoolHigh` = 'BUSH HIGH SCHOOL' ,`SchoolMiddle` = 'CROCKETT MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Grand Mission Estates Sec 24' ,`TaxAmount` = '8545' ,`TaxRate` = '2.7529' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666789579' WHERE `Matrix_Unique_ID` = '211160870' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-26T07:27:25.060' ,`MLSNumber` = '50839866' ,`ListAgentFullName` = 'Bradley Tiffan' ,`ListOfficeName` = 'Princeton Classic Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.502342' ,`Longitude` = '-95.403982' ,`PhotoCount` = '46' ,`PostalCode` = '77578' ,`RoomCount` = '9' ,`ListPrice` = '444990.00' ,`Status` = 'Active' ,`StreetName` = 'Indian Wells' ,`StreetNumber` = '83' ,`StreetSuffix` = 'Drive' ,`City` = 'Manvel' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2538' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Love where you live in the gated section of Rodeo Palms in Manvel, TX! The Melodie floor plan is a stunning 2-story home with 4 bedrooms, 3.5 bathrooms, STUDY, game room, AND 3 car garage! This home includes ALL of the designer finishes you\'ve been looking for + a WATER VIEW! The gourmet kitchen is sure to please with 42\" white colored cabinetry, under cabinet lighting, subway tile backsplash, and granite countertops! Retreat to the Owner\'s Suite featuring a gorgeous bay window, separate tub and shower, and granite countertops. Enjoy the great outdoors with a covered patio! Don\'t miss your opportunity to call Rodeo Palms home, schedule a visit today!' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'PRINCETON CLASSIC' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 12 BLK 2 RODEO PALMS-THE LAKES SEC. 3' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '6900' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1500' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'DON JETER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'RODEO PALMS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'RODEO PALMS - THE LAKES' ,`TaxAmount` = '' ,`TaxRate` = '3.7' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666789579' WHERE `Matrix_Unique_ID` = '211512369' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-26T07:26:21.053' ,`MLSNumber` = '98026015' ,`ListAgentFullName` = 'Bradley Tiffan' ,`ListOfficeName` = 'Princeton Classic Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.499980' ,`Longitude` = '-95.397786' ,`PhotoCount` = '48' ,`PostalCode` = '77578' ,`RoomCount` = '7' ,`ListPrice` = '474990.00' ,`Status` = 'Active' ,`StreetName` = 'Indian Wells' ,`StreetNumber` = '79' ,`StreetSuffix` = 'Drive' ,`City` = 'Manvel' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2727' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Love where you live in the gated section of Rodeo Palms in Manvel, TX! The Valiant floor plan is a stunning 2-story home with 4 bedrooms, 3.5 bathrooms, study, game room, HIDDEN ROOM, and a 3-car garage! This home has soaring ceilings and includes ALL of the designer finishes you\'ve been looking for, including wood-look tile flooring! The gourmet kitchen is sure to please with 42\" cabinetry, quartz countertops, and subway tile backsplash! Retreat to the Owner\'s Suite featuring a beautiful bay window, double sinks, separate tub and shower, and a walk-in closet. Enjoy the great outdoors with a large covered patio! Don\'t miss your opportunity to call Rodeo Palms home, schedule a visit today!' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'PRINCETON CLASSIC' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 10 BLK 2 RODEO PALMS-THE LAKES SEC. 3' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '8169' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1500' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'DON JETER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'RODEO PALMS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Rodeo Palms - The Lakes' ,`TaxAmount` = '' ,`TaxRate` = '3.74' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666789580' WHERE `Matrix_Unique_ID` = '211515656' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-26T07:48:39.970' ,`MLSNumber` = '61898927' ,`ListAgentFullName` = 'Juan Barron' ,`ListOfficeName` = 'RE/ImageProperties and Investm' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.803953' ,`Longitude` = '-95.142382' ,`PhotoCount` = '28' ,`PostalCode` = '77530' ,`RoomCount` = '5' ,`ListPrice` = '179000.00' ,`Status` = 'Active' ,`StreetName` = 'Dell Dale' ,`StreetNumber` = '1507' ,`StreetSuffix` = 'Street' ,`City` = 'Channelview' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '947' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Looking for your first home? This one is it! Floors (wood & tile), granite in the kitchen. The bedrooms size need to be verified. This backyard is big enough for all the activities and you will feel secure. HOA includes pool and playground. A must see!' ,`Acres` = '0.132' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S 44 FT OF LT 10 & N 6 FT OF LT 11 BLK 3 STERLING GREEN SEC' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5750' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '8 - Channelview' ,`SchoolElementary` = 'HAMBLEN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CHANNELVIEW HIGH SCHOOL' ,`SchoolMiddle` = 'JOHNSON JUNIOR HIGH' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sterling Green Sec 09' ,`TaxAmount` = '2746' ,`TaxRate` = '2.518' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666789580' WHERE `Matrix_Unique_ID` = '211658345' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-26T06:40:50.037' ,`MLSNumber` = '66478635' ,`ListAgentFullName` = 'Carolyn Kelly' ,`ListOfficeName` = 'RE/MAX Northwest, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.803470' ,`Longitude` = '-95.067763' ,`PhotoCount` = '24' ,`PostalCode` = '77351' ,`RoomCount` = '6' ,`ListPrice` = '242500.00' ,`Status` = 'Active' ,`StreetName` = 'Ivy' ,`StreetNumber` = '169' ,`StreetSuffix` = '' ,`City` = 'Livingston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1811' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'You will love this BEAUTIFUL 2 story home in the Cedar Point Community! Plan features a main floor guest suite. Kitchen highlights include gorgeous cabinets, granite counter tops throughout the home, Stainless steel appliances. In the primary suite, there is a private bath with dual vanity sinks and a walk-in closet. You\'ll will also love the versatile Loft space and a walk in Laundry on the 2nd floor. This property sits on a corner oversized lot. The backyard is fenced with double gates so you can park you boat on in the back yard.\r\n\r\nFor open house call Carolyn when your, at the gate so I can escort you in.' ,`Acres` = '' ,`Area` = '44' ,`BuilderName` = 'WJH LLC' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'CEDAR POINT SECTION 1 BLK 3 LOT 1' ,`LotDesciption` = 'Corner' ,`LotSize` = '6000' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '512' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '104 - Onalaska' ,`SchoolElementary` = 'ONALASKA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ONALASKA JR/SR HIGH SCHOOL' ,`SchoolMiddle` = 'ONALASKA JR/SR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Cedar Point' ,`TaxAmount` = '3211' ,`TaxRate` = '1.72' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666789580' WHERE `Matrix_Unique_ID` = '211765048' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-26T07:55:21.667' ,`MLSNumber` = '80869474' ,`ListAgentFullName` = 'Orquidea Wirges' ,`ListOfficeName` = 'NextHome Real Estate Place' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.748929' ,`Longitude` = '-95.319765' ,`PhotoCount` = '28' ,`PostalCode` = '77011' ,`RoomCount` = '6' ,`ListPrice` = '295000.00' ,`Status` = 'Active' ,`StreetName` = 'Avenue J' ,`StreetNumber` = '5303' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '2' ,`SqFtTotal` = '1648' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful East End Revitalized townhome in the quiet gated Waterhill Homes Community is located in a super convenient location with easy access to downtown Houston and connecting highways. IT HAS A BRAND NEW A/C SYSTEM, high ceilings throughout with tile, laminate wood flooring and carpet only in master bedroom and stairwell. Downstairs has a cozy foyer, with master bedroom and bath and walk in closet and laundry room. Upstairs is the main/open living room, kitchen, dining area perfect for entertaining. Kitchen has granite countertops, tile backsplash and electric range. The powder room is near the living area. Also located upstairs is the second master bedroom with master bath with separate sinks and walk in closet. This is one of the few townhomes in the community with it\'s own PRIVATE GATED GREEN SPACE large enough to create your own beautiful outdoor space for entertaining friends and family.' ,`Acres` = '0.052' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'East End Revitalized' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 38 BLK 2 WATERHILL HOMES ON NAVIGATION STREET' ,`LotDesciption` = 'Corner' ,`LotSize` = '2263' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '144' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BURNET ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'AUSTIN HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'NAVARRO MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Waterhill Homes/Navigation St' ,`TaxAmount` = '5756' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666789580' WHERE `Matrix_Unique_ID` = '211893955' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-26T07:59:17.210' ,`MLSNumber` = '62338311' ,`ListAgentFullName` = 'Tina Langford' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.547697' ,`Longitude` = '-95.056944' ,`PhotoCount` = '40' ,`PostalCode` = '77565' ,`RoomCount` = '8' ,`ListPrice` = '490000.00' ,`Status` = 'Active' ,`StreetName` = 'Dillonwood' ,`StreetNumber` = '2086' ,`StreetSuffix` = 'Court' ,`City` = 'Kemah' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3308' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Hurry! This beauty won’t last long - it truly has it all! The grand entrance with wrought iron double doors lead into the elegant foyer, featuring a wrought iron staircase. The primary bedroom is downstairs with 3 secondary bedrooms, a game room, and fully equipped media room upstairs. The office and formal dining open to the living room, kitchen, and breakfast area. The kitchen is spacious and features an island and granite countertops. Whether you enjoy entertaining or relaxing, the back yard oasis is a tropical dream! Take a dip in the saltwater pool or relax in the Strongspa jacuzzi. Invite friends and family to lounge under the gazebo with ceiling fan, surrounded by a bamboo fence with tiki lights. Must see to believe!!' ,`Acres` = '0.1481' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'TWIN OAKS SUB SEC 2 (2007) ABST 18, BLOCK 1, LOT 11' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '6451' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground,Salt Water' ,`Range` = '' ,`RangeType` = '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,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Twin Oaks Sub Sec 2 2007' ,`TaxAmount` = '7961' ,`TaxRate` = '2.0697' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666789580' WHERE `Matrix_Unique_ID` = '212156432' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-26T07:49:46.630' ,`MLSNumber` = '75715925' ,`ListAgentFullName` = 'Tasha Bason' ,`ListOfficeName` = 'Steel Door Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.266522' ,`Longitude` = '-94.902745' ,`PhotoCount` = '29' ,`PostalCode` = '77327' ,`RoomCount` = '17' ,`ListPrice` = '1690000.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 2293' ,`StreetNumber` = '1270' ,`StreetSuffix` = '' ,`City` = 'Cleveland' ,`BathsFull` = '3' ,`BathsHalf` = '2' ,`BedsTotal` = '11' ,`SqFtTotal` = '5729' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Turn Key Assisted Living Facility! Perfect for Adult Care, Foster Care, Hospice Care, Therapy, Rehab and more! \r\n11 bedrooms that can sleep 24+ adults, 3 Full baths 2 1/2 baths, ADA compliant, wired for fire safety and sprinklered. Kitchen features double oven, 2 dishwashers, 2 refrigerators, 2 sinks and a large pantry. 2 laundry areas in facility, 3 separate gathering areas with a door to separate if desired. Zoned Commercial with sprawling 32 acres, completely fenced in with a large barn and coop, ponds, as well as 2 beautiful horses that can convey.' ,`Acres` = '32' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Liberty County East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = '000407 WM WHITE, TRACT 23, ACRES 10.0' ,`LotDesciption` = 'Cleared,Wooded' ,`LotSize` = '1393920' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '102 - Tarkington' ,`SchoolElementary` = 'TARKINGTON PRIMARY SCHOOL' ,`SchoolHigh` = 'TARKINGTON HIGH SCHOOL' ,`SchoolMiddle` = 'TARKINGTON MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Wm White' ,`TaxAmount` = '6914' ,`TaxRate` = '1.5226' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1971' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666789581' WHERE `Matrix_Unique_ID` = '212174407' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-26T06:57:46.070' ,`MLSNumber` = '8122842' ,`ListAgentFullName` = 'Pamela Walston' ,`ListOfficeName` = 'Realty Results' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.352747' ,`Longitude` = '-95.460176' ,`PhotoCount` = '28' ,`PostalCode` = '77583' ,`RoomCount` = '7' ,`ListPrice` = '160000.00' ,`Status` = 'Active' ,`StreetName` = '1st' ,`StreetNumber` = '16231' ,`StreetSuffix` = 'Street' ,`City` = 'Rosharon' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1432' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'House has been updated with Paint inside and out. Bathroom redone with fixture and plumbing, Electrical inside the home updated, Aerobic septic with brand new pump, Water hearer in house new, home treated for termites and rotten wood replaced. Kitchen cabinets painted. Heater inside home is gas space heaters one in dining and one in bathroom. The seller is a expired realtor. He never lived inside the home. Warranties for one year on Electric work, termite treatment one year and transferable year to year. Workshop has concrete floor and electricity, workbench. Chicken coop and raised garden beds are still have life left. Much more ask the listing agent for sellers full list.' ,`Acres` = '0.241' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Rosharon' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'ROSHARON (A0125 A ROBINSON) BLK 8 LOT 8A (S/2) - LOT 9' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10498' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '5 - Angleton' ,`SchoolElementary` = 'FRONTIER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Rosharon' ,`TaxAmount` = '1341' ,`TaxRate` = '1.986' ,`WaterSewer` = 'Aerobic,Water District' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666789581' WHERE `Matrix_Unique_ID` = '212236415' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-26T06:22:21.967' ,`MLSNumber` = '45517537' ,`ListAgentFullName` = 'Lara Leikam' ,`ListOfficeName` = 'eXp Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.984182' ,`Longitude` = '-95.649186' ,`PhotoCount` = '20' ,`PostalCode` = '77429' ,`RoomCount` = '13' ,`ListPrice` = '410000.00' ,`Status` = 'Active' ,`StreetName` = 'Stonemeade' ,`StreetNumber` = '14923' ,`StreetSuffix` = 'Place' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2766' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Lovely single story home with a great floor plan in the Longwood Village golf course community! Large cul-de-sac lot with an oversized park-like backyard. 3-bedroom, 2.5-bathroom with great flexible floor plan with two additional bonus rooms that can be used for flex space. Enjoy an eat in kitchen complete with island and granite countertops, living room has cozy fireplace and beautiful built ins. Don’t wait to make this home yours!' ,`Acres` = '0.4026' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 11 BLK 3 LONGWOOD VILLAGE SEC 1' ,`LotDesciption` = 'Cul-De-Sac,In Golf Course Community' ,`LotSize` = '17539' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1112' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'HAMILTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CY-FAIR HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Longwood Village' ,`TaxAmount` = '7569' ,`TaxRate` = '2.4837' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1994' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666789581' WHERE `Matrix_Unique_ID` = '212265417' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-26T06:50:01.927' ,`MLSNumber` = '61962780' ,`ListAgentFullName` = 'Noreen Arleth' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.211498' ,`Longitude` = '-95.733170' ,`PhotoCount` = '42' ,`PostalCode` = '77354' ,`RoomCount` = '7' ,`ListPrice` = '370000.00' ,`Status` = 'Active' ,`StreetName` = 'High Holly' ,`StreetNumber` = '505' ,`StreetSuffix` = 'Circle' ,`City` = 'Magnolia' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2094' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'One story home on corner lot in popular subdivision. This is better than new, as everything is done for you. No carpet so there is tile in the wet areas and living and vinyl plank throughout the rest. Study could also be formal dining. Island kitchen is open to den. Split floor plan. Master and one other bath have large walk-in showers. Bathroom three has tub/shower. Covered back porch and privacy fence to keep your pets in your yard. Washer dryer, refrigerator and whole house water softner system will all stay. This is an immaculate home and is ready for new family! Assumable loan with approval.' ,`Acres` = '0.1834' ,`Area` = '15' ,`BuilderName` = 'M/I' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S712203 - MAGNOLIA RIDGE FOREST 03, BLOCK 4, LOT 5' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '7991' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '425' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'WILLIE E. WILLIAMS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA WEST HIGH SCHOOL' ,`SchoolMiddle` = 'MAGNOLIA JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Magnolia Ridge Forest' ,`TaxAmount` = '' ,`TaxRate` = '3.3' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666789581' WHERE `Matrix_Unique_ID` = '212299989' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-26T07:03:08.707' ,`MLSNumber` = '49852313' ,`ListAgentFullName` = 'Michelle Young' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.806958' ,`Longitude` = '-95.706691' ,`PhotoCount` = '40' ,`PostalCode` = '77084' ,`RoomCount` = '3' ,`ListPrice` = '269900.00' ,`Status` = 'Active' ,`StreetName` = 'Ruble' ,`StreetNumber` = '19223' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1636' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BEAUTIFULLY updated home ZONED to KATY ISD! This lovely 1 story is complete with a back patio perfect for grilling and entertaining. The kitchen is ideal for the chef in your life, with lots of countertop space, soft-close cabinet doors and drawers, and stainless steel appliances. Wood tile flooring throughout. Open floor plan. New double pane windows for energy efficiency! Lots of new updates and upgrades! Please contact realtor for a complete list of upgrades.\r\nDid not flood during Harvey.' ,`Acres` = '0.147' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 14 BLK 4 WESTLAKE PLACE SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6405' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'MAYDE CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAYDE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MAYDE CREEK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Westlake Place' ,`TaxAmount` = '4568' ,`TaxRate` = '2.572' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666789581' WHERE `Matrix_Unique_ID` = '212467207' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-26T07:32:51.453' ,`MLSNumber` = '15915316' ,`ListAgentFullName` = 'Julie Chaddick' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.290099' ,`Longitude` = '-95.407027' ,`PhotoCount` = '37' ,`PostalCode` = '77301' ,`RoomCount` = '8' ,`ListPrice` = '549999.00' ,`Status` = 'Active' ,`StreetName` = 'Explorer' ,`StreetNumber` = '3285' ,`StreetSuffix` = 'Way' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4204' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Walking distance to Carl Barton Park. Beautiful MUST SEE, ONE OWNER Home in BARTON WOODS!! Grand foyer with high ceilings with stunning open staircase, an Office with hardwood floors, Primary bedroom has 2 walk-in closets, separate tub/shower. This home has so many extras…..Large kitchen with all stainless steel appliances, with attached breakfast area, extra large pantry, butler’s pantry, formal dining room, all bedrooms have walk in closets, a second family room on the 2nd floor, a 3 car Tandem garage, tons of storage, 3 floored attics, 2 hot water heaters, gas fireplace, and Extra Large Laundry room. The beautiful landscape front and backyards bring great curb appeal. A new roof was added 9/21. The 2018 washer/dryer, security system and water-softener will convey to the new owner. You can walk to the Carl Barton Basketball, Pickle Ball and Tennis Courts! Schedule an appointment TODAY!!' ,`Acres` = '0.2498' ,`Area` = '19' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Southeast' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S249502 - BARTON WOODS 02, BLOCK 5, LOT 22' ,`LotDesciption` = 'Other' ,`LotSize` = '10880' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'WILKINSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Barton Woods' ,`TaxAmount` = '10976' ,`TaxRate` = '2.7863' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666789582' WHERE `Matrix_Unique_ID` = '212741263' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-26T06:44:27.360' ,`MLSNumber` = '89388376' ,`ListAgentFullName` = 'Kelley Clark' ,`ListOfficeName` = 'Realty One Group Optima' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.762533' ,`Longitude` = '-95.877791' ,`PhotoCount` = '44' ,`PostalCode` = '77494' ,`RoomCount` = '5' ,`ListPrice` = '537500.00' ,`Status` = 'Active' ,`StreetName` = 'Orchard Berry' ,`StreetNumber` = '1931' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '3223' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'DON\'T WAIT TO BUILD! Here is the property you\'ve been looking for! This forever home features 5 beds, 4 baths, open concept with amazing floor plan, high ceilings and 8 foot doors to make the whole house feel grand. The oversized backyard has so much potential with an extended patio plumbed for your custom outdoor kitchen. You can easily imagine the pool and firepit to enjoy those Texas sunsets. The utility room is located next to the garage entrance and attached to the primary suite to create a unique and handy walk through. The 3-car garage is something to talk about! Not only does it have plenty of space for a workbench area, but it includes extra built-in storage above the garage doors for all of your holiday decor! Speaking of storage, did you see the extended granite countertops and cabinets in the spacious kitchen? Upstairs has a spacious game room and a cozy media room for those Friday movie nights. Don\'t wait to see this dream home!' ,`Acres` = '0.3371' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'YOUNG RANCH SEC 4, BLOCK 2, LOT 12' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '14683' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1090' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'LINDSEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,No Supra Keybox,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Young Ranch Sec 4' ,`TaxAmount` = '11231' ,`TaxRate` = '3.072' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666789582' WHERE `Matrix_Unique_ID` = '212921448' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-26T06:35:47.447' ,`MLSNumber` = '94954009' ,`ListAgentFullName` = 'Kristin DeBarbieris' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.850386' ,`Longitude` = '-95.593960' ,`PhotoCount` = '32' ,`PostalCode` = '77041' ,`RoomCount` = '12' ,`ListPrice` = '579000.00' ,`Status` = 'Active' ,`StreetName` = 'Barton' ,`StreetNumber` = '5619' ,`StreetSuffix` = 'Falls' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3178' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful home located on a large culdesac, featuring a sparkling saltwater pool & spa in the desirable community of Lakes on Eldridge. The spacious floor plan features a two story foyer that opens into a stunning living room w/ natural light & fireplace overlooking the pool. Off the foyer, is a private study w/ French doors & formal dining room. The eat in kitchen that opens to the living room offers generous cabinet space w/ island & breakfast bar. The 1st floor primary retreat boasts a spa-like bath with double sinks, soaking tub, frameless shower & generous walk-in closet. Upstairs offers 3 beds/2 baths with a game room. Water heaters replaced in 2022 & roof 2020, per seller. Did not flood. Enjoy this resort-like community that offers guarded access gate, patrol, pool, playgrounds, tennis courts, fitness center, volleyball courts & several lakes w/ walking trails. Convenient access to I-10, 290, & Beltway 8. Bus pickup available to Awty International, British & Village Schools.' ,`Acres` = '0.31' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Eldridge North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 5 BLK 1 LAKES ON ELDRIDGE SEC 19 AMEND' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '13504' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1670' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground,Salt Water' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'KIRK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'TRUITT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakes On Eldridge Sec 19 Amd' ,`TaxAmount` = '10017' ,`TaxRate` = '2.471' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666789582' WHERE `Matrix_Unique_ID` = '212931456' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-26T07:43:09.300' ,`MLSNumber` = '42606469' ,`ListAgentFullName` = 'Sandy Brabham' ,`ListOfficeName` = 'Keller Williams RealtyNortheast' ,`SellingAgentFullName` = 'Lisseth DeLeon' ,`SellingOfficeName` = 'RE/MAX Grand' ,`Latitude` = '30.227644' ,`Longitude` = '-95.189272' ,`PhotoCount` = '26' ,`PostalCode` = '77372' ,`RoomCount` = '5' ,`ListPrice` = '225000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Vaughn' ,`StreetNumber` = '15024' ,`StreetSuffix` = 'Road' ,`City` = 'Splendora' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1680' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fully remodeled home on one acre of unrestricted land. The large family room has decorative wood paneling, high vaulted ceilings, wood burning fireplace also surrounded by decorative wood and French doors that lead to the backyard and covered carport. Primary suite is spacious and features a walk in closet and recently replaced carpet. Primary bathroom has tile floors, free standing garden tub, separate tiled shower and double sinks. Kitchen is open to the family room and has \"never been used\" stainless appliances. Secondary bedrooms have walk in closets and recently replaced carpet. Laundry room and walk in pantry located off the kitchen. Property also includes a storage building. Please ask agent for a list of all updates. Here are just a few: paint, trim, crown molding, flooring, deck, stairs, doors, fixtures, appliances, granite, tub, faucets, sinks and toilets. Schedule your appointment today!' ,`Acres` = '' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'A0594 - WILLS WILLIAM, TRACT 1, SERIAL # PH174179A, TITLE #' ,`LotDesciption` = 'Other' ,`LotSize` = '43560' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '47 - Splendora' ,`SchoolElementary` = 'PINEY WOODS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPLENDORA HIGH SCHOOL' ,`SchoolMiddle` = 'SPLENDORA JUNIOR HIGH' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Wills William' ,`TaxAmount` = '1049' ,`TaxRate` = '2.0783' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666789582' WHERE `Matrix_Unique_ID` = '213089565' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-26T07:30:15.470' ,`MLSNumber` = '61543014' ,`ListAgentFullName` = 'Brandy Mayr' ,`ListOfficeName` = 'RE/MAX Northwest, REALTORS' ,`SellingAgentFullName` = 'Elise Diaz' ,`SellingOfficeName` = 'RE/MAX Integrity' ,`Latitude` = '30.118893' ,`Longitude` = '-95.391511' ,`PhotoCount` = '25' ,`PostalCode` = '77386' ,`RoomCount` = '3' ,`ListPrice` = '259000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Legends Bend' ,`StreetNumber` = '29515' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1980' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come home to 29515 Legends Bend Drive in the family oriented Legends Run subdivision - Spring TX. This is a beautiful 2 story, 1980 square foot, brick/siding residence that is being sold \"as is\" and priced to sell !! The downstairs area with living room, dining room and island kitchen is all open and perfect for quality family time and/or entertaining. All three bedrooms are upstairs including the primary bedroom retreat. A great gameroom is also located upstairs as well. Big enclosed backyard with a useful storage shed. Beautiful covered front porch and attached two-car garage. GREAT LOCATION close to the world class shopping, restaurants, waterway and entertainment of The Woodlands. Less than 2 miles to Grand Parkway. Conroe Independent School District. A must see before it\'s GONE! NEW ROOF' ,`Acres` = '0.1165' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LEGENDS RUN 01, BLOCK 6, LOT 20' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5076' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '490' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'BRADLEY ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'GRAND OAKS HIGH SCHOOL' ,`SchoolMiddle` = 'YORK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Legends Run 01' ,`TaxAmount` = '5266' ,`TaxRate` = '2.8187' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666789582' WHERE `Matrix_Unique_ID` = '213090003' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-26T07:53:31.237' ,`MLSNumber` = '19449209' ,`ListAgentFullName` = 'Justin Dickey' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.025995' ,`Longitude` = '-95.084726' ,`PhotoCount` = '32' ,`PostalCode` = '77336' ,`RoomCount` = '4' ,`ListPrice` = '254990.00' ,`Status` = 'Active' ,`StreetName` = 'Emerald Thicket' ,`StreetNumber` = '322' ,`StreetSuffix` = 'Lane' ,`City` = 'Huffman' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1443' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New Colina Homes in Woodland Lakes - On Lake Houston! Colina Homes believes in building your dream home. This beautiful 2 -Story 3 Bedrooms + 2 1/2 Baths + Covered Patio will surely make you feel right at home! Come see this open-concept home with space in all the right places. This beautiful Kitchen features 42” Cabinets + Luxury Granite + Decorative Tile Back splash + Stainless \"Farmhouse\" Single-Bowl Sink +Stainless Frigidaire Dishwasher, Vented Microwave & 5-BURNER GAS RANGE! Luxury Vinyl Flooring at Entry, Kitchen, Dining, Family Room, Hallways, Utility & All Baths. Spacious Master Suite that boasts - double walk-in Closet, Double sinks in the Master bath, 2” Faux Wood Blinds, Tankless Water Heater, 16 SEER Lennox Air System & much more! This Energy Efficient home will SAVE you $$$! PHOTOS ARE REPRESENTATIVE OF FLOOR PLAN.' ,`Acres` = '' ,`Area` = '1' ,`BuilderName` = 'Colina Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Huffman Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 10 Block 2 Sec 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '28 - Huffman' ,`SchoolElementary` = 'FALCON RIDGE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HARGRAVE HIGH SCHOOL' ,`SchoolMiddle` = 'HUFFMAN MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodland Lakes' ,`TaxAmount` = '' ,`TaxRate` = '3.35' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666789583' WHERE `Matrix_Unique_ID` = '213097263' --> 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','213147088','1666789583','213147088','2022-10-26T07:55:47.373','3619540','Kelly Bell','CB&A, Realtors-Katy','','','29.721157','-95.814744','50','77494','7','635000.00','Active','Casper Cliff','26902','Court','Katy','3','1','3','2935','Single-Family','Stunning, in-demand David Weekley 1 Story on a HUGE, park-like yard and +/-18,000 gallon pool w/spa! Backyard is unbelievable w/2 covered patios, an outdoor fireplace & custom pergola! An entertainer\'s dream w/ an open floor plan, large rooms with lots of windows & high ceilings. Chef\'s kitchen with 42\" cabinets w/under-cabinet lighting, granite, extended breakfast bar with under-counter seating. Kitchen open to the family & dining & gorgeous views of the backyard pool & outdoor fireplace w/gas logs! Interior & patio surround sound. Primary bedrm w/large ensuite bath, dual sink vanity, whirlpool tub & sep. shower! Split floor plan & tons of closets & storage! Wood & tile, no carpet! Large utility with space for a refrig & a folding area. This home has the popular Texas Basement w/walk-up staircase to a Huge Floored Attic! Quiet cul-de-sac street, backyard landscape lighting, full sprinkler system & mature lanscaping. The backyard is to-die-for & offers more entertaining & dining areas!','','36','David Weekley','','Electric Dryer Connections,Washer Connections','','Exclusions,Mud,Sellers Disclosure','1','Gaslog Fireplace','1','Katy - Southwest','Central Gas','1','Lot 14, Block 1, Cinco Ranch Southwest Sec 63','Cul-De-Sac,Subdivision Lot','17079','Appraisal District','','1390','0','','2','Convection Oven,Single Oven','1','Gunite,In Ground','','Gas Cooktop','','Composition','30 - Katy','WILSON ELEMENTARY SCHOOL (KATY)','TOMPKINS HIGH SCHOOL','TAYS JUNIOR HIGH SCHOOL','Appointment Required,Leave Business Card,Request Online Appointment,Supra Keybox','Appraisal District','1','Traditional','Cinco Ranch Southwest','','2.7045','Water District','2013','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-26T07:31:21.613' ,`MLSNumber` = '46802701' ,`ListAgentFullName` = 'Melissa Ard' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = 'Kimberly Roberts' ,`SellingOfficeName` = 'Keller Williams Realty - Memorial' ,`Latitude` = '29.605073' ,`Longitude` = '-95.589079' ,`PhotoCount` = '36' ,`PostalCode` = '77478' ,`RoomCount` = '4' ,`ListPrice` = '430000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Medio River' ,`StreetNumber` = '1307' ,`StreetSuffix` = 'Circle' ,`City` = 'Sugar Land' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3010' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'So much to tell you about this WONDERFUL 4 bedroom, 2.5 bath home! Let’s start with the curb appeal featuring beautiful mature trees in the front yard. Next walk into a stunning foyer with formals to the left and right, you will find travertine title floors throughout, freshly custom painted walls, crown molding, plantation shutters in formals. The kitchen is a chef’s delight with double ovens, island, lots of cabinet space, granite counter tops, plenty of room for breakfast table and chairs, large walk-in pantry. Let’s head upstairs where you will find all your bedrooms and custom remolded bathroom with Italian marble, walk in shower w/ bench. Primary is large spacious retreat with en-suite bathroom with separate shower and tub. Two of the bedrooms have lush new carpet, the other two with excellent condition laminate floors. Head back downstairs to the backyard where you can host the next pool party! You can make this your home just in time to host Thanksgiving!' ,`Acres` = '0.191' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'RIVERBEND NORTH, BLOCK 8, LOT 9' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8319' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '850' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'DULLES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DULLES HIGH SCHOOL' ,`SchoolMiddle` = 'DULLES MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Riverbend North' ,`TaxAmount` = '6541' ,`TaxRate` = '2.1594' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1988' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666789583' WHERE `Matrix_Unique_ID` = '213193570' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-26T06:51:47.303' ,`MLSNumber` = '31328360' ,`ListAgentFullName` = 'Stephen Metarelis' ,`ListOfficeName` = 'Offerpad Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.506244' ,`Longitude` = '-95.400818' ,`PhotoCount` = '19' ,`PostalCode` = '77578' ,`RoomCount` = '7' ,`ListPrice` = '317900.00' ,`Status` = 'Active' ,`StreetName` = 'Morro Bay' ,`StreetNumber` = '34' ,`StreetSuffix` = 'Drive' ,`City` = 'Manvel' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2492' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning two-story home in Rodeo Palms Palm Shore Subdivision that is zoned to Alvin ISD. Enter into the living room with high ceilings and an open kitchen with a breakfast nook. Fresh interior paint. The kitchen features granite countertops with new stainless appliances gas stove, dishwasher, and microwave. New AC condenser and water heater. Mostly laminate wood and tile throught with New carpet in a couple of room.. Per previous owner, new ROOF in 5/22. Fully fenced and big backyard. Move-in ready. Quick and easy access to 288.' ,`Acres` = '0.1263' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'RODEO PALMS PALM SHORE (A0299 H T & B) (MANVEL) BLK 1 LOT 17' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5502' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'DON JETER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'RODEO PALMS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Rodeo Palms Palm Shore' ,`TaxAmount` = '9609' ,`TaxRate` = '3.6694' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666789583' WHERE `Matrix_Unique_ID` = '213234662' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-26T06:49:17.267' ,`MLSNumber` = '7998166' ,`ListAgentFullName` = 'Rhonda Surovec' ,`ListOfficeName` = 'RE/MAX East' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.833307' ,`Longitude` = '-95.325557' ,`PhotoCount` = '35' ,`PostalCode` = '77016' ,`RoomCount` = '7' ,`ListPrice` = '195000.00' ,`Status` = 'Active' ,`StreetName` = 'Plaag' ,`StreetNumber` = '4409' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1680' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Home is a shell and will not be completed by seller and is being sold as is.\r\nThis is a great opportunity for a buyer or investor to complete the home \r\nwith their own selections and style. Great floor plan in up and coming community.\r\nCall today and schedule a private showing.' ,`Acres` = '0.1791' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LT 10 BLK 1 BILO PLACE' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '7800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'COOK ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'KASHMERE HIGH SCHOOL' ,`SchoolMiddle` = 'KEY MIDDLE SCHOOL' ,`ShowInstructions` = 'Leave Business Card,No Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Bilo Place' ,`TaxAmount` = '604' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1666789583' WHERE `Matrix_Unique_ID` = '213251388' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-26T07:51:46.640' ,`MLSNumber` = '92708393' ,`ListAgentFullName` = 'Travis Wade' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.026064' ,`Longitude` = '-95.415842' ,`PhotoCount` = '43' ,`PostalCode` = '77073' ,`RoomCount` = '11' ,`ListPrice` = '296500.00' ,`Status` = 'Active' ,`StreetName` = 'Woodchurch' ,`StreetNumber` = '902' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2299' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home is completely remodeled. Located in a Cul-da-sac, this beautiful home on a huge lot is sure to please. This neighborhood has a large neighborhood pool and clubhouse in walking distance. Did I mention the back yard is huge? It has new flooring, new appliances, new granite countertops throughout, new lighting fixtures inside and out, newly painted inside and out, new AC system, newer water heater, new landscaping, new plumbing fixtures and faucets, gorgeous Chimney in the Great Room, custom tile showers and new plugs and switches. There is a new updated electrical panel as well. What more can I say. Come see it for yourself, while you can.' ,`Acres` = '0.287' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Aldine Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 21 BLK 1 INVERNESS FOREST SEC 1' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '12500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '675' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'DUNN ELEMENTARY SCHOOL (ALDINE)' ,`SchoolHigh` = 'NIMITZ HIGH SCHOOL (ALDINE)' ,`SchoolMiddle` = 'LEWIS MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Inverness Forest Sec 01' ,`TaxAmount` = '4694' ,`TaxRate` = '2.5234' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1968' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666789584' WHERE `Matrix_Unique_ID` = '213268797' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-26T07:20:31.477' ,`MLSNumber` = '25445224' ,`ListAgentFullName` = 'Susan Matson' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.052897' ,`Longitude` = '-95.573681' ,`PhotoCount` = '37' ,`PostalCode` = '77379' ,`RoomCount` = '12' ,`ListPrice` = '565000.00' ,`Status` = 'Active' ,`StreetName` = 'Rollinson Park' ,`StreetNumber` = '9842' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3827' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A calming energy is felt when approaching this BRICK AND STONE Trendmaker built home in Gleannloch Farms! Nicely landscaped lot that backing to a greenbelt, meaning no back neighbors! Spacious, flexible living areas with floors of tile and hardwood comprise the first level, with a luxurious primary suite secluded in the rear and offers a sitting area and DOUBLE CLOSETS with built ins. The stunning curved staircase rises from the rear of the foyer as it courses upward past the charming breakfast room. Open concept kitchen w/granite & stainless appls. Three bedrooms, two full bathrooms, MEDIA, AND a GAME room make up the second floor. A GATED three-car garage w/loft & built-in storage, and a PERFEC SIZED BACKYARD WITH GRASS/SHED BEHIND THE GARAGE presenting countless possibilities, whether it be a swimming pool, outdoor kitchen, expanded patio, gardens, or all the above! This beauty is in the Dove Manor section offering a lake w/ walking path. Abundant amenities in Gleannloch Farms.' ,`Acres` = '0.2256' ,`Area` = '14' ,`BuilderName` = 'Trendmaker' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein/Tomball' ,`HeatSystem` = 'Central Electric,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 30 BLK 1 GLEANNLOCH FARMS SEC 40' ,`LotDesciption` = 'Greenbelt,In Golf Course Community,Subdivision Lot' ,`LotSize` = '9827' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'FRANK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN CAIN HIGH SCHOOL' ,`SchoolMiddle` = 'DOERRE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Gleannloch Farms Sec 40' ,`TaxAmount` = '' ,`TaxRate` = '2.7315' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666789584' WHERE `Matrix_Unique_ID` = '213323189' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-26T06:56:36.480' ,`MLSNumber` = '16703748' ,`ListAgentFullName` = 'Garrett Mohnke' ,`ListOfficeName` = 'Complete Property Services' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.049032' ,`Longitude` = '-95.395577' ,`PhotoCount` = '19' ,`PostalCode` = '77373' ,`RoomCount` = '4' ,`ListPrice` = '224000.00' ,`Status` = 'Active' ,`StreetName` = 'Earlmist' ,`StreetNumber` = '23415' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2096' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Recently updated split level 4-2-2 in Timber Lane with large yard and deck.' ,`Acres` = '0.1653' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 24 BLK 50 TIMBER LANE SEC 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '396' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'PEARL M HIRSCH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'TWIN CREEKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Timber Lane' ,`TaxAmount` = '5175' ,`TaxRate` = '3.0268' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666789584' WHERE `Matrix_Unique_ID` = '213412061' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-26T07:48:20.317' ,`MLSNumber` = '70482003' ,`ListAgentFullName` = 'Suzanne Noonan Murphy' ,`ListOfficeName` = 'RE/MAX Associates Northeast' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.091559' ,`Longitude` = '-95.263864' ,`PhotoCount` = '30' ,`PostalCode` = '77365' ,`RoomCount` = '6' ,`ListPrice` = '259900.00' ,`Status` = 'Active' ,`StreetName` = 'Greenleaf Trail' ,`StreetNumber` = '24512' ,`StreetSuffix` = 'Drive' ,`City` = 'Porter' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1836' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Wonderful one-story home on a PREMIUM lot! Perfectly located with views of the Oakhurst Golf Club Course. This home sits in the best location with front and natural reserve behind, no front or back neighbors(very rare find). Amazing curb appeal with a lovely front porch. Beautifully decorated with open concept kitchen includes HUGE island for cooking, tumbled stone backsplash, tile floors, stainless steel appliances & plenty of cabinet storage. Also includes an oversized breakfast area that open to the family room perfect for entertaining guests or family time. Private executive study wood floors & designer paint colors! Massive master bedroom with room for a sitting area or even workout space. Private backyard with covered patio for outdoor living all year round! Great price point for Oakhurst. This is a must see!!' ,`Acres` = '0.1708' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Kingwood NW/Oakhurst' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S835100 - RIVERWOOD AT OAKHURST 01, BLOCK 1, LOT 3' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot,Wooded' ,`LotSize` = '7439' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'BENS BRANCH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PORTER HIGH SCHOOL (NEW CANEY)' ,`SchoolMiddle` = 'WOODRIDGE FOREST MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Riverwood At Oakhurst' ,`TaxAmount` = '6076' ,`TaxRate` = '3.0681' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666789584' WHERE `Matrix_Unique_ID` = '213504712' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-26T07:54:54.990' ,`MLSNumber` = '18327549' ,`ListAgentFullName` = 'Eric Depoy' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = 'Brenda Lee Escalon' ,`SellingOfficeName` = 'Olde Homestead Properties of Texas' ,`Latitude` = '30.073846' ,`Longitude` = '-95.407885' ,`PhotoCount` = '27' ,`PostalCode` = '77373' ,`RoomCount` = '9' ,`ListPrice` = '260000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Whispering Springs' ,`StreetNumber` = '2015' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1927' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming one story home in the beautiful Lexington Woods neighborhood! 4 bedrooms, 2 baths and 2 car detached garage with formal living and dining room! Recently renovated master bathroom, fresh paint and gorgeous new floors are just a few of the updates! Easy access to I-45, well maintained neighborhood and beautiful park and pool! Schedule your appointment to see this home today!!' ,`Acres` = '0.2273' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 9 BLK 6 LEXINGTON WOODS SEC 1' ,`LotDesciption` = 'Greenbelt' ,`LotSize` = '9900' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '395' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'JOHN WINSHIP ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'TWIN CREEKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lexington Woods Sec 01' ,`TaxAmount` = '4154' ,`TaxRate` = '2.2769' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1972' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666789584' WHERE `Matrix_Unique_ID` = '213513559' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-26T06:40:56.137' ,`MLSNumber` = '35157605' ,`ListAgentFullName` = 'Frosy Trapezountios-Graf' ,`ListOfficeName` = 'Energy Realty' ,`SellingAgentFullName` = 'Laura Caffey' ,`SellingOfficeName` = 'Luxury Properties Of Houston' ,`Latitude` = '29.743872' ,`Longitude` = '-95.579889' ,`PhotoCount` = '33' ,`PostalCode` = '77077' ,`RoomCount` = '4' ,`ListPrice` = '417000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Chevy Chase' ,`StreetNumber` = '11515' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2262' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this magnificent home in the established neighborhood of Village West! This property has an enormous backyard, with large trees and a swimming pool ideal to entertain friends and family. The home flows nicely from the foyer to the formal living room which can also be served as a study/office if needed. The dining room has custom wainscoting paneling to accent the walls that will make your guests talk about your great style. A beautifully updated kitchen with granite counters & white cabinets brings out your inner chef. The window above the sink gives you natural light when cooking. The breakfast room windows give you a greenhouse effect. The primary suite is located downstairs with an updated large bathroom, three walk-in closets, and pocket doors. This home is near everything you need to enjoy your day-to-day life; Westside Club, HEB, Whole Foods, Restaurants, and more are just minutes away. This 4-bedroom & 2.5 bathrooms has so much to offer! Schedule a showing to see it!' ,`Acres` = '0.2032' ,`Area` = '31' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Energy Corridor' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 75 BLK 1 VILLAGE WEST SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8850' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ASKEW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'REVERE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Photos/No Videos,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Village West' ,`TaxAmount` = '7208' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666789585' WHERE `Matrix_Unique_ID` = '213517834' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-26T07:43:54.820' ,`MLSNumber` = '47626647' ,`ListAgentFullName` = 'Christopher Bowers' ,`ListOfficeName` = 'RE/MAX Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.703121' ,`Longitude` = '-95.788205' ,`PhotoCount` = '48' ,`PostalCode` = '77494' ,`RoomCount` = '12' ,`ListPrice` = '489000.00' ,`Status` = 'Active' ,`StreetName` = 'Wispy' ,`StreetNumber` = '23831' ,`StreetSuffix` = 'Way' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2469' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this lovely 4 bed/2.5 bath home located in the heart of Seven Meadows. This spectacular property features a spacious floor plan on a beautifully landscaped lot w/ great curb appeal. It features high ceilings, gameroom loft overlooking downstairs, home office/study w/ french doors, covered front porch, wood flooring & custom built-ins. The island kitchen opens to the family room w/ silestone countertops, SS appliances, walk in pantry, & plenty of cabinet space. Primary bdrm/bath offers walk in closet, double sinks w/ vanity, separate walk in shower & jetted tub. Spacious secondary bedrooms w/ plenty of closet space. Private backyard oasis is the perfect place to relax & find your zen featuring sparkling pool, landscaping & greenspace, covered patio and outdoor kitchen. Zoned to highly rated Katy ISD schools. Conveniently located near shopping, dining, 99, Westpark Tollway. Come make this beautiful property your new home!' ,`Acres` = '0.1653' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SEVEN MEADOWS SEC 5, BLOCK 3, LOT 20' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground,Salt Water' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'HOLLAND ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'SEVEN LAKES HIGH SCHOOL' ,`SchoolMiddle` = 'BECKENDORFF JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Seven Meadows Sec 5' ,`TaxAmount` = '7439' ,`TaxRate` = '2.5145' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666789585' WHERE `Matrix_Unique_ID` = '213522343' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-26T07:07:55.570' ,`MLSNumber` = '10265328' ,`ListAgentFullName` = 'Natalie Tye' ,`ListOfficeName` = 'Monarch Real Estate & Ranch' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.798796' ,`Longitude` = '-95.838639' ,`PhotoCount` = '28' ,`PostalCode` = '77493' ,`RoomCount` = '4' ,`ListPrice` = '539990.00' ,`Status` = 'Active' ,`StreetName` = 'Pioneer' ,`StreetNumber` = '6806' ,`StreetSuffix` = 'Trail' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2784' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home! This one story home is located in a gated section of the highly sought after community of Cane Island offering security and privacy with NO BACK NEIGHBORS! It features a 3 car-garage, large windows, high ceilings, and more! Home is finished with tons of upgrades such as wood tile floors throughout main living areas, 14\' ceilings in the kitchen and living room, quartz counters, and built in SS appliances. Cane Island is conveniently located near i10 and Old Katy and has gorgeous amenities including a resort style pool, club house, walking trails, and gym. Come see this home today!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S422363 CANE ISLAND SECTION 3 BLK 1 LOT 15' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '7045' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1550' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'ROBERTSON ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'KATY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cane Island Sec 3' ,`TaxAmount` = '14232' ,`TaxRate` = '3.4077' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666789585' WHERE `Matrix_Unique_ID` = '213532736' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-26T06:34:30.947' ,`MLSNumber` = '54645485' ,`ListAgentFullName` = 'Rocky Mitchell' ,`ListOfficeName` = 'Re/Max Property Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.086106' ,`Longitude` = '-95.661212' ,`PhotoCount` = '45' ,`PostalCode` = '77377' ,`RoomCount` = '9' ,`ListPrice` = '449900.00' ,`Status` = 'Active' ,`StreetName` = 'Pine Country' ,`StreetNumber` = '15819' ,`StreetSuffix` = 'Boulevard' ,`City` = 'Tomball' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3007' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful home was previously a model home and leaves nothing to be desired. This home comes with excellent curb appeal, the entry greets you with high ceilings, wood floors, and an open floor plan that is great for entertaining. The study is to the left as you enter, moving forward you enter into the family room which is connected to the formal dining and the kitchen. The kitchen offers a large island, gas cooktop, granite countertops, and plenty of cabinets for storage, as well as a large pantry. The spacious primary bedroom includes a sitting area with a bay window and custom built-ins in the closet. Additional features include updated 8\' knotty alder doors, surround sound speakers in the upstairs gameroom, large covered patio, slate floors on the patio and a sprinkler system in front and back along with lush landscaping. Roof was replaced in 2021 and the HVAC was replaced 2022. Neighborhood is private and quiet with access to shopping just down the road.' ,`Acres` = '0.2066' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tomball' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 3 BLK 1 PINE COUNTRY OF TOMBALL SEC 2 R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8998' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'ROSEHILL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'TOMBALL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Pine Country' ,`TaxAmount` = '7191' ,`TaxRate` = '2.3767' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666789585' WHERE `Matrix_Unique_ID` = '213602087' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-26T07:22:01.283' ,`MLSNumber` = '44784572' ,`ListAgentFullName` = 'Rebekah Monterrosa-Menjivar' ,`ListOfficeName` = 'Monarch Real Estate & Ranch' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.802322' ,`Longitude` = '-95.841013' ,`PhotoCount` = '26' ,`PostalCode` = '77493' ,`RoomCount` = '5' ,`ListPrice` = '544990.00' ,`Status` = 'Active' ,`StreetName` = 'Brazos Trail' ,`StreetNumber` = '6915' ,`StreetSuffix` = 'Court' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2596' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home! This one story home sits on a spacious corner cul-de-sac lot in the sought after neighborhood of Cane Island! Not only does it include 4 bedrooms, 3 bathrooms, with a home office, but it has beautiful wood-tile throughout the main living area, study, and primary bedroom! The kitchen features modern quartz countertops, gold hardware, upgraded tile backsplash, and built in SS appliances!! It\'s conveniently located to i10, shopping, and dining. Cane Island offers a community restaurant, resort style pool, tree house and walking trails!' ,`Acres` = '0.2035' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S422384 CANE ISLAND SECTION 24 BLK 1 LOT 23 ACRES .2035' ,`LotDesciption` = 'Corner,Cul-De-Sac,Subdivision Lot' ,`LotSize` = '8864' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'ROBERTSON ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'KATY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cane Island' ,`TaxAmount` = '17332' ,`TaxRate` = '3.4077' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666789585' WHERE `Matrix_Unique_ID` = '213622979' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-26T06:00:37.273' ,`MLSNumber` = '72385141' ,`ListAgentFullName` = 'Heather Chavez' ,`ListOfficeName` = 'Realty ONE Group Iconic' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.263279' ,`Longitude` = '-95.546491' ,`PhotoCount` = '48' ,`PostalCode` = '77316' ,`RoomCount` = '7' ,`ListPrice` = '485000.00' ,`Status` = 'Active' ,`StreetName` = 'Capriccio' ,`StreetNumber` = '223' ,`StreetSuffix` = 'Lane' ,`City` = 'Montgomery' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2833' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful, well-maintained home (W/ tons of upgrades) in the highly acclaimed Woodforest Country Club community! 2 story home features an open-concept floor plan w/many windows allowing lots of natural light enhancing interior living space. Home features beautiful wood floors, large living area w/gorgeous fireplace. Large kitchen w/ walk-in pantry, stainless steel appliances, granite counters & large kitchen island for gatherings. 1st floor spacious primary suite features a large walk-in closet, his & her sinks & a soaking tub. First floor also w/secondary bedroom & an additional full bath. Upstairs, you will find a large gameroom/flex-room, 3rd & 4th bedrooms w/ large closets & 3rd full bath. Home backs up to GREENBELT. Enjoy peaceful moments out back on your covered patio. The Woodforest community offers resort style pools, splash pad, walking/biking trails, tennis & basketball courts, retail shopping, restaurants & Harvest Market for your daily grocery needs. This is a must see!' ,`Acres` = '0.1822' ,`Area` = '39' ,`BuilderName` = 'Chesmar' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S965255 - WOODFOREST 55, BLOCK 2, LOT 18' ,`LotDesciption` = 'Greenbelt,Subdivision Lot' ,`LotSize` = '7935' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1265' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'LONE STAR ELEMENTARY SCHOOL (MONTGOMERY)' ,`SchoolHigh` = 'LAKE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'OAK HILL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodforest 55' ,`TaxAmount` = '8435' ,`TaxRate` = '2.665' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666789586' WHERE `Matrix_Unique_ID` = '213623148' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-26T07:46:48.323' ,`MLSNumber` = '58285819' ,`ListAgentFullName` = 'Cody Scurlock' ,`ListOfficeName` = 'Keller Williams Realty - Clear Lake/ NASA' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.893521' ,`Longitude` = '-95.219951' ,`PhotoCount` = '28' ,`PostalCode` = '77044' ,`RoomCount` = '6' ,`ListPrice` = '149999.00' ,`Status` = 'Active' ,`StreetName` = 'Greenspark' ,`StreetNumber` = '11910' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1138' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come out and see this charming 3-bedroom home with an open floor plan. The living area offers high ceilings. a brick fireplace and is open to the lovely kitchen that offers stainless steel appliances, white and golden oak cabinets. Make your way further into the home to view the spacious bedrooms and out back you\'ll find a wonderful roomy backyard!' ,`Acres` = '0.1148' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Northeast Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 14 BLK 1 GREENSBROOK SEC 1 R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '46 - Sheldon' ,`SchoolElementary` = 'GARRETT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CE KING HIGH SCHOOL' ,`SchoolMiddle` = 'MICHAEL R. NULL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Greensbrook Sec 1' ,`TaxAmount` = '3324' ,`TaxRate` = '3.1593' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1984' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666789586' WHERE `Matrix_Unique_ID` = '213680302' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-26T07:04:02.040' ,`MLSNumber` = '94184412' ,`ListAgentFullName` = 'Michelle Garcia' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = 'Michelle Garcia' ,`SellingOfficeName` = 'BHGRE Gary Greene' ,`Latitude` = '29.407488' ,`Longitude` = '-96.055898' ,`PhotoCount` = '50' ,`PostalCode` = '77435' ,`RoomCount` = '6' ,`ListPrice` = '415000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Mesquite Hills' ,`StreetNumber` = '513' ,`StreetSuffix` = 'Road' ,`City` = 'East Bernard' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2025' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to 513 Mesquite Hills Road! This stunning home sits on over 2 acres and offers a spacious 2,025 sq/ft of living space with 3 bedrooms, 2 full bathrooms, sits on a quiet street with beautiful landscaping, brick exterior, and all zoned to Boling ISD! You\'ll love all the incredible features this home has to offer, including high ceilings, custom paint, spacious living room with cozy fireplace, wood cabinets, back patio, and so much more! The land has two ponds, detached garage, large storage shed pre-wired with AC, custom cedar kids fort with AC and television, horse stall, fenced in area for animals, and plenty of space for more! The roof is less than a year old, there is a full RV pad and hookups, large circle driveway paved with rocks, small town school district, new AC in 2015, well pump added in 2014, 14 foot front gate, and the entire property is fenced! Mesquite Hills is minutes from HWY 59 and HWY 60 - in an excellent location! Schedule your private showing today!' ,`Acres` = '2.764' ,`Area` = '55' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas,Propane' ,`HOAMandatory` = '0' ,`Legal` = 'MESQUITE HILLS LOT 8' ,`LotDesciption` = 'Cleared,Subdivision Lot,Water View' ,`LotSize` = '120400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '140 - Boling' ,`SchoolElementary` = 'NEWGULF ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BOLING HIGH SCHOOL' ,`SchoolMiddle` = 'IAGO JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Mesquite Hills' ,`TaxAmount` = '4444' ,`TaxRate` = '1.6468' ,`WaterSewer` = 'Aerobic,Well' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666789586' WHERE `Matrix_Unique_ID` = '213692332' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-26T07:26:20.617' ,`MLSNumber` = '48755142' ,`ListAgentFullName` = 'LaShelle Larson' ,`ListOfficeName` = 'CB&A, Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.084079' ,`Longitude` = '-95.775764' ,`PhotoCount` = '25' ,`PostalCode` = '77447' ,`RoomCount` = '9' ,`ListPrice` = '285000.00' ,`Status` = 'Active' ,`StreetName` = 'Cloverland Field' ,`StreetNumber` = '22522' ,`StreetSuffix` = 'Drive' ,`City` = 'Hockley' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1937' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This Pecos Plan by LGI Homes boasts 4 bedrooms, 2 bathrooms, large walk in closets, and chef ready kitchen complete with granite counters. From the incredible entrance to the awesome park, Bauer Landing is a wonderful place to call home. This community also includes walking trails and with its close proximity to the new Grand Parkway traveling anywhere in the city is a breeze! Low taxes and HOA! Schedule your showing today, this one won\'t last long.' ,`Acres` = '0.1222' ,`Area` = '35' ,`BuilderName` = 'LGI Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hockley' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 18 BLK 5 BAUER LANDING SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5325' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '475' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'EVELYN TURLINGTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'SCHULTZ JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Bauer Landing' ,`TaxAmount` = '6407' ,`TaxRate` = '2.8556' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666789586' WHERE `Matrix_Unique_ID` = '213728444' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-26T06:44:06.673' ,`MLSNumber` = '78460500' ,`ListAgentFullName` = 'Laya Zachariah' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.421006' ,`Longitude` = '-95.285322' ,`PhotoCount` = '26' ,`PostalCode` = '77511' ,`RoomCount` = '6' ,`ListPrice` = '219900.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 180' ,`StreetNumber` = '1848' ,`StreetSuffix` = '' ,`City` = 'Alvin' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1836' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come see this completely remodeled 3 bedroom/2 full bath/1836 sq. ft. manufactured home. Built in 2006, this double wide sits on 2-acre fenced and gated lot with no restrictions. New paint interior and exterior. New soft carpet in all bedrooms. Modern premium vinyl plank flooring in living room, kitchen, dining room and den. Island kitchen with new cabinets and granite countertops with backsplash. Large living room is perfect for family gatherings with a fireplace to keep warm during winter season. Bring your horse or farm animals onto this ready to move-in home. Don\'t miss the opportunity for country living at its finest. Survey available upon request.' ,`Acres` = '2' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'BLUM (A0474 H T & B R R ) LOT 24B ACRES 2.0 S# 125011008A00H' ,`LotDesciption` = 'Wooded' ,`LotSize` = '87120' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'NELSON ELEMENTARY SCHOOL (ALVIN)' ,`SchoolHigh` = 'ALVIN HIGH SCHOOL' ,`SchoolMiddle` = 'FAIRVIEW JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Blum' ,`TaxAmount` = '2018' ,`TaxRate` = '2.2174' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666789586' WHERE `Matrix_Unique_ID` = '213732261' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-26T06:42:19.377' ,`MLSNumber` = '3037890' ,`ListAgentFullName` = 'Michelle Marek' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.120149' ,`Longitude` = '-95.531259' ,`PhotoCount` = '50' ,`PostalCode` = '77389' ,`RoomCount` = '11' ,`ListPrice` = '939000.00' ,`Status` = 'Active' ,`StreetName` = 'Karacabey' ,`StreetNumber` = '25022' ,`StreetSuffix` = 'Court' ,`City` = 'Spring' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4656' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous home in the gated community of Lakes at Shadow Creek in Augusta Pines sits on a quiete cul-de-sac street backing to a lake. When you enter the home you\'re greeted by the interior courtyard with fireplace and sliders that open off the formal dining room great for entertaining. Gourmet kitchen with upgraded appliances, double ovens, undercabinet lighting, Texas size pantry, and Granite counters. Luxurious Primary with jetted tub, car-wash shower and spacious closet. Secondary bedroom with en-suite bath and study down. Upstairs features 2 bedrooms, media room and game room. Escape to the resort style backyard with heated pool/pergola/outdoor kitchen all overlooking the peaceful lake. Upgrades include Plantation Shutters, Shiplap fireplace wall, wine closet with fridge, surround sound, and epoxy garage flooring. Fantastic neighborhood amenities and acclaimed KISD (International Baccalaureate Program). Minutes from dining, shopping, ExxonMobil, and 99. Come live the lifestyle!' ,`Acres` = '0.2675' ,`Area` = '14' ,`BuilderName` = 'J.Patrick Homes' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Spring/Klein' ,`HeatSystem` = 'Central Electric,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 29 BLK 2 SHADOW CREEK SOUTH SEC 3' ,`LotDesciption` = 'Cul-De-Sac,In Golf Course Community,Subdivision Lot,Waterfront' ,`LotSize` = '11653' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'FRENCH ELEMENTARY SCHOOL (KLEIN)' ,`SchoolHigh` = 'KLEIN OAK HIGH SCHOOL' ,`SchoolMiddle` = 'HOFIUS INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Augusta Pines/Shadow Creek' ,`TaxAmount` = '19600' ,`TaxRate` = '2.864' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1666789587' WHERE `Matrix_Unique_ID` = '213785967' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-26T06:09:15.920' ,`MLSNumber` = '95027572' ,`ListAgentFullName` = 'Brandy Mayr' ,`ListOfficeName` = 'RE/MAX Northwest, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.243018' ,`Longitude` = '-95.896447' ,`PhotoCount` = '6' ,`PostalCode` = '77484' ,`RoomCount` = '3' ,`ListPrice` = '749840.00' ,`Status` = 'Active' ,`StreetName` = 'Round Up' ,`StreetNumber` = '17752' ,`StreetSuffix` = '' ,`City` = 'Waller' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2835' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This stunning custom built home is tucked away on 1 acre and features beautiful trees providing you with the privacy you are looking for. The home has custom cabinets and built ins throughout. The kitchen is a dream with granite countertops, stainless steel appliances, farmhouse sinks, huge island with a double oven. The living room features custom built-in cabinets. Barn doors lead into the study with barn doors. Master bath boasts a huge walk in shower with separate tub, custom cabinets w/granite countertops and built ins in master closet. This beautiful country property is one of a kind!' ,`Acres` = '' ,`Area` = '60' ,`BuilderName` = 'Rvision Homes Ltd' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Plantersville Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S7644 - SADDLE CREEK FOREST SEC. 4, BLOCK 6, LOT 6, ACRES 1.' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '775' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '129 - Navasota' ,`SchoolElementary` = 'HIGH POINT ELEMENTARY SCHOOL (Navasota)' ,`SchoolHigh` = 'NAVASOTA HIGH SCHOOL' ,`SchoolMiddle` = 'NAVASOTA JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'SADDLE CREEK FOREST' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Aerobic' ,`YearBuilt` = '' ,`YearBuiltSrc` = '' ,`rets_update_timestamp`='1666789587' WHERE `Matrix_Unique_ID` = '213793518' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-26T07:37:00.710' ,`MLSNumber` = '15180059' ,`ListAgentFullName` = 'Natalie Tye' ,`ListOfficeName` = 'Monarch Real Estate & Ranch' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.804142' ,`Longitude` = '-95.843606' ,`PhotoCount` = '39' ,`PostalCode` = '77493' ,`RoomCount` = '5' ,`ListPrice` = '824990.00' ,`Status` = 'Active' ,`StreetName` = 'Savannah' ,`StreetNumber` = '7018' ,`StreetSuffix` = 'Run' ,`City` = 'Katy' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4709' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '7018 N Savannah Run sits on a spacious lot in Cane Island! You\'re immediately greeted with stunning curb appeal between the all white stucco exterior and dark trim accents; it\'s a modern design dream. Imagine guests walking to your front door and being greeted to their left by a warm and cozy front courtyard home to a built-in fireplace. This stunning 2 story home includes countless upgrades; from the luxury wood-like flooring throughout, high ceilings, and sliding glass doors, to the huge kitchen island this home has it all! The layout of this home is perfect for entertaining as upstairs has a one of a kind dream media room. It is truly like stepping into a movie theatre- equipped with a full sized wet bar, top and bottom cabinets for snack and game storage, and space for a beverage fridge! Cane Island is convenient to i10, shopping, dining, and is all zoned to Katy ISD!' ,`Acres` = '0.1955' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S422381 CANE ISLAND 21 BLK 1 LOT 41 ACRES .1955' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8516' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'ROBERTSON ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'KATY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Cane Island Sec 21' ,`TaxAmount` = '26237' ,`TaxRate` = '3.4077' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666789587' WHERE `Matrix_Unique_ID` = '213816394' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-26T07:35:45.640' ,`MLSNumber` = '71633059' ,`ListAgentFullName` = 'Flo Edelman' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.462482' ,`Longitude` = '-95.495528' ,`PhotoCount` = '49' ,`PostalCode` = '77459' ,`RoomCount` = '13' ,`ListPrice` = '1495000.00' ,`Status` = 'Active' ,`StreetName` = 'Halls Retreat' ,`StreetNumber` = '8607' ,`StreetSuffix` = 'Court' ,`City` = 'Missouri City' ,`BathsFull` = '3' ,`BathsHalf` = '2' ,`BedsTotal` = '5' ,`SqFtTotal` = '5687' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous custom home on 2.5 acres with 5 bedrooms, 3 full & 2 half baths, 3-car attached garage & a\r\nbackyard built for entertaining! Two-story foyer features floating staircase; formal dining on\r\nleft & study on right behind French doors. Luxury island kitchen with full size Subzero\r\nrefrigerator & freezer is open to family room. Wall of French doors opens from family room to\r\noutdoor living space. Downstairs game room with built-in bar is accessible from back yard &\r\ncreates a great flow for parties! In addition to the 4 bedrooms & 2 baths upstairs there is\r\nanother game room & huge flex space that could be a craft room, upstairs study or 6th bedroom. The\r\noutdoor living space has all the bells & whistles including covered outdoor kitchen, built in\r\nseating around a TV on a lift, outdoor fireplace & two pools (one is a cocktail pool with built-in\r\nseating & table). There is even a fenced off kennel for the pups! Back acreage remains\r\nwooded for privacy. Elan Home Automation system.' ,`Acres` = '2.53' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Levee District,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'SIENNA POINT SEC 2, BLOCK 1, LOT 49, ACRES 2.530' ,`LotDesciption` = 'Wooded' ,`LotSize` = '110207' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'HERITAGE ROSE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sienna Point' ,`TaxAmount` = '16551' ,`TaxRate` = '2.2129' ,`WaterSewer` = 'Aerobic,Well' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666789587' WHERE `Matrix_Unique_ID` = '213831414' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-26T07:25:11.227' ,`MLSNumber` = '18301662' ,`ListAgentFullName` = 'Brian Simpson' ,`ListOfficeName` = 'RE/MAX Elite Properties' ,`SellingAgentFullName` = 'Pedro Martinez' ,`SellingOfficeName` = 'City Group' ,`Latitude` = '29.952778' ,`Longitude` = '-95.625895' ,`PhotoCount` = '31' ,`PostalCode` = '77429' ,`RoomCount` = '4' ,`ListPrice` = '260000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Nevermore' ,`StreetNumber` = '13418' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1752' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming one story home that has been nicely remodeled located on an interior lot. Features include granite counters, breakfast bar in kitchen, stainless steel appliances, gas fireplace, two sinks in primary bath, jetted tub, frameless shower and the list goes on.' ,`Acres` = '0.2009' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 31 BLK 4 RAVENSWAY SOUTH' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8750' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '684' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'MILLSAP ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CY-FAIR HIGH SCHOOL' ,`SchoolMiddle` = 'ARNOLD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Ravensway South' ,`TaxAmount` = '5261' ,`TaxRate` = '2.5737' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666789588' WHERE `Matrix_Unique_ID` = '213847874' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-26T07:49:59.997' ,`MLSNumber` = '14360976' ,`ListAgentFullName` = 'Juan Barron' ,`ListOfficeName` = 'RE/ImageProperties and Investm' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.939021' ,`Longitude` = '-94.777454' ,`PhotoCount` = '13' ,`PostalCode` = '75960' ,`RoomCount` = '3' ,`ListPrice` = '169000.00' ,`Status` = 'Active' ,`StreetName` = 'Dorris' ,`StreetNumber` = '323' ,`StreetSuffix` = 'Road' ,`City` = 'Moscow' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '858' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home. Cozy three bedroom in the country. Property is surrounded by nature. Lots of trees. Come make this home your get away from it all.' ,`Acres` = '0.8' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Polk County North' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 839 A BROOKS SURVEY TRACT 2-A' ,`LotDesciption` = 'Cleared,Wooded' ,`LotSize` = '40000' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '238 - Corrigan-Camden' ,`SchoolElementary` = 'CORRIGAN-CAMDEN PRIMARY/ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CORRIGAN-CAMDEN HIGH SCHOOL' ,`SchoolMiddle` = 'CORRIGAN-CAMDEN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'NA' ,`TaxAmount` = '343' ,`TaxRate` = '1.7144' ,`WaterSewer` = 'Aerobic,Well' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1666789588' WHERE `Matrix_Unique_ID` = '213883515' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-26T07:10:32.130' ,`MLSNumber` = '75610839' ,`ListAgentFullName` = 'Kathleen Lauhoff' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.766764' ,`Longitude` = '-95.632416' ,`PhotoCount` = '36' ,`PostalCode` = '77077' ,`RoomCount` = '8' ,`ListPrice` = '365000.00' ,`Status` = 'Active' ,`StreetName` = 'Swiss Hill' ,`StreetNumber` = '13907' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2368' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'LOCATION, LOCATION, LOCATION! This home is zoned to acclaimed BARBARA BUSH Elem School & located in the highly desirable ENERGY CORRIDOR, near Terry Hershey Park Hike/Bike Trails, with easy access to I-10, City Centre, & local restaurants. There is a new community center & all the amenities are located nearby on Briarhills Parkway. This is a BEAUTIFUL 1-story home. with NO CARPET. It has a custom gate and double door entry that welcomes you when you arrive, 3 large bedrooms, 2 bathrooms, plus a study with block paneling and bookshelves that could be used as a 4th bdrm, with tile floors throughout. Many other features include: canvas awnings on the south & east side of home, French doors in study and kitchen/breakfast room, automatic sprinkler system, landscaped back yard with Koi fish pond + patio w/brick pavers. A/C coil & condenser (2011), oven, microwave, dishwasher (2013-2015). Access to area tennis courts, pool, basketball courts and club house. NEVER FLOODED! A MUST SEE!!' ,`Acres` = '0.1362' ,`Area` = '31' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Energy Corridor' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 9 BLK 9 BRIARHILLS SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5933' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '916' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BUSH ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WESTSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'WEST BRIAR MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Briarhills' ,`TaxAmount` = '5943' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1977' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666789588' WHERE `Matrix_Unique_ID` = '213898799' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-26T07:34:47.173' ,`MLSNumber` = '31907108' ,`ListAgentFullName` = 'Roger Sturgell' ,`ListOfficeName` = 'Connect Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.284805' ,`Longitude` = '-94.831106' ,`PhotoCount` = '50' ,`PostalCode` = '77551' ,`RoomCount` = '5' ,`ListPrice` = '1575000.00' ,`Status` = 'Active' ,`StreetName` = 'Bayou Shore' ,`StreetNumber` = '1509' ,`StreetSuffix` = 'Drive' ,`City` = 'Galveston' ,`BathsFull` = '4' ,`BathsHalf` = '2' ,`BedsTotal` = '5' ,`SqFtTotal` = '2950' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Custom Home built by local Galveston Builders on the water. This home is a one of a kind with 20 ft vaulted and beamed ceilings in the living/kitchen/dining area with custom designer finishes throughout. At the garage level there is a large room that can be used as a game room, media room or gym room. Large boat/fishing dock and in the backyard there is an entertainment deck which provides great sunset views. This home is a must see!' ,`Acres` = '0.6039' ,`Area` = '33' ,`BuilderName` = 'Emily Root' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Midtown - Galveston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'EMILY ROOT ADDN (2017) ABST 121, LOT B, ACRES 0.604' ,`LotDesciption` = 'Waterfront' ,`LotSize` = '26305' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop,Grill' ,`Refrigerator` = '' ,`Roof` = 'Aluminum,Other' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Emily Root Add' ,`TaxAmount` = '23138' ,`TaxRate` = '2.0662' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666789588' WHERE `Matrix_Unique_ID` = '213934490' --> 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','213975487','1666789588','213975487','2022-10-26T07:47:49.880','42290160','Amy Larner','RE/MAX Leading Edge','','','29.139204','-95.049940','49','77554','4','887000.00','Active','Pecos','22110','Drive','Galveston','2','0','3','1550','Single-Family','Waterfront living with a POOL! This meticulously maintained custom home was built in 2019 and features soaring ceilings, open-concept living, and a stunning chef\'s kitchen. As you walk through the front door, your eye is drawn to all the designer touches from shiplap walls to the gorgeous beams that run throughout the main area. There are three bedrooms, and two bathrooms on the main level. The beautifully designed kitchen features a large island overlooking the living and dining areas. The oversized upper deck allows for lazy days in the shade or the perfect place to soak in the sun\'s rays. Looking for more? Head to the lower level, and enjoy one of the multiple entertainment areas complete with your very own POOL! This tropical oasis is fully fenced with a cargo lift, and concrete bulkhead, complete with a boat lift, allowing easy access to Galveston Bay. Home conveys furnished with a few exclusions. This property is 100% TURNKEY, and ready for YOU!','0.1033','33','','','Electric Dryer Connections,Washer Connections','','No Disclosures','1','','','West End','Central Electric','1','ABST 121 HALL & JONES SUR LOT 94 SEA ISLE 15TH EXTENSION','Subdivision Lot,Water View,Waterfront','4500','Appraisal District','','225','0','','1','Freestanding Oven','1','Gunite','','Freestanding Range','','Composition','22 - Galveston','GISD OPEN ENROLL','BALL HIGH SCHOOL','GISD OPEN ENROLL','Accompany,Appointment Required,Supra Keybox','Appraisal District','1','Traditional','Sea Isle Ext 15','15635','2.0324','Public Sewer,Public Water','2019','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-26T06:33:04.320' ,`MLSNumber` = '86667710' ,`ListAgentFullName` = 'Shary Luthe' ,`ListOfficeName` = 'Home Sweet Home Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.731964' ,`Longitude` = '-95.211560' ,`PhotoCount` = '42' ,`PostalCode` = '77364' ,`RoomCount` = '4' ,`ListPrice` = '275000.00' ,`Status` = 'Active' ,`StreetName` = 'Governor Hogg' ,`StreetNumber` = '342' ,`StreetSuffix` = 'Drive' ,`City` = 'Point Blank' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2416' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome To Governor\'s Point- A Well Maintained Quiet Lake Community That Is Highly Desired Among The Locals! Governor\'s Point Provides Expansive Amenities With Extremely Low HOA Dues Including A Community Boat Launch, Fishing Piers, A Playground, Picnic Area And A Community Pool- WOW! This Beautiful Lake Home Features 4 Bedrooms, Including TWO Primary Bedroom Suites (One Upstairs And One Downstairs) And 3 Full Bathrooms With Covered Porches That Expand The Length Of The Home- Amazing! The Kitchen Is Massive And Overlooks The Living And Dining Area With Walls Of Windows. You Even Have A Wet Bar Area In The Upstairs Living Area! There Is Plenty Of Space For Storage With An Attached Garage And A Detached Workshop For Golf Cart Storage With An Oversized Carport For A Boat Or RV. All Interior Flooring, Roof, Exterior Staircase And Upper Landing Were Installed New In 2017! Come Make This Your Weekend Getaway Or Permanant Lake Residence! Furnishings Are Negotiable!' ,`Acres` = '0.194' ,`Area` = '64' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'GOVERNORS POINT #2, BLOCK 11, LOT 17, ACRES .194' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8451' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '150' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '101 - Coldspring-Oakhurst Consolidated' ,`SchoolElementary` = 'JAMES STREET ELEMENTARY SCHOOL' ,`SchoolHigh` = 'COLDSPRING-OAKHURST HIGH SCHOOL' ,`SchoolMiddle` = 'LINCOLN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Colonial' ,`Subdivision` = 'Governors Point #2' ,`TaxAmount` = '3937' ,`TaxRate` = '1.6254' ,`WaterSewer` = 'Aerobic,Public Water' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666789588' WHERE `Matrix_Unique_ID` = '213977960' --> 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','214019530','1666789589','214019530','2022-10-26T07:48:54.353','38019766','Nohora Garza','eXp Realty, LLC','','','29.727150','-95.589245','32','77082','4','1100000.00','Active','Rosemary Park','3110','Lane','Houston','4','1','4','4056','Single-Family','PRICED TO SELL! Newly renovated modern Mediterranean style house, situated at the prestigious Royal Oaks Country Club. The open concept first floor is built for entertaining with soaring ceilings, hardwoods, built in speakers and double-sided FP. The updated kitchen boasts SS appliances, island and ample cupboards. This extremely well-maintained home features 3 bedrooms on the 2nd floor all with in suite bathrooms. The spacious primary bedroom with sitting area and double-sided FP. The huge primary bathroom is newly renovated and has a spacious closet. The additional 3rd floor bonus room ideal for theatre, game room, fifth bedroom or private study. This house offers a rare casita guest house to accommodate friends, family, gym, or private home office. The spacious yard offers your very own outdoor oasis featuring a private pool, spa, and courtyard. New roof was installed in 2020 and new exterior paint in 2021. This home has never flooded. Security patrols & 24-hour manned gates.','0.215','31','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gaslog Fireplace','2','Westchase Area','Central Gas','1','LT 13 BLK 2 ROYAL OAKS COUNTRY CLUB 1 R/P','In Golf Course Community','9365','Appraisal District','','3250','0','','2','Electric Oven','1','In Ground','','Gas Cooktop','','Composition','2 - Alief','OUTLEY ELEMENTARY SCHOOL','AISD DRAW','O\'DONNELL MIDDLE SCHOOL','Appointment Required,Leave Business Card,Supra Keybox','Appraisal District','3','Contemporary/Modern,Mediterranean','Royal Oaks Country Club 01 R/P','17206','2.6086','Water District','1999','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','214020413','1666789589','214020413','2022-10-26T07:46:07.530','71480019','Monica Foster','eXp Realty, LLC','','','29.476260','-95.156741','41','77573','10','444900.00','Active','Laddingford','511','Lane','League City','2','1','4','2995','Single-Family','Pride of ownership! Gorgeous curb appeal and stone/brick front elevation will welcome you each day! Once inside, notice the extensive tile flooring and wide Entry hall that Perry Homes is known for! Stacked Formals are the focal point of many a holiday gathering of family & friends! The spacious Kitchen is sure to please the chef in the home! It features an abundance of cabinetry & gorgeous granite counters, an island for extra prep space, breakfast bar seating for meals-on-the-go & black appliances including a new dishwasher! The Family Room has a beautiful gas log fireplace that is perfect for warming you on a chili night, or setting the mood for a date night-in! After a long day, relax in the Primary Bedroom, which boasts an ensuite featuring raised counters, double sinks, vanity area, walk-in closet, separate shower & garden tub! All Secondary Bedrooms provide ample space, and Bedrooms 3 & 4 have walk-in closets! Out back finds a great covered patio & spacious yard! Never flooded!','0.1858','33','Perry Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gaslog Fireplace','1','League City','Central Gas','1','WESTOVER PARK SEC 8B (2006) ABST 606, BLOCK 2, LOT 10, ACRES','Subdivision Lot','8093','Appraisal District','','605','0','','2','Electric Oven','0','','','Electric Range','','Composition','9 - Clear Creek','HALL ELEMENTARY SCHOOL','CLEAR SPRINGS HIGH SCHOOL','CREEKSIDE INTERMEDIATE SCHOOL','Lockbox Front','Appraisal District','1','Traditional','Westover Park','10120','2.5697','Public Sewer,Public Water,Water District','2008','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-26T07:49:20.437' ,`MLSNumber` = '89301236' ,`ListAgentFullName` = 'Tasha Bason' ,`ListOfficeName` = 'Steel Door Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '33.581260' ,`Longitude` = '-101.812609' ,`PhotoCount` = '10' ,`PostalCode` = '79403' ,`RoomCount` = '20' ,`ListPrice` = '375000.00' ,`Status` = 'Active' ,`StreetName` = 'Vanda' ,`StreetNumber` = '1601' ,`StreetSuffix` = 'Avenue' ,`City` = 'Lubbock' ,`BathsFull` = '10' ,`BathsHalf` = '10' ,`BedsTotal` = '20' ,`SqFtTotal` = '8638' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Rehab, Assisted Living Facility, Foster Care, Medical Office Building, Hospice Care and More options in this large almost 9,000 sf Facility. Located close to major Freeways and the Lubbock airport. Staff facility, 20+ bedrooms with double occupancy and each room has a full or half bath attached. large commercial kitchen and plenty of common areas. The facility is divided into 3 wings to make it perfect for separation. Previously operated as a rehab facility but has been vacant and will need repairs and updates to be operational again. Sold As-Is.' ,`Acres` = '0.396' ,`Area` = '87' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'PUCKETT SUB HOMES L 31-A & 32 & 17\' X 174\' ALLEY' ,`LotDesciption` = 'Corner' ,`LotSize` = '17248' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '697 - Lubbock' ,`SchoolElementary` = 'BOZEMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ESTACADO HIGH SCHOOL' ,`SchoolMiddle` = 'DUNBAR COLLEGE PREPATORY ACADEMY' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Puckett Suburban Homes' ,`TaxAmount` = '6487' ,`TaxRate` = '2.127' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1964' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666789589' WHERE `Matrix_Unique_ID` = '214042700' --> 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','214047593','1666789589','214047593','2022-10-26T07:27:03.220','74929282','Ellen Holt','RE/MAX Associates Northeast','','','30.161517','-95.196130','50','77357','13','689900.00','Active','Yellow Chestnut','19276','Lane','New Caney','4','0','5','3916','Single-Family','Spectacular Galena home built by Lennar - located in the beautiful gated Tavola community! This home offers a total of 5 bedrooms and 4 full bathrooms. Every detail in this home was carefully selected and quality crafted. Located on an oversized lot at the end of a Cul-de-sac street - This big open floorplan has updated wood flooring - Large living area complimented by a wall of windows and corner fireplace, sitting area, study, and fabulous kitchen that features a large Magnolia Home style island with quartz counter, along with SS double ovens, Hallman gas range, walk-in pantry, undercabinet lighting and an oversized laundry room! The first floor Owners Suite offers a bath with dual vanities, a corner soak tub, Texas size custom walk in shower, with a walk-in closet. Upstairs is the 4th and 5th bedrooms with Jack and Jill bath and huge game room. Entertain outdoors by your private pool & 3-covered patios! The 2-car attached garage has new epoxy flooring and huge closet for storage!','0.2444','40','','','Electric Dryer Connections,Gas Dryer Connections','','Sellers Disclosure','1','Gas Connections','1','Porter/New Caney East','Central Gas','1','S921132 - TAVOLA 32, BLOCK 4, LOT 19','Cul-De-Sac,Greenbelt','10646','Appraisal District','','800','0','','2','','1','Gunite','','Gas Range','','Composition','39 - New Caney','TAVOLA ELEMENTARY SCHOOL (NEW CANEY)','NEW CANEY HIGH SCHOOL','KEEFER CROSSING MIDDLE SCHOOL','Accompany,Lockbox Front,Request Online Appointment,Supra Keybox','Builder','2','Traditional','Tavola 32','16230','3.4331','Public Sewer,Public Water','2019','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-26T07:31:06.327' ,`MLSNumber` = '18661260' ,`ListAgentFullName` = 'Sandra Pinon' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.061298' ,`Longitude` = '-94.744879' ,`PhotoCount` = '36' ,`PostalCode` = '77575' ,`RoomCount` = '3' ,`ListPrice` = '320000.00' ,`Status` = 'Active' ,`StreetName` = 'Bob White' ,`StreetNumber` = '114' ,`StreetSuffix` = 'Lane' ,`City` = 'Liberty' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2468' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Honey stop the car! You don\'t want to miss this one. Beautiful 3 bedrooms, 2 baths, recently updated paint throughout, ceiling fans in every room, and recently updated flooring throughout in the highly sought after neighborhood in the country club. This beautiful home sits on 1/2 an acre with a back covered patio/deck for family gatherings now that the holidays are just around the corner and an oversized game room. Property also includes an exclusive spot to park your rv/camper. All you have to do is show up to the open house before it\'s gone. Did I mention home sits on 1/2 an acre and is move in ready...' ,`Acres` = '0.5785' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Liberty' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'COUNTRY CLUB, BLOCK 1, SEC D, LOT 14 15, ACRES 0.5785' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '25199' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '73 - Liberty' ,`SchoolElementary` = 'LIBERTY ELEMENTARY SCHOOL (LIBERTY)' ,`SchoolHigh` = 'LIBERTY HIGH SCHOOL (LIBERTY)' ,`SchoolMiddle` = 'LIBERTY MIDDLE SCHOOL (LIBERTY)' ,`ShowInstructions` = 'Accompany,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Country Club' ,`TaxAmount` = '4461' ,`TaxRate` = '2.0336' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1975' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666789589' WHERE `Matrix_Unique_ID` = '214049781' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-26T06:22:47.050' ,`MLSNumber` = '18303977' ,`ListAgentFullName` = 'Wendy Dozier' ,`ListOfficeName` = 'RE/MAX On The Water - Bolivar' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.368144' ,`Longitude` = '-94.754276' ,`PhotoCount` = '50' ,`PostalCode` = '77650' ,`RoomCount` = '6' ,`ListPrice` = '799999.00' ,`Status` = 'Active' ,`StreetName` = 'Galveston' ,`StreetNumber` = '1222' ,`StreetSuffix` = 'Avenue' ,`City` = 'Port Bolivar' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1221' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This Front Row, Fully Furnished Beach House is a MUST SEE! Enjoy Gorgeous views of the Gulf, Galveston & Fort Travis from the deck and even below the house with your own private beach! The home has a fully fenced in yard with a driveway gate. The floorplan has great use of every square foot with good sized bedrooms and a nice, open living room, kitchen & breakfast area. The kitchen features granite countertops and the home has vinyl wood floors and neutral paint throughout. This home has been featured on Discovery Channel\'s \'\'Buying Beaches\'\' and HGTV\'s \'\'Beach Front Bargain Hunter. It is already an established investment property with substantial rental income or you can make it your own for your friends and family.' ,`Acres` = '0.2571' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Port Bolivar' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 162 S PARR LOTS 13 THRU 15 BLK 299 PORT BOLIVAR' ,`LotDesciption` = 'Water View,Waterfront' ,`LotSize` = '11200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Port Bolivar Townsite' ,`TaxAmount` = '5860' ,`TaxRate` = '1.6103' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '2011' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666789589' WHERE `Matrix_Unique_ID` = '214053472' --> 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','214064678','1666789589','214064678','2022-10-26T07:43:12.093','89183856','Jaime Black','Martin & Black Real Estate LLC','','','29.399959','-95.254005','35','77511','7','284999.00','Active','Colt Creek','1187','Court','Alvin','2','1','3','1839','Single-Family','Meticulous Mustang Crossing home nestled on a quiet cul-de-sac street with no back neighbors! New landscaping greets you to the covered front porch with a stylish lead-glass front door and into the open living space with soaring ceilings, highlighted by new carpet and interior paint throughout the home. Continuing to the breakfast bar and island kitchen with stainless steel refrigerator, extensive cabinetry and walk-in pantry along with a large dining space provides room for all. First floor master retreat with ensuite bath featuring a soaking tub, separate shower and walk-in closet. Upstairs offers a roomy game room with a large storage closet, 2 bedrooms highlighted by crown molding and spacious closets and a full bath. A new windstorm certified backdoor leads to the 10x30 back patio, perfect for gatherings! No MUD tax and No Flooding! Convenient park just down the street! Come take a look!','0.128','5','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','0','Alvin South','Central Gas','1','MUSTANG CROSSING SEC 1 (A0488 H & W) (ALVIN) BLK 1 LOT 7','Cul-De-Sac,Subdivision Lot','5576','Appraisal District','','340','0','','2','Electric Oven','0','','','Electric Range','','Composition','3 - Alvin','ALVIN ELEMENTARY SCHOOL','ALVIN HIGH SCHOOL','ALVIN JUNIOR HIGH SCHOOL','Lockbox Back,Supra Keybox','Appraisal District','2','Traditional','Mustang Crossing','6180','2.8854','Public Sewer,Public Water','2007','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214068630','1666789589','214068630','2022-10-26T07:03:01.467','79301132','Kelechi Okeadu','A List Real Estate Group, LLC','','','29.631950','-95.417310','7','77045','3','135000.00','Active','Knotty Oaks Trail','2811','','Houston','1','0','3','1021','Single-Family','Looking for a starter home to add all your personal touches, well look no more. This very spacious 3 Bedroom 1 Bath is located within an established neighborhood. This house will be perfect for investors or anyone looking to add their own personal touches and tuck away in a nice cozy home!!','','18','','','','','No Disclosures','','','','Five Corners','Central Electric','0','Almeda Plaza','Subdivision Lot','7860','Appraisal District','','','0','','2','','0','','','','','Composition','27 - Houston','PETERSEN ELEMENTARY SCHOOL','MADISON HIGH SCHOOL (HOUSTON)','LAWSON MIDDLE SCHOOL','Accompany,Controlled Access','Appraisal District','1','Traditional','Almeda Plaza','','','Public Sewer,Public Water','1959','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','214073470','1666789589','214073470','2022-10-26T07:21:50.893','73164194','Sherrie Jackson','Umbrella Realty','','','29.860613','-95.298054','11','77016','3','209900.00','Active','Lakewood','7228','Drive','Houston','1','0','3','1260','Single-Family','LIKE NEW! Charming 3 bedroom home totally remolded with contemporary finishes, beautiful laminate wood flooring throughout, new cabinetry, nice and bright paint throughout, new roof, updated piping, new AC system, and the list goes on! This home also offers a large front and back yard, perfect for entertaining the family. Conveniently located minutes from downtown Houston, easy access to highway 59, I-10, and beltway 8. \r\nHome is in process to be completed with the remodel. \r\nRoom dimensions and third party information about this property is not guaranteed, we encourage all interested parties to verify all information.','0.1674','2','','','','','Sellers Disclosure','','','','Northeast Houston','Central Electric','0','LT 23 BLK 45 SCENIC WOODS','Subdivision Lot','7290','Appraisal District','','','0','','1','','0','','','','','Composition','27 - Houston','SHADYDALE ELEMENTARY','NORTH FOREST HIGH SCHOOL','FOREST BROOK MIDDLE SCHOOL','Appointment Required','Appraisal District','1','Traditional','Scenic Woods','2140','2.3307','Public Sewer,Public Water','1953','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','214073745','1666789590','214073745','2022-10-26T07:40:51.040','5308849','Joe Rothchild','Keller Williams Signature','','','30.223170','-95.700944','10','77354','11','339990.00','Active','Guillemont','40664','Lane','Magnolia','2','1','4','2387','Single-Family','2 Story, 4 Bedroom, 2 ½ Bath, Open Concept Kitchen/Dining Combo, Game Room Up, Separate Jetted Tub and Shower in Primary Bath, Dual Vanities in Primary Bath, Wrought Iron Stair Parts, Luxury Vinyl Plank Floors in Entry, Dining/Kitchen Area, Family Room, Hallway and all Wet Areas, Granite Kitchen Countertops with Island, 3”x12” Herringbone Tile Backsplash, Single Bowl Undermount Stainless Steel Sink with Pull Out Faucet, Upgraded Stainless Steel Appliances with Microwave, 42” Upper Kitchen Cabinets with Under Cabinet Lighting, Upgraded Trim Package, Covered Patio, Stone Accents, Landscaping with Full Sod and Irrigation, Tech Shield Radiant Barrier, Environments for Living Home, plus more…AVAILABLE NOW.','','15','Devon Street Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Other Disclosures','1','','','Magnolia/1488 West','Central Gas','1','LOT 25 BLK 1 SEC 2B','Subdivision Lot','4571','Appraisal District','','1850','1','Never Lived In','2','Gas Oven','0','','','Gas Range','','Composition','36 - Magnolia','MAGNOLIA PARKWAY ELEMENTARY SCHOOL','MAGNOLIA HIGH SCHOOL','BEAR BRANCH JUNIOR HIGH SCHOOL','Appointment Required','Builder','2','Traditional','Audubon','','','Public Sewer,Public Water,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','214073878','1666789590','214073878','2022-10-26T07:59:12.653','42996427','Brandy Mayr','RE/MAX Northwest, REALTORS','','','30.199086','-96.021480','25','77445','3','304480.00','Active','Pin Oak','26595','Drive','Hempstead','2','0','3','1772','Single-Family','NEW, one story, 3 bedroom, 2 bath, 1772 square foot home on A QUARTER ACRE LOT! This home features an open floor plan in the kitchen/living room/dining. High ceilings, granite countertops, stainless steel appliances, spacious primary bed/bath, garden tub, glass encased shower, his/her vanities. Large windows for abundant natural light throughout. 3 car garage! Deerwood amenities include Lakes, HUGE Park, Pool & clubhouse. Hempstead has fine schools, parks, and a low cost of living/family friendly area with country style living.','0.24','26','Freedom Star','','','','No Disclosures','','','','Waller','Central Electric','1','S455200 DEERWOOD LAKES 2 LOT 225','Subdivision Lot','10454','Appraisal District','','110','1','To Be Built/Under Construction','3','','0','','','','','Composition','55 - Waller','FIELDS STORE ELEMENTARY SCHOOL','WALLER HIGH SCHOOL','SCHULTZ JUNIOR HIGH SCHOOL','Appointment Required','Appraisal District','1','Ranch,Traditional','Deerwood Lakes 2','307','2.0243','Public Water,Septic Tank','',''); --> 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','214074036','1666789590','214074036','2022-10-26T07:59:15.413','71736895','Yohan Adhitama','REALM Real Estate Professional','','','29.887713','-95.436171','24','77088','7','241000.00','Active','Drayton','2123','Lane','Houston','2','0','4','1962','Single-Family','Lovely one story house with 4 beds and 2 baths. Tons of upgrade. Fresh interior paint, new roof, new HVAC, new Quartz countertops and backsplash, new gas oven, new cooktop, new light fixture, new kitchen sink & faucet, new mirror, & new dishwasher. Easy access to I-45 & Hwy. 249, & also 610. Schedule your showing today.','0.1515','11','','','Washer Connections','','Owner/Agent,Sellers Disclosure','1','','','Northwest Houston','Central Gas','0','LT 836 BLK 26 HEATHER GLEN SEC 3','Subdivision Lot','6600','Appraisal District','','','0','','0','Gas Oven','0','','','Gas Cooktop','','Composition','1 - Aldine','HILL ELEMENTARY SCHOOL (ALDINE)','EISENHOWER HIGH SCHOOL','GARCIA MIDDLE SCHOOL','Lockbox Front','Appraisal District','1','Traditional','Heather Glen Sec 03','3075','2.1553','Public Sewer,Public Water','1977','Appraisal District'); --> New record created successfully