Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-10T06:40:29.330' ,`MLSNumber` = '4568024' ,`ListAgentFullName` = 'Leora Boullion' ,`ListOfficeName` = 'Poole Realty Group' ,`SellingAgentFullName` = 'Shelia Mathisen' ,`SellingOfficeName` = 'UTR TEXAS, REALTORS' ,`Latitude` = '30.128752' ,`Longitude` = '-94.890701' ,`PhotoCount` = '31' ,`PostalCode` = '77535' ,`RoomCount` = '10' ,`ListPrice` = '365000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'County Road 6502' ,`StreetNumber` = '157' ,`StreetSuffix` = '' ,`City` = 'Dayton' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1634' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Home that you must see. Country living at its best. Sit on 2.5 acres with lots of large trees to enjoy outdoors.\r\n Air Condition replaced earlier this year. Kitchen cabinets painted and new Granite counter top.\r\n Wood burning fireplace in livingroom. Large Primary bedroom with bath with double sinks, shower, tub and two\r\n other bedrooms and bath. \r\n This home has never flooded. \r\n 10X20 storage building, 35X30 Metal building with 15 ft. awning, and 20X30 camper cover on right and Sit on \r\n 45X50 Slab. Separate light pole for building. Beautiful brick home sitting on 2.5 accres with storage shed and Metal building' ,`Acres` = '2.5' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Dayton' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'SPUR FOREST, LOT 16, TRACT 1 2, SEC 1, ACRES 2.5' ,`LotDesciption` = 'Cleared' ,`LotSize` = '108900' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '74 - Dayton' ,`SchoolElementary` = 'STEPHEN F. AUSTIN ELEMENTARY SCHOOL (DAYTON)' ,`SchoolHigh` = 'DAYTON HIGH SCHOOL' ,`SchoolMiddle` = 'WOODROW WILSON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Spur Forest' ,`TaxAmount` = '3107' ,`TaxRate` = '1.7512' ,`WaterSewer` = 'Aerobic' ,`YearBuilt` = '2009' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668118990' WHERE `Matrix_Unique_ID` = '208014680' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-10T06:48:58.577' ,`MLSNumber` = '61994977' ,`ListAgentFullName` = 'Susan Kinder' ,`ListOfficeName` = 'MV Realty Of Texas LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.164341' ,`Longitude` = '-95.077173' ,`PhotoCount` = '29' ,`PostalCode` = '77327' ,`RoomCount` = '4' ,`ListPrice` = '400000.00' ,`Status` = 'Active' ,`StreetName` = 'Road 5108' ,`StreetNumber` = '77' ,`StreetSuffix` = '' ,`City` = 'Cleveland' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2095' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Pride of ownership shows. Beautiful home with several upgrades; You\'ll relax knowing you found the right one when you view the stunning half-acre, built-in swimming pool, and huge outside back patio. Once inside you will see a 2-story luxurious living room with a perfect view of the granite countertop gourmet kitchen. The kitchen features 12 feet ceilings, newish appliances; a microwave, stove, and dishwasher, long granite countertop island, and a wooded tile floor plan for the entire downstairs. The primary bedroom is downstairs with a large walk-in closet, his and her sinks, and a separate tub shower. The other bedrooms are upstairs with spacious walk-in closets. Have the whole family over, the driveway is long enough to fit 8 cars.' ,`Acres` = '0.51' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'SANTA FE, SEC 1, BLOCK 3, LOT 438, ACRES .51' ,`LotDesciption` = 'Corner' ,`LotSize` = '22216' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Above Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '100 - Cleveland' ,`SchoolElementary` = 'COTTONWOOD SCHOOL (CLEVELAND)' ,`SchoolHigh` = 'CLEVELAND HIGH SCHOOL' ,`SchoolMiddle` = 'CLEVELAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'English' ,`Subdivision` = 'Santa Fe, Sec 1' ,`TaxAmount` = '5287' ,`TaxRate` = '2.1513' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1668118990' WHERE `Matrix_Unique_ID` = '210743194' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-10T05:23:13.190' ,`MLSNumber` = '38067658' ,`ListAgentFullName` = 'Steven Andrews' ,`ListOfficeName` = 'Texas Premier Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '32.802187' ,`Longitude` = '-94.722470' ,`PhotoCount` = '29' ,`PostalCode` = '75683' ,`RoomCount` = '3' ,`ListPrice` = '209000.00' ,`Status` = 'Active' ,`StreetName` = 'Redbud' ,`StreetNumber` = '206' ,`StreetSuffix` = 'Street' ,`City` = 'Ore City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1680' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Your new home has a fresh new look and is absolutely a show stopper. This beauty is perfect with a nice sized back yard for the kids and Fido to play. This home features new granite countertops, new appliances, floors and much more. It also has a nice covered patio in the back yard great for entertaining. Call today to schedule your private home tour.' ,`Acres` = '0.4821' ,`Area` = '84' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LOT 4-6, BLK 60 ORE CITY S269 (A297) .4821 ACRES & HOUSE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '21000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '793 - Ore City' ,`SchoolElementary` = 'ORE CITY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ORE CITY HIGH SCHOOL' ,`SchoolMiddle` = 'ORE CITY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Right Side' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Ore City' ,`TaxAmount` = '2237' ,`TaxRate` = '2.5779' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1977' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668118990' WHERE `Matrix_Unique_ID` = '210870221' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-10T06:36:54.337' ,`MLSNumber` = '61762131' ,`ListAgentFullName` = 'Nicole Boyde' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = 'Kevin Meine' ,`SellingOfficeName` = 'eXp Realty, LLC' ,`Latitude` = '30.382985' ,`Longitude` = '-95.644883' ,`PhotoCount` = '14' ,`PostalCode` = '77356' ,`RoomCount` = '7' ,`ListPrice` = '243000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Fantasy' ,`StreetNumber` = '247' ,`StreetSuffix` = 'Lane' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1462' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Do you LOVE where you live? You could! Adorable one story in the great community of Cape Conroe in Montgomery. \r\nCape Conroe is a community fronting the shores of Lake Conroe, just minutes from shopping and great restaurants. Not only does this neighborhood boast a private boat ramp and dock, the other amenities included are a pool, clubhouse and a picnic/playground. Light and bright floorplan which consists of a spacious family room with dining and a kitchen with breakfast bar that is open to the family room as well as 3 bedrooms and 2 baths. Recent seller updates in last couple of years include: wood look flooring, carpet and paint through-out. Great backyard with a deck perfect for relaxing or entertaining. Call this one HOME soon!' ,`Acres` = '0.1722' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure,Tenant Occupied' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'CAPE CONROE 02, BLOCK 6, LOT 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7499' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '240' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'STEWART CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MONTGOMERY HIGH SCHOOL' ,`SchoolMiddle` = 'MONTGOMERY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Cape Conroe 02' ,`TaxAmount` = '3922' ,`TaxRate` = '2.3542' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '1997' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668118990' WHERE `Matrix_Unique_ID` = '211424147' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-10T06:58:43.637' ,`MLSNumber` = '16434062' ,`ListAgentFullName` = 'Tom Virippan' ,`ListOfficeName` = 'TV International Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.591568' ,`Longitude` = '-95.540434' ,`PhotoCount` = '7' ,`PostalCode` = '77489' ,`RoomCount` = '8' ,`ListPrice` = '350000.00' ,`Status` = 'Active' ,`StreetName` = 'Heritage' ,`StreetNumber` = '2438' ,`StreetSuffix` = 'Court' ,`City` = 'Missouri City' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2494' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Spectacular2020 built, comparatively new home, featured 5 Bedrooms 3 Full Bath with 2 Bed Rooms on first Floor. Fabulous Primary bedroom and Game room. Covered Patio with Gas connection is another attraction. Stainless steel appliances and granite counter top. Situated with in easy reach of shopping and leisure centers. HWY 6, HWY59, are just minutes away. Walking distance to Elementary school and Community Park. Come Grab this Gem of a Home.' ,`Acres` = '0.1231' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LIBERTY RIDGE SEC 1, BLOCK 1, LOT 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5361' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '495' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'EDGAR GLOVER JR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MARSHALL HIGH SCHOOL (FORT BEND)' ,`SchoolMiddle` = 'MISSOURI CITY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Liberty Ridge Sec 1' ,`TaxAmount` = '7080' ,`TaxRate` = '2.5525' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668118990' WHERE `Matrix_Unique_ID` = '211958592' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-10T06:37:00.733' ,`MLSNumber` = '72557119' ,`ListAgentFullName` = 'Nimesh Patel' ,`ListOfficeName` = 'RE/MAX Fine Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.576267' ,`Longitude` = '-95.540919' ,`PhotoCount` = '41' ,`PostalCode` = '77459' ,`RoomCount` = '4' ,`ListPrice` = '338000.00' ,`Status` = 'Active' ,`StreetName` = 'Quail Valley East' ,`StreetNumber` = '2507' ,`StreetSuffix` = 'Drive' ,`City` = 'Missouri City' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2198' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'As close to new construction as you can get...do not miss this gorgeously renovated one-story in the heart of Quail Valley at an excellent price! Almost every inch of this house has been remodeled: gourmet kitchen with new appliances, vinyl plank wood flooring, windows, ceiling (no more popcorn!), doors, hardware, lighting, paint, updated bathrooms & so much more. No carpeting! Modern with farmhouse flair & even barn doors. Open floor plan with high ceilings & focal point fireplace. Stunning wine storage nook. Split floor plan with four bedrooms & two bathrooms plus powder bath. Oversized, detached garage with plenty of additional storage space and even a covered walkway leaded from the house. The private, massive backyard is an incredible space to put a swimming pool, play equipment or pets. Location is key! Set in the heart of Missouri City close to shopping and restaurants. Low taxes and HOA. This is a quality remodel that will not disappoint. Welcome home to 2507 Quail Valley East!' ,`Acres` = '0.2261' ,`Area` = '38' ,`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` = 'Missouri City Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'QUAIL VALLEY EAST SEC 2, BLOCK 15, LOT 5' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot' ,`LotSize` = '9848' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '96' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'LANTERN LANE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ELKINS HIGH SCHOOL' ,`SchoolMiddle` = 'QUAIL VALLEY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Quail Valley East Sec 2' ,`TaxAmount` = '4007' ,`TaxRate` = '2.34' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1973' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668118991' WHERE `Matrix_Unique_ID` = '212117188' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-10T06:41:27.873' ,`MLSNumber` = '10839054' ,`ListAgentFullName` = 'Chelsy Ogundolie' ,`ListOfficeName` = 'Texas United Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.668229' ,`Longitude` = '-95.357425' ,`PhotoCount` = '23' ,`PostalCode` = '77051' ,`RoomCount` = '2' ,`ListPrice` = '90000.00' ,`Status` = 'Active' ,`StreetName` = 'Lee Otis' ,`StreetNumber` = '8601' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '676' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'CHARMING HOME IN MEDICAL CENTER SOUTH AREA. BUILD YOUR NEWLY CONSTRUCTED HOME OR RECONSTRUCT THE CURRENT STRUCTURE. LOCATED NEAR THE MEDICAL CENTER. MAJOR FREEWAYS NEAR BY. BUY AS IS. INVESTORS ARE WELCOMED. CALL TO STOP BY TO CHECK OUT THIS HOME.' ,`Acres` = '0.101' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Medical Center South' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 35 BLK 3 F AND E NO 2 U/R ABST 1281 J M SWISHER' ,`LotDesciption` = 'Other' ,`LotSize` = '4400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BASTIAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WORTHING HIGH SCHOOL' ,`SchoolMiddle` = 'ATTUCKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'F & E Sub 2' ,`TaxAmount` = '1702' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1951' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668118991' WHERE `Matrix_Unique_ID` = '212233327' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-10T05:05:44.010' ,`MLSNumber` = '40315214' ,`ListAgentFullName` = 'Karly Anderson' ,`ListOfficeName` = 'Century 21 Realty Partners' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.812252' ,`Longitude` = '-95.106101' ,`PhotoCount` = '8' ,`PostalCode` = '77360' ,`RoomCount` = '4' ,`ListPrice` = '80000.00' ,`Status` = 'Active' ,`StreetName` = 'Buffalo' ,`StreetNumber` = '159' ,`StreetSuffix` = 'Street' ,`City` = 'Onalaska' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1368' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Single family home on a very good sized corner lot. Being offered AS-IS only. Super fixer upper and is priced well under market value. Lowered list price to a fantastic valued flipper opportunity!!' ,`Acres` = '0.2066' ,`Area` = '44' ,`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` = 'IMPALA WOODS SECTION 1 BLK 12 LOT 1, 20, 21 & 22' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '9000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '291' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '104 - Onalaska' ,`SchoolElementary` = 'ONALASKA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ONALASKA JR/SR HIGH SCHOOL' ,`SchoolMiddle` = 'ONALASKA JR/SR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Impala Woods Sec 1' ,`TaxAmount` = '824' ,`TaxRate` = '2.054' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '1987' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668118991' WHERE `Matrix_Unique_ID` = '212413830' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-10T06:39:00.210' ,`MLSNumber` = '67792829' ,`ListAgentFullName` = 'Shardae Johnson' ,`ListOfficeName` = 'Braden Real Estate Group, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.017571' ,`Longitude` = '-95.289241' ,`PhotoCount` = '24' ,`PostalCode` = '77338' ,`RoomCount` = '6' ,`ListPrice` = '319000.00' ,`Status` = 'Active' ,`StreetName` = 'Flatiron' ,`StreetNumber` = '20406' ,`StreetSuffix` = 'Drive' ,`City` = 'Humble' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3196' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BACK ON THE MARKET! This beauty offers 4 bedrooms and 3.5 bathrooms. Upon arrival, you are greeted by a grand foyer that prepares you for entry. Hard wood floors lead you past the in-law suite, the formal dining and into the heart of the home. The open concept kitchen and living room are great for entertaining. Upstairs, you will find 2 junior bedrooms with Jack and Jill bathrooms perfect for siblings as well as a movie room and a separate game room or bonus space. For additional flare, this home has an added artists loft! Definitely a must see.' ,`Acres` = '0.1371' ,`Area` = '12' ,`BuilderName` = 'Lennar Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'HOA First Right of Refusal,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Humble Area West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 14 BLK 4 DEERBROOK ESTATES SEC 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5972' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'JONES ELEMENTARY SCHOOL (ALDINE)' ,`SchoolHigh` = 'NIMITZ HIGH SCHOOL (ALDINE)' ,`SchoolMiddle` = 'JONES MIDDLE SCHOOL (ALDINE)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Deerbrook Estates' ,`TaxAmount` = '7764' ,`TaxRate` = '2.7433' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668118991' WHERE `Matrix_Unique_ID` = '212473511' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-10T06:51:05.370' ,`MLSNumber` = '65696795' ,`ListAgentFullName` = 'Nancy Ramos' ,`ListOfficeName` = 'Nan & Company PropertiesChristie\'s International R' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.848600' ,`Longitude` = '-95.434465' ,`PhotoCount` = '22' ,`PostalCode` = '77091' ,`RoomCount` = '6' ,`ListPrice` = '339900.00' ,`Status` = 'Active' ,`StreetName` = 'White Magnolia' ,`StreetNumber` = '5728' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1757' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Please use the following address on GPS; 1528 Paul Quinn st. Houston, TX 77091 Cottages at Highland Pointe offers a gated community, two thoughtfully designed open concept floor plans, high-end interior finishes, stainless-steel appliances, dog park, fenced backyard and much more. Conveniently situated just North of Oak Forest with easy access to 610, I-45, and I-10. Located just minutes away from everything that The Heights and Downtown has to offer. Move-in ready by Fall 2022\r\nVirtual tour available on link above.' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = 'Orchid Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 24 Block 1 Cottages at Highland Pointe' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '1681' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '99' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HIGHLAND HEIGHTS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'WILLIAMS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cottages at Highland Pointe' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668118992' WHERE `Matrix_Unique_ID` = '212552966' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-10T05:32:50.250' ,`MLSNumber` = '83454621' ,`ListAgentFullName` = 'Lauren Moyers' ,`ListOfficeName` = 'Keller Williams Elite' ,`SellingAgentFullName` = 'Yvette Williams' ,`SellingOfficeName` = 'JLA Realty' ,`Latitude` = '29.805555' ,`Longitude` = '-94.926148' ,`PhotoCount` = '34' ,`PostalCode` = '77521' ,`RoomCount` = '6' ,`ListPrice` = '295000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Hidden Dunes' ,`StreetNumber` = '6503' ,`StreetSuffix` = 'Drive' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1969' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous single story home located along the walking trail in the desirable new section of Hunters Creek subdivision. This 4 bedroom 2 bath home features tile throughout the living areas and carpet in the bedrooms. When entering the home you are greeted with a long entry way with tray ceilings and a split floor plan. The chef\'s dream kitchen is opened to the living room and is equipped with stainless steel appliances, granite countertops, HUGE island, and more cabinets than you can imagine with under cabinet lights!! The large primary bedroom features a bay window perfect for overlooking your backyard. The relaxing master suite has double sinks, separate tub and shower, and a spacious walk in closet. Step out onto your covered patio for all of your family gatherings or visit the neighborhood park, splash pad, or dog park. The neighborhood has beautiful walking trails throughout. It is also near i10 and HWY 146 for easy commutes!' ,`Acres` = '0.132' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 8 BLK 1 HUNTERS CREEK SEC 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5750' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '480' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'STEPHEN F. AUSTIN ELEMENTARY SCHOOL (GOOSE CREEK)' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (GOOSE CREEK)' ,`SchoolMiddle` = 'GENTRY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Hunters Crk Sec 7' ,`TaxAmount` = '8289' ,`TaxRate` = '3.63' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668118992' WHERE `Matrix_Unique_ID` = '212700706' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-10T05:05:26.167' ,`MLSNumber` = '17778755' ,`ListAgentFullName` = 'Shean Manickchan' ,`ListOfficeName` = 'United Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.940722' ,`Longitude` = '-95.503508' ,`PhotoCount` = '23' ,`PostalCode` = '77066' ,`RoomCount` = '4' ,`ListPrice` = '304000.00' ,`Status` = 'Active' ,`StreetName` = 'Imperial Grove' ,`StreetNumber` = '5606' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2348' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home to this newly renovated home nestled in the beautiful Ashcreek subdivision! This home features 4 spacious rooms, 2.5 baths, a family room, living room, dining room and gorgeous kitchen. The home has fresh paint in and out, new flooring in bedrooms, and a renovated kitchen. Don\'t miss this opportunity to own this gem. This home is conveniently located near major highways including beltway 8. Measurements are approximate. Home never flooded. Call today to schedule your private tour!' ,`Acres` = '0.1543' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '1960/Cypress Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 23 BLK 5 ASHCREEK' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6720' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '425' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'MCDOUGLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN FOREST HIGH SCHOOL' ,`SchoolMiddle` = 'WUNDERLICH INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Back,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Ashcreek' ,`TaxAmount` = '4850' ,`TaxRate` = '2.6316' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668118992' WHERE `Matrix_Unique_ID` = '212950761' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-10T06:40:42.060' ,`MLSNumber` = '86342939' ,`ListAgentFullName` = 'Malisa Walker' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.296393' ,`Longitude` = '-94.799194' ,`PhotoCount` = '30' ,`PostalCode` = '77550' ,`RoomCount` = '4' ,`ListPrice` = '298500.00' ,`Status` = 'Active' ,`StreetName` = 'Avenue L' ,`StreetNumber` = '2924' ,`StreetSuffix` = '' ,`City` = 'Galveston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1858' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great home in the heart of Galveston. There is so much to love in this 4 bedroom 2 bath split level home. Enjoy the beauty of Galveston from your porch. Your yard is ready to be turned into an oasis of serenity.' ,`Acres` = '0.1244' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'East End' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 628 M B MENARD SUR PT OF LOTS 4 & 5 (4-3) BLK 89 GALVES' ,`LotDesciption` = 'Cleared' ,`LotSize` = '5421' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Split Level,Traditional' ,`Subdivision` = 'Galveston Townsite' ,`TaxAmount` = '3332' ,`TaxRate` = '2.0662' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668118992' WHERE `Matrix_Unique_ID` = '213188481' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-10T05:25:05.490' ,`MLSNumber` = '50891040' ,`ListAgentFullName` = 'Val Arbona' ,`ListOfficeName` = 'RE/MAX Universal' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.036452' ,`Longitude` = '-95.645775' ,`PhotoCount` = '48' ,`PostalCode` = '77429' ,`RoomCount` = '8' ,`ListPrice` = '399900.00' ,`Status` = 'Active' ,`StreetName` = 'Greenford Glen' ,`StreetNumber` = '15206' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2227' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A must-see Beauty - decked out in soft shades of white and loads of natural light. Start with the front door and walk into the Kitchen, Dining and Living area. Walk around the well-equipped Kitchen w/stainless appliances. Check out the generous counter space and large, granite island. Space for counter height stools. Follow the wood-look tile floor toward the area with a warm fireplace, stunning light fixtures and accents -sure to be the heart of the home. The primary bedroom features a large Bath area and walk-in closet and is separate from the other Bedrooms for privacy. A Drop zone with built-in bench and cubby storage is by the Garage. The spacious Laundry room is wide enough for appliances and Desk area. Relax outdoors on the Covered Patio. Enjoy the easy-to-maintain small size lawn. Hayden Lakes subdivision features lakes surrounded by sidewalks, Pool and Play area and dog park - designed for enjoying the outdoors. Sh249 and 99 are really close for easy commuting.' ,`Acres` = '0.136' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tomball South/Lakewood' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 6 BLK 1 HAYDEN LAKES SEC 9' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '5926' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '935' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'GRAND OAKS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL MEMORIAL H S' ,`SchoolMiddle` = 'GRAND LAKES JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Hayden Lakes Sec 9' ,`TaxAmount` = '8729' ,`TaxRate` = '2.8172' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668118992' WHERE `Matrix_Unique_ID` = '213254863' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-10T06:24:53.730' ,`MLSNumber` = '73371772' ,`ListAgentFullName` = 'Stacey Adkins' ,`ListOfficeName` = 'One Solution Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.745236' ,`Longitude` = '-95.581332' ,`PhotoCount` = '34' ,`PostalCode` = '77077' ,`RoomCount` = '8' ,`ListPrice` = '359500.00' ,`Status` = 'Active' ,`StreetName` = 'Woodland Springs' ,`StreetNumber` = '2011' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2455' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to 2011 Woodland Springs St. This 4 bedroom, 2 bathrooms 1 1/2-story home in the Energy Corridor, is freshly painted inside and out. The kitchen has a new backsplash and new quartz countertops, along with newer appliances, With Saltillo tiles in the living and kitchen area and luxury vinyl plank flooring used in bedrooms and halls. New gutters, new HVAC, new fence, new roof, and new driveway. A game room is located upstairs with a pool table. To top it all off enjoy your backyard with a swimming pool that comes with a brand-new Polaris cleaning system.  For your private tour, call today.' ,`Acres` = '0.1433' ,`Area` = '31' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Energy Corridor' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 33 BLK 2 APRIL VILLAGE SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6240' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '510' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ASKEW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'REVERE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'April Village Sec 01' ,`TaxAmount` = '6409' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668118993' WHERE `Matrix_Unique_ID` = '213398128' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-10T06:38:08.123' ,`MLSNumber` = '41944075' ,`ListAgentFullName` = 'Beverly Bradley' ,`ListOfficeName` = 'Weekley Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.924297' ,`Longitude` = '-95.756989' ,`PhotoCount` = '40' ,`PostalCode` = '77433' ,`RoomCount` = '6' ,`ListPrice` = '426000.00' ,`Status` = 'Active' ,`StreetName` = 'Cortines' ,`StreetNumber` = '15218' ,`StreetSuffix` = 'Court' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2366' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Design excellence and attention to detail make every day in The Braden family home plan amazing. Your bright and airy study is the perfect place for a productive home office or a unique lounge. Share your culinary masterpieces on the presentation island in the modern kitchen. Decorate and furnish your sunlit open floor plan to perfectly fit your interior design style. Enjoy leisurely evenings and breezy weekends relaxing on the deluxe covered patio. Your Owner’s Retreat provides a glamorous retreat from the world and includes a luxury bathroom and walk-in closet. Each spare bedroom features enhanced privacy with ample living and closet space. The incredible upstairs retreat presents a unique place to create an ultimate family fun zone and lifelong memories.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'David Weekley Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan,Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 73 Block 01' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1284' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'WELLS ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'BRIDGELAND HIGH SCHOOL' ,`SchoolMiddle` = 'SMITH MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Bridgeland' ,`TaxAmount` = '' ,`TaxRate` = '3.62' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668118993' WHERE `Matrix_Unique_ID` = '213442204' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-10T06:51:53.883' ,`MLSNumber` = '58300372' ,`ListAgentFullName` = 'Nancy Ramos' ,`ListOfficeName` = 'Nan & Company PropertiesChristie\'s International R' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.893291' ,`Longitude` = '-95.305131' ,`PhotoCount` = '47' ,`PostalCode` = '77091' ,`RoomCount` = '5' ,`ListPrice` = '339900.00' ,`Status` = 'Active' ,`StreetName` = 'White Magnolia' ,`StreetNumber` = '5727' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1757' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Please use the following address on GPS; 1528 Paul Quinn st. Houston, TX 77091 Cottages at\r\nHighland Pointe offers a gated community, two thoughtfully designed open concept floor plans,\r\nhigh-end interior finishes, stainless-steel appliances, dog park, fenced backyard and much\r\nmore. Conveniently situated just North of Oak Forest with easy access to 610, I-45, and I-10.\r\nLocated just minutes away from everything that The Heights and Downtown has to offer. Move-in\r\nready by Fall 2022 Virtual tour available on link above.' ,`Acres` = '' ,`Area` = '1' ,`BuilderName` = 'Orchid Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 13 Block 1' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '1681' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '99' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'MARSHALL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTH FOREST HIGH SCHOOL' ,`SchoolMiddle` = 'FOREST BROOK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Highland Pointe' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668118993' WHERE `Matrix_Unique_ID` = '213492346' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-10T06:54:17.133' ,`MLSNumber` = '35002199' ,`ListAgentFullName` = 'Nancy Ramos' ,`ListOfficeName` = 'Nan & Company PropertiesChristie\'s International R' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.848600' ,`Longitude` = '-95.434465' ,`PhotoCount` = '19' ,`PostalCode` = '77091' ,`RoomCount` = '5' ,`ListPrice` = '339900.00' ,`Status` = 'Active' ,`StreetName` = 'White Magnolia' ,`StreetNumber` = '5731' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1757' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Please use the following address on GPS; 1528 Paul Quinn st. Houston, TX 77091 Cottages at\r\nHighland Pointe offers a gated community, two thoughtfully designed open concept floor plans,\r\nhigh-end interior finishes, stainless-steel appliances, dog park, fenced backyard and much\r\nmore. Conveniently situated just North of Oak Forest with easy access to 610, I-45, and I-10.\r\nLocated just minutes away from everything that The Heights and Downtown has to offer. Move-in\r\nready by Fall 2022 Virtual tour available on link above.' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = 'Orchid Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 15 Block 1' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '1681' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '99' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HIGHLAND HEIGHTS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'WILLIAMS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Highland Pointe' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668118993' WHERE `Matrix_Unique_ID` = '213492600' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-10T06:52:32.027' ,`MLSNumber` = '62124947' ,`ListAgentFullName` = 'Nancy Ramos' ,`ListOfficeName` = 'Nan & Company PropertiesChristie\'s International R' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.848600' ,`Longitude` = '-95.434465' ,`PhotoCount` = '19' ,`PostalCode` = '77091' ,`RoomCount` = '5' ,`ListPrice` = '339900.00' ,`Status` = 'Active' ,`StreetName` = 'White Magnolia' ,`StreetNumber` = '5732' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1757' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Please use the following address on GPS; 1528 Paul Quinn st. Houston, TX 77091 Cottages at\r\nHighland Pointe offers a gated community, two thoughtfully designed open concept floor plans,\r\nhigh-end interior finishes, stainless-steel appliances, dog park, fenced backyard and much\r\nmore. Conveniently situated just North of Oak Forest with easy access to 610, I-45, and I-10.\r\nLocated just minutes away from everything that The Heights and Downtown has to offer. Move-in\r\nready by Fall 2022 Virtual tour available on link above.' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = 'Orchid Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 22 Block 1' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '1681' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '99' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HIGHLAND HEIGHTS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'WILLIAMS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Highland Pointe' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668118994' WHERE `Matrix_Unique_ID` = '213492829' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-10T06:54:53.497' ,`MLSNumber` = '64407255' ,`ListAgentFullName` = 'Nancy Ramos' ,`ListOfficeName` = 'Nan & Company PropertiesChristie\'s International R' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.893017' ,`Longitude` = '-95.305107' ,`PhotoCount` = '24' ,`PostalCode` = '77091' ,`RoomCount` = '6' ,`ListPrice` = '344900.00' ,`Status` = 'Active' ,`StreetName` = 'White Magnolia' ,`StreetNumber` = '5730' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1761' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '' ,`Area` = '1' ,`BuilderName` = 'Orchid Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 23 Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '1681' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '99' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'MARSHALL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTH FOREST HIGH SCHOOL' ,`SchoolMiddle` = 'FOREST BROOK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Highland Pointe' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668118994' WHERE `Matrix_Unique_ID` = '213493227' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-10T06:53:04.473' ,`MLSNumber` = '41933821' ,`ListAgentFullName` = 'Nancy Ramos' ,`ListOfficeName` = 'Nan & Company PropertiesChristie\'s International R' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.893291' ,`Longitude` = '-95.305089' ,`PhotoCount` = '47' ,`PostalCode` = '77091' ,`RoomCount` = '5' ,`ListPrice` = '339900.00' ,`Status` = 'Active' ,`StreetName` = 'White Magnolia' ,`StreetNumber` = '5735' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1757' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Please use the following address on GPS; 1528 Paul Quinn st. Houston, TX 77091 Cottages at\r\nHighland Pointe offers a gated community, two thoughtfully designed open concept floor plans,\r\nhigh-end interior finishes, stainless-steel appliances, dog park, fenced backyard and much\r\nmore. Conveniently situated just North of Oak Forest with easy access to 610, I-45, and I-10.\r\nLocated just minutes away from everything that The Heights and Downtown has to offer. Move-in\r\nready by Fall 2022 Virtual tour available on link above.' ,`Acres` = '' ,`Area` = '1' ,`BuilderName` = 'Orchid Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 17 Block 1 Cottages at Highland Pointe' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '1681' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '99' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'MARSHALL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTH FOREST HIGH SCHOOL' ,`SchoolMiddle` = 'FOREST BROOK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Highland Pointe' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668118994' WHERE `Matrix_Unique_ID` = '213494317' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-10T06:53:42.630' ,`MLSNumber` = '11044125' ,`ListAgentFullName` = 'Nancy Ramos' ,`ListOfficeName` = 'Nan & Company PropertiesChristie\'s International R' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.848600' ,`Longitude` = '-95.434465' ,`PhotoCount` = '19' ,`PostalCode` = '77091' ,`RoomCount` = '5' ,`ListPrice` = '339900.00' ,`Status` = 'Active' ,`StreetName` = 'White Magnolia' ,`StreetNumber` = '5736' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1757' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Please use the following address on GPS; 1528 Paul Quinn st. Houston, TX 77091 Cottages at\r\nHighland Pointe offers a gated community, two thoughtfully designed open concept floor plans,\r\nhigh-end interior finishes, stainless-steel appliances, dog park, fenced backyard and much\r\nmore. Conveniently situated just North of Oak Forest with easy access to 610, I-45, and I-10.\r\nLocated just minutes away from everything that The Heights and Downtown has to offer. Move-in\r\nready by Fall 2022 Virtual tour available on link above.' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = 'Orchid Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 20 Block 1' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '1681' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '99' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HIGHLAND HEIGHTS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'WILLIAMS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Highland Pointe' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668118994' WHERE `Matrix_Unique_ID` = '213494688' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-10T06:55:47.470' ,`MLSNumber` = '40944018' ,`ListAgentFullName` = 'Nancy Ramos' ,`ListOfficeName` = 'Nan & Company PropertiesChristie\'s International R' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.848414' ,`Longitude` = '-95.434465' ,`PhotoCount` = '24' ,`PostalCode` = '77091' ,`RoomCount` = '6' ,`ListPrice` = '344900.00' ,`Status` = 'Active' ,`StreetName` = 'White Magnolia' ,`StreetNumber` = '5733' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1761' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Please use the following address on GPS; 1528 Paul Quinn st. Houston, TX 77091 Cottages at\r\nHighland Pointe offers a gated community, two thoughtfully designed open concept floor plans,\r\nhigh-end interior finishes, stainless-steel appliances, dog park, fenced backyard and much\r\nmore. Conveniently situated just North of Oak Forest with easy access to 610, I-45, and I-10.\r\nLocated just minutes away from everything that The Heights and Downtown has to offer. Move-in\r\nready by Fall 2022 Virtual tour available on link above.' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = 'Orchid Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 16 Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '1681' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '99' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HIGHLAND HEIGHTS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'WILLIAMS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Highland Pointe' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668118994' WHERE `Matrix_Unique_ID` = '213495968' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-10T06:56:18.577' ,`MLSNumber` = '39786189' ,`ListAgentFullName` = 'Nancy Ramos' ,`ListOfficeName` = 'Nan & Company PropertiesChristie\'s International R' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.848805' ,`Longitude` = '-95.434476' ,`PhotoCount` = '24' ,`PostalCode` = '77091' ,`RoomCount` = '6' ,`ListPrice` = '344900.00' ,`Status` = 'Active' ,`StreetName` = 'White Magnolia' ,`StreetNumber` = '5738' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1761' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Please use the following address on GPS; 1528 Paul Quinn st. Houston, TX 77091 Cottages at\r\nHighland Pointe offers a gated community, two thoughtfully designed open concept floor plans,\r\nhigh-end interior finishes, stainless-steel appliances, dog park, fenced backyard and much\r\nmore. Conveniently situated just North of Oak Forest with easy access to 610, I-45, and I-10.\r\nLocated just minutes away from everything that The Heights and Downtown has to offer. Move-in\r\nready by Fall 2022 Virtual tour available on link above.' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = 'Orchid Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 19 Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '1681' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '99' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HIGHLAND HEIGHTS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'WILLIAMS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Highland Pointe' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668118995' WHERE `Matrix_Unique_ID` = '213496578' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-10T06:21:22.730' ,`MLSNumber` = '14928964' ,`ListAgentFullName` = 'Kyle Tweed' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.405993' ,`Longitude` = '-95.658990' ,`PhotoCount` = '36' ,`PostalCode` = '77356' ,`RoomCount` = '12' ,`ListPrice` = '1065000.00' ,`Status` = 'Active' ,`StreetName` = 'Grand Pine' ,`StreetNumber` = '11427' ,`StreetSuffix` = 'Drive' ,`City` = 'Montgomery' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '4836' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Within the gated and sought after community of Grand Harbor, this gorgeous waterfront estate boasts 5+ bedrooms and 4 bathrooms along with a 20ft. foyer and ceilings in living area. Open feel throughout all of the bedrooms and kitchen will leave you wanting to entertain! Impressive kitchen appliances including a double French door convection oven that will handle family holidays with ease. Beautiful Shaw carpet throughout the bedrooms, expansive closets, upstairs, and game room. Out back, you can enjoy your screened-in porch, or hop in the salt water pool and spa. Feeling adventurous? Head on down to your very own boat dock(boat lift and 2 jet ski lifts) and do some fishing, or take a boat ride to any of the wonderful restaurants Lake Conroe has to offer..sunsets included. 3 car garage. BRAND NEW roof. 2 new water heaters. 2 new A/C units. Grand Harbor includes: community boat ramp, volleyball,basketball,tennis courts, baseball field, covered pavilion. AMAZING Montgomery schools.' ,`Acres` = '0.489' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'GRAND HARBOR 06, BLOCK 1, LOT 13' ,`LotDesciption` = 'Subdivision Lot,Water View,Waterfront' ,`LotSize` = '21301' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground,Salt Water' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'MADELEY RANCH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MONTGOMERY HIGH SCHOOL' ,`SchoolMiddle` = 'MONTGOMERY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Mediterranean,Traditional' ,`Subdivision` = 'Grand Harbor 06' ,`TaxAmount` = '12526' ,`TaxRate` = '1.8242' ,`WaterSewer` = 'Aerobic,Other Water/Sewer,Septic Tank' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668118995' WHERE `Matrix_Unique_ID` = '213616426' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-10T06:50:20.897' ,`MLSNumber` = '9329558' ,`ListAgentFullName` = 'Karl Holub' ,`ListOfficeName` = 'Holub Realty & Investments' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.742050' ,`Longitude` = '-95.570440' ,`PhotoCount` = '34' ,`PostalCode` = '77042' ,`RoomCount` = '11' ,`ListPrice` = '519000.00' ,`Status` = 'Active' ,`StreetName` = 'Burgoyne' ,`StreetNumber` = '10914' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2720' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'JUST IN TIME FOR THE HOLIDAYS! LOCATION LOCATION IN LAKESIDE Estates, located in middle of cul de sac block this fully renovated home includes, porcelain entry with spiral staircase, formal dining, classic white kitchen with loads of custom cabinets soft close drawers and hinges, stainless appliances with gas range, huge pantry under stairwell for storage, 1/2 bath down, breakfast area with floor to ceiling windows, wet bar area for entertaining, generous living area with central fireplace and loads of furniture lay out options, nice private study area off living room, primary has laminate flooring, his and her closets and vanity areas, spa like master shower with large niche for storage, secondary bath has dual vanity, tub with Carrera style porcelain accents, all bedrooms have ceiling fans, new pex plumbing, tankless water heater, all new low e windows, led lighting in all rooms, THIS ONE is crisp and clean and ready for new owners TODAY!' ,`Acres` = '0.2168' ,`Area` = '31' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Briargrove Park/Walnutbend' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 42 BLK 4 LAKESIDE ESTATES SEC 2' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '9443' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '780' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WALNUT BEND ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WESTSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'REVERE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakeside Estates Sec 02' ,`TaxAmount` = '8108' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668118995' WHERE `Matrix_Unique_ID` = '213656685' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-10T05:46:28.117' ,`MLSNumber` = '27353660' ,`ListAgentFullName` = 'Deana Fojt' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.988696' ,`Longitude` = '-95.151846' ,`PhotoCount` = '29' ,`PostalCode` = '77346' ,`RoomCount` = '12' ,`ListPrice` = '485000.00' ,`Status` = 'Active' ,`StreetName` = 'Trophy Place' ,`StreetNumber` = '8311' ,`StreetSuffix` = 'Drive' ,`City` = 'Humble' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3403' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous home located in beautiful and highly desirable Walden on Lake Houston, just a few blocks from Golf and Country Club. Recent Upgrades include premium roof with CertainTeed Landmark PRO Shingles, AC installed in 2021, Recent Paint throughout home and new carpet on second floor, water heater, pool pump and many more updates. Great home for large group and entertaining. Three car garage for all your vehicles and storage. Sprinkler system and new wooden fence, 2020. As you walk thru front door you will see grand entrance with gorgeous staircase. Primary bedroom downstairs with luxury bath. Family room open to kitchen. Kitchen has island with cabinets galore. Formal dining area and study. Upstairs has huge gameroom with 4 bedrooms, Jack and Jill Bath and guest full bath. You have your own Oasis in your backyard with pool and covered canopy to sit and enjoy family entertaining. This is a must see!' ,`Acres` = '0.198' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Atascocita South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 23 BLK 36 TROPHY VILLAGE WALDEN ON LAKE HOUSTON PH 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8623' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '95' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'MAPLEBROOK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ATASCOCITA HIGH SCHOOL' ,`SchoolMiddle` = 'ATASCOCITA MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Walden On Lake Houston Ph 06' ,`TaxAmount` = '7129' ,`TaxRate` = '2.5885' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668118995' WHERE `Matrix_Unique_ID` = '213830366' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-10T06:21:17.553' ,`MLSNumber` = '46488403' ,`ListAgentFullName` = 'Karen Karapasha' ,`ListOfficeName` = 'Real Living Karapasha Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.713981' ,`Longitude` = '-95.836047' ,`PhotoCount` = '50' ,`PostalCode` = '77494' ,`RoomCount` = '11' ,`ListPrice` = '775000.00' ,`Status` = 'Active' ,`StreetName` = 'Cinco Falls' ,`StreetNumber` = '5107' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4390' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fantastic home in highly desired Cinco Ranch. Beautiful curb appeal welcomes you to a covered porch with brick pavers. Upon entering you will notice the tall ceilings, pretty hardwood flooring and wall of windows overlooking the backyard. Kitchen with light cabinetry, island, granite and dual ovens. The spacious family room with fireplace is open to the kitchen and provides ample space for family gatherings and entertaining. Primary bedroom located on first floor. Wall of windows with views to the pool/spa and nicely landscaped yard. Primary bath with dual sinks, jetted tub and walk in shower. Dual closets with built in closet systems. Three spacious bedrooms upstairs. Jack and Jill bath serves two of the rooms, Third full bath is open for access to bedroom, media and game room. New carpet throughout. Yard with pool/spa/slide and outdoor kitchen. Space for your furry friends. Great schools and walking distance to playground, trails and amenities. This home will wow you.' ,`Acres` = '0.2254' ,`Area` = '36' ,`BuilderName` = 'Trendmaker' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure,Special Addendum' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'CINCO RANCH SOUTHWEST SEC 46, BLOCK 3, LOT 36' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot' ,`LotSize` = '9817' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1150' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven,Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'STANLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'JORDAN HIGH SCHOOL' ,`SchoolMiddle` = 'SEVEN LAKES JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cinco Ranch' ,`TaxAmount` = '15928' ,`TaxRate` = '2.7695' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2011' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668118996' WHERE `Matrix_Unique_ID` = '214191061' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-10T06:21:31.857' ,`MLSNumber` = '68714729' ,`ListAgentFullName` = 'Judith Lisac' ,`ListOfficeName` = 'Redfin Corporation' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.289987' ,`Longitude` = '-94.809391' ,`PhotoCount` = '24' ,`PostalCode` = '77550' ,`RoomCount` = '9' ,`ListPrice` = '384900.00' ,`Status` = 'Active' ,`StreetName` = 'Avenue N 1/2' ,`StreetNumber` = '3922' ,`StreetSuffix` = '' ,`City` = 'Galveston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1374' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning 3 bedroom, 2 bath Galveston home with many of the original finishes and fixtures throughout. You will fall in love with the character of the home the moment you enter. Your guests are warmly greeted by a cozy living room with large windows. The formal dining room leads to your dream kitchen. The modern eat-in kitchen offers stainless steel appliances, butcher block counters, designer touches, and ample storage space while maintaining the home\'s unique charm. Spacious bedrooms and baths. The third bedroom can easily be used as a comfortable home office or studio! The covered front porch and deck in the back add to the great outdoor space. Great home and layout for entertaining guests. Great location and ready for you to make your own! 3D tour is available online!' ,`Acres` = '0.1185' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Midtown - Galveston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 628 M B MENARD SUR W 1/2 OF LOT 12 & E 1/2 OF LOT 13 (1' ,`LotDesciption` = 'Other' ,`LotSize` = '5160' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Galveston Outlots' ,`TaxAmount` = '5527' ,`TaxRate` = '2.0662' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1958' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668118996' WHERE `Matrix_Unique_ID` = '214194647' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-10T06:02:32.000' ,`MLSNumber` = '88127877' ,`ListAgentFullName` = 'Stephen Wilhite' ,`ListOfficeName` = 'Keller Williams Realty - Clear Lake/ NASA' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.127161' ,`Longitude` = '-95.066861' ,`PhotoCount` = '48' ,`PostalCode` = '77554' ,`RoomCount` = '11' ,`ListPrice` = '369000.00' ,`Status` = 'Active' ,`StreetName` = '1st' ,`StreetNumber` = '4022' ,`StreetSuffix` = 'Street' ,`City` = 'Galveston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1748' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Only about a 5 minute walk or 1 minute car ride from the beach, this coastal gem positioned on a 20,000 sq. ft. lot makes the perfect vacation home or rental property. The home comes fully furnished & sleeps 11. Upstairs has 2 bedrooms and a full bathroom with a spacious kitchen & living room. Laundry hook-ups available. Sit on the covered deck & enjoy peek-a-boo views of the beach & bay, listen to the crashing waves & spot sea birds from the nearby bird sanctuary. Downstairs is a bonus area with 7 ft ceilings boasting a living room, kitchen, full bathroom, laundry room, & bedroom. The property houses multiple storage units for housing your beach toys & an outdoor shower with sink and hot & cold water. The home is fully stocked and ready to go with EVERYTHING INCLUDED! The alarm system is wired to arm the whole house or upstairs/downstairs separately. The optional HOA provides a boat ramp & pavilion. Enjoy volleyball, ping pong, pool, or head to the beach at this chateau by the sea!' ,`Acres` = '0.4591' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West End' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 121 HALL & JONES SUR N 1/2 OF LOT 15 (15-1) BAY HARBOR' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '20000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Bay Harbor' ,`TaxAmount` = '5566' ,`TaxRate` = '2.0324' ,`WaterSewer` = 'Aerobic,Public Water,Septic Tank,Water District' ,`YearBuilt` = '1959' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668118996' WHERE `Matrix_Unique_ID` = '214209738' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-10T05:52:10.917' ,`MLSNumber` = '47384142' ,`ListAgentFullName` = 'Karen Dawson' ,`ListOfficeName` = 'Keller Williams Realty - Memorial' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.923597' ,`Longitude` = '-95.091452' ,`PhotoCount` = '27' ,`PostalCode` = '77532' ,`RoomCount` = '4' ,`ListPrice` = '244900.00' ,`Status` = 'Active' ,`StreetName` = 'Northwood Springs' ,`StreetNumber` = '1603' ,`StreetSuffix` = 'Drive' ,`City` = 'Crosby' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1545' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful one-story home is located in the desirable Newport Subdivision. The Laurel Plan by Lennar Homes features an open concept with an expansive living area perfect for entertaining. The kitchen boasts, SS appliances, granite kitchen counters, breakfast bar, and dining area looking out over the large backyard. There are plenty of windows to let in natural light. The spacious primary suite has dual sinks, separate tub/shower, linen closet, and large walk-in closet. The interior of the home has been freshly painted (10/2022). Walking Trails & Parks are maintained by the MUD District. Swimming pools, gym, etc are maintained by the HOA and residents wishing access to these items will pay an additional annual fee to the HOA.' ,`Acres` = '' ,`Area` = '1' ,`BuilderName` = 'Lennar Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Crosby Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lt 17 Blk 1 Newport Sec 12' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot' ,`LotSize` = '5990' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '55' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '12 - Crosby' ,`SchoolElementary` = 'CROSBY ELEMENTARY SCHOOL (CROSBY)' ,`SchoolHigh` = 'CROSBY HIGH SCHOOL' ,`SchoolMiddle` = 'CROSBY MIDDLE SCHOOL (CROSBY)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Newport' ,`TaxAmount` = '5211' ,`TaxRate` = '2.7105' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668118996' WHERE `Matrix_Unique_ID` = '214229031' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-10T05:21:56.690' ,`MLSNumber` = '96555976' ,`ListAgentFullName` = 'Lisa Hudgens' ,`ListOfficeName` = 'RE/MAX Northwest, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.028880' ,`Longitude` = '-95.492754' ,`PhotoCount` = '43' ,`PostalCode` = '77379' ,`RoomCount` = '8' ,`ListPrice` = '300000.00' ,`Status` = 'Active' ,`StreetName` = 'Ashmere' ,`StreetNumber` = '5307' ,`StreetSuffix` = 'Lane' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2472' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Lovely home in sought after Terranova in Klein ISD. The home features a large family room with brick surround gas fireplace with a beautiful wood mantle & lovely view of the backyard. The formal dining room has wainscotting & opens into the kitchen for ease of entertaining. The kitchen has double electric ovens, electric cooktop & opens into the breakfast room with bay windows & a wet bar area. On the second floor you will find all bedrooms & Gameroom all with updated carpet. The primary bedroom is to the left of the Gameroom while the secondary bedrooms & bathroom are to the right. The primary bedroom has plush carpet, crown molding, ceiling fan & updated En suite bath, dual sinks, knee space vanity, tub/shower combo & built-in linen closet. The 3 secondary bedrooms all have updated carpet, ceiling fans & closets. The secondary bath has dual sinks & a separate water closet with tub/shower combo. Oversized backyard with plenty of greenspace, landscaped flower beds & patio area.' ,`Acres` = '0.2382' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 337 BLK 10 TERRANOVA SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10375' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'BENFER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN HIGH SCHOOL' ,`SchoolMiddle` = 'STRACK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Terranova' ,`TaxAmount` = '4671' ,`TaxRate` = '2.3266' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668118996' WHERE `Matrix_Unique_ID` = '214251803' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-10T06:38:48.743' ,`MLSNumber` = '85382023' ,`ListAgentFullName` = 'Christopher Chiappetta' ,`ListOfficeName` = 'Randall Stewart Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.557946' ,`Longitude` = '-95.017239' ,`PhotoCount` = '7' ,`PostalCode` = '77586' ,`RoomCount` = '5' ,`ListPrice` = '875000.00' ,`Status` = 'Active' ,`StreetName` = 'Todville Road' ,`StreetNumber` = '1206' ,`StreetSuffix` = '' ,`City` = 'Seabrook' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '3225' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This uniquely designed waterfront home with amazing views of Galveston Bay and exciting Kemah Boardwalk. Great ocean views! This home has got an Open floor plan with high ceilings, 2 balconies one on the living room floor and the other in the spacious primary room. All bedrooms have their own bathrooms with walk in closets, Jetted Tubs, Wood cabinets, granite counter tops through the kitchen and bathrooms, recessed lighting and a fenced in backyard. Room measurements are approximate. * New updated photos coming soon!' ,`Acres` = '' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Clear Lake Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LOT 6 BLK 16' ,`LotDesciption` = 'Water View' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'BAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'SEABROOK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Town Seabrook' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2011' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668118997' WHERE `Matrix_Unique_ID` = '214294885' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-10T06:44:56.067' ,`MLSNumber` = '25542906' ,`ListAgentFullName` = 'Ryan Massa' ,`ListOfficeName` = 'Keller Williams Realty - Clear Lake/ NASA' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.386752' ,`Longitude` = '-95.022431' ,`PhotoCount` = '39' ,`PostalCode` = '77568' ,`RoomCount` = '8' ,`ListPrice` = '299990.00' ,`Status` = 'Active' ,`StreetName` = 'Century Oaks' ,`StreetNumber` = '359' ,`StreetSuffix` = 'Lane' ,`City` = 'La Marque' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2290' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home just in time for the holidays! This 4 bedroom, two and a half bath, beautifully maintained Larkspur floorplan by Lennar is ready for its new owners! Open entering you will be greeted by a spacious open floor plan. The formal dining room flows seamlessly into the kitchen which is open to the family room and breakfast nook. Your oversized primary bedroom suite is located off of the family room and includes a gorgeous en-suite bathroom and huge walk in closet! Make your way upstairs to be greeted by a large game room and the other 3 generously sized secondary bedrooms. The large backyard includes a covered patio and no back neighbors. This home is conveniently located right off of I-45 located between Houston and Galveston and surrounded by restaurants, shopping, and just minutes away from the famous Lago Mar Lagoon, Tanger Outlets, and Bucees! Schedule your showing today and be in your new home just in time for the holidays!' ,`Acres` = '0.1437' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'La Marque' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 12 BLK 3 LANDING AT DELANY COVE SEC 5 (2018) ABST 2' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '6260' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '475' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '26 - Hitchcock' ,`SchoolElementary` = 'HITCHCOCK PRIMARY/STEWART ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HITCHCOCK HIGH SCHOOL' ,`SchoolMiddle` = 'CROSBY MIDDLE SCHOOL (HITCHCOCK)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Landing/Delany Cove Sec 5' ,`TaxAmount` = '8161' ,`TaxRate` = '3.1135' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668118997' WHERE `Matrix_Unique_ID` = '214514584' --> 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','214542861','1668118997','214542861','2022-11-10T06:39:42.530','25607727','Katy Walston','Keller Williams Professionals','','','29.884413','-95.568991','42','77040','12','339900.00','Active','Acapulco','16317','Drive','Jersey Village','2','1','4','2360','Single-Family','Beautiful Move In Ready, 4 Bed/2.5 Bath, Two Story on Oversized Lot in Highly Coveted Jersey Village! Too Many Upgrades & Features to List them All! Some features include; Ext Neutral Tile & Engineered Hardwood Floors Downstairs, New Carpet (10/22), Study or Formal Living Room, Formal Dining, Spacious Family Room with Wood Burning Brick Fireplace w/Hearth, Chef\'s Kitchen w/Double Ovens, Plenty of Cabinet and Counter Space + Walk in Pantry, Sizeable Breakfast Room, Half Bath and Indoor Utility Room, Upstairs is the Large Primary Retreat w/Neutral Paint, Separate Vanity area + Closets & Storage Galore, Three Oversized Secondary Bedrooms + Full Bath, PEX Piping, Hardiplank Siding, Roof (\'16), A/C Coil (\'21), Detached 2 Car Garage, HUGE Backyard w/plenty of room for a pool, party patio & still have greenspace to run and play! Located close to 290, Beltway 8, Grocery Stores, Restaurants, Retail & More! Zoned to CFISD Schools! Never Flooded Per Seller!','0.2706','10','','','Electric Dryer Connections,Washer Connections','','Exclusions,Sellers Disclosure','1','Wood Burning Fireplace','1','Jersey Village','Central Electric','0','TR 5 BLK 23 JERSEY VILLAGE COUNTRY CLUB ESTS 2 ANNEX A1','In Golf Course Community,Subdivision Lot','11786','Appraisal District','','','0','','2','Double Oven,Electric Oven','0','','','Electric Cooktop','','Composition','13 - Cypress-Fairbanks','POST ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)','JERSEY VILLAGE HIGH SCHOOL','COOK MIDDLE SCHOOL','Appointment Required,Supra Keybox','Appraisal','2','Traditional','Jersey Village','5978','2.7758','Public Sewer,Public Water','1977','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','214577650','1668118997','214577650','2022-11-10T05:34:52.050','9036941','Donn Clark','R. Alexa Group LLC','','','29.622066','-95.016160','18','77571','3','246000.00','Active','Forest','614','Avenue','Shoreacres','2','0','3','1550','Single-Family','THIS A BEAUTIFUL PATIO HOME WITH A LARGE BACK YARD INCLUDING A LARGE UPDATED POOL, SHED AND THE LOT HAS MORE AREA FOR GARDENING, KIDS PLAYGROUND. DOUBLE PANE WINDOWS,NEW HVAC IN 2019. HOME HAS STAINLESS STEEL APPLICANCES AND TILE THROUGHOUT. LOCATED NEAR A PRIVATE PIER AND IS CLOSE TO SHOPPING AND DINING. THIS IS GREAT PLACE TO MAKE MANY FAMILY MEMORIES.FULLY UPDATED KITCHEN, NEW GENERATOR NEW BATTERY, AND POOL FILTER NEW IN 2022. ELECTRICAL UPDATED 2021, PRIMARY BATH FULLY UPDATED 20021, MAIN BATH NEW VANITY, SINK,AND FIXTURES 2021.','0.2984','7','','','','','Sellers Disclosure','','','','Shoreacres/La Porte','Central Electric','0','LT 14 BLK 31 SHOREACRES','Other','13000','Appraisal District','','','0','','1','','1','Gunite,In Ground','','','','Composition','35 - La Porte','BAYSHORE ELEMENTARY SCHOOL','LA PORTE HIGH SCHOOL','LA PORTE J H','Accompany,Appointment Required,Lockbox Front','Appraisal District','1','Ranch','Shoreacres','4448','2.8597','Public Sewer,Public Water','1960','Appraisal District'); --> New record created successfully