Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-27T05:49:29.050' ,`MLSNumber` = '25624967' ,`ListAgentFullName` = 'Jeffrey Walters' ,`ListOfficeName` = 'Virginia Malone & Assoc.,' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.513967' ,`Longitude` = '-94.987762' ,`PhotoCount` = '12' ,`PostalCode` = '77518' ,`RoomCount` = '6' ,`ListPrice` = '185000.00' ,`Status` = 'Active' ,`StreetName` = 'Estes' ,`StreetNumber` = '3906' ,`StreetSuffix` = 'Street' ,`City` = 'Bacliff' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1064' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Cute cottage with 3 bedrooms, 1 bath and all new a/c, electrical and plumbing. This one has been refurbished inside and out. Flooring, paint, cabinets, fixtures and so much more. Sit out on the patio drinking coffee in the breeze. New concrete driveway being poured prior to closing. Storage building out back. Perfect vacation spot near the water or forever home. Close to boat ramp, popular restaurant/bar and community park. Large storage building in back.' ,`Acres` = '0.1667' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Bacliff/San Leon' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 89 S HINTON LOT 2 BLK 5 PERKINS BEACH 2ND & IMPS' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7263' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'KENNETH E. LITTLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'DUNBAR MIDDLE SCHOOL (DICKINSON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Perkins Beach 2nd' ,`TaxAmount` = '447' ,`TaxRate` = '2.2342' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664277399' WHERE `Matrix_Unique_ID` = '209722976' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-27T04:59:31.563' ,`MLSNumber` = '42822677' ,`ListAgentFullName` = 'Annie Rivers' ,`ListOfficeName` = 'Keller Williams Hou Preferred' ,`SellingAgentFullName` = 'Grace Popoola' ,`SellingOfficeName` = 'Texas United Realty' ,`Latitude` = '29.624440' ,`Longitude` = '-95.397064' ,`PhotoCount` = '28' ,`PostalCode` = '77047' ,`RoomCount` = '7' ,`ListPrice` = '260000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Jelicoe' ,`StreetNumber` = '11816' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1631' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MOVE-IN READY!!COME HOME TO THIS BEAUTIFUL 3 BEDROOMS AND 2.5 BATHROOMS HOME LOCATED ON CORNER LOT IN CITY PARK SUBDIVISION. EASY ACCESS TO TX 288, 610 LOOP; MINUTES FROM MEDICAL CENTER AND SHOPPING AREAS, THIS HOME HAS MANY GREAT FEATURES, FORMAL DINING ROOM WITH TWO LARGE WINDOWS; DOWNSTRAIRS LAMINATE FLOORING; SPACIOUS FAMILY ROOM; KITCHEN WITH NICE CABINETRY; BREEAKFAST AREA; CEILING FANS; BLINDS THROUGHOUT; UPSTAIRS HAS HUGE GAME ROOM; BRIGHT PRIMARY BEDROOM WITH MUCH CLOSET SPACE; SECONDARY BEDROOMS HAVE PLENTY OF ROOMS; RECENTLY INSTALLED ROOF; BACKYARD HAS PATIO AND BRIGHT FENCING; MUCH MORE! GREAT BUY!!' ,`Acres` = '0.0693' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Five Corners' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 41 BLK 4 CITY PARK SEC 5' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '3017' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '735' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ALMEDA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WORTHING HIGH SCHOOL' ,`SchoolMiddle` = 'LAWSON MIDDLE SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'City Park Sec 05' ,`TaxAmount` = '5381' ,`TaxRate` = '3.0307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2009' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664277399' WHERE `Matrix_Unique_ID` = '210402723' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-27T05:50:59.917' ,`MLSNumber` = '17991752' ,`ListAgentFullName` = 'Jason Vo' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.895624' ,`Longitude` = '-95.530906' ,`PhotoCount` = '23' ,`PostalCode` = '77040' ,`RoomCount` = '14' ,`ListPrice` = '469000.00' ,`Status` = 'Active' ,`StreetName` = 'Lawncliff' ,`StreetNumber` = '8911' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3230' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome HOME to this spacious 3400 SQFT with 4 Bedroom, 2.5 Bath, 2 car garage located in Rolling Fork subdivision. This home features high ceiling, formal living and dining, double-sided fireplace, enclosed outdoor kitchen with gas stove and counter space, completed landscaping with concrete, and raised garden bed all around. It also comes with a spacious great room located in the back which could be used as a library, living room, or an extra bedroom with a built-in closet and cabinets. Recently updated including new vinyl flooring and carpet in all bedrooms. A lot of windows provide natural light throughout the home. The welcoming den provides great flow into the Kitchen and Breakfast area. The beautiful staircase upstairs will lead to the spacious game room, 2 of the bedrooms feature a study area with a lot of nature lights. Zone to Jersey Village High-school. Close to businesses and restaurants. LOW TAX RATE. CALL NOW TO SCHEDULE A PRIVATE SHOWING.' ,`Acres` = '0.1205' ,`Area` = '11' ,`BuilderName` = 'David Weekley homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 34 BLK 5 ROLLING FORK SEC 5 R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'REED ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'JERSEY VILLAGE HIGH SCHOOL' ,`SchoolMiddle` = 'DEAN MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Rolling Fork Sec 05 Pt Rep' ,`TaxAmount` = '6919' ,`TaxRate` = '2.571' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1992' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664277400' WHERE `Matrix_Unique_ID` = '210986738' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-27T05:36:54.780' ,`MLSNumber` = '68580627' ,`ListAgentFullName` = 'Jennifer Auer' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.137855' ,`Longitude` = '-95.541474' ,`PhotoCount` = '50' ,`PostalCode` = '77515' ,`RoomCount` = '7' ,`ListPrice` = '615000.00' ,`Status` = 'Active' ,`StreetName` = 'Wagon Wheel' ,`StreetNumber` = '432' ,`StreetSuffix` = 'Trail' ,`City` = 'Angleton' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2174' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Exquisite custom home on 3 acres situated on 3 bayou lots. The sizable open floor plan provides a sophisticated yet relaxing layout! Home provides 3 spacious bedrooms, 2 baths, gourmet open kitchen offering gas stove/oven combination, granite countertops, island for all your food preparation, custom cabinets with undercabinet lighting, bar overlooking family room. Extra large Primary suite, very large closet, dual sinks and large walk in shower with double shower head. Property includes a 30X60 metal framed barn, 12X14\' dual manual rolling doors with a side personnel door with access to backyard. Plumbed for full accessible bathroom usage with it\'s own double driveway, turning into a triple drive. Beautiful privacy fence on 3 sides with back chain link fence covered with black rubber coating so it does not impair your view to bayou or wildlife. Extended back porch with remote controlled LED lighting, fan, and TV!' ,`Acres` = '3' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Angleton' ,`HeatSystem` = 'Central Electric,Central Gas,Propane' ,`HOAMandatory` = '1' ,`Legal` = 'BAR X RANCH (A0038 J B BAILEY) LOT 157-159 ACRES 3.00' ,`LotDesciption` = 'Cleared,Subdivision Lot,Water View,Waterfront,Wooded' ,`LotSize` = '130680' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '10 - Columbia-Brazoria' ,`SchoolElementary` = '' ,`SchoolHigh` = 'COLUMBIA HIGH SCHOOL' ,`SchoolMiddle` = 'WEST BRAZOS JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required,Controlled Access' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Bar X Ranch' ,`TaxAmount` = '4075' ,`TaxRate` = '1.6364' ,`WaterSewer` = 'Aerobic,Septic Tank,Well' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664277400' WHERE `Matrix_Unique_ID` = '211698257' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-27T05:17:48.193' ,`MLSNumber` = '3257757' ,`ListAgentFullName` = 'Marnie Wyatt' ,`ListOfficeName` = 'Wyatt Realty Group, Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.542847' ,`Longitude` = '-95.366209' ,`PhotoCount` = '23' ,`PostalCode` = '77584' ,`RoomCount` = '7' ,`ListPrice` = '490000.00' ,`Status` = 'Active' ,`StreetName` = 'Senova Dr' ,`StreetNumber` = '3427' ,`StreetSuffix` = 'Drive' ,`City` = 'Pearland' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3346' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '*Brand New Roof 9/16/22.\r\nStunning home located in Pearland with quick access to Downtown Houston and other convenient places. When you first walk in you will notice the stunning staircase that boasts elegance. High ceilings and an open concept make this home ideal for entertaining. While walking through the home, you will notice the amazing views of the backyard/pool area through the Kitchen, Living Room, upstairs walkway and the Primary Bedroom.\r\n There is an amazing amount of natural light and a great floorplan that allows everyone to have their own space.\r\nZoned to highly rated schools is just a bonus for this beautiful home.\r\nOutside of the home there is access to parks throughout the subdivision, along with a tennis court and an amazing golf course. Grocery stores and other shopping/eating options are literally minutes away,\r\nSchedule your personal tour today! Per Seller a new roof will be placed asap.' ,`Acres` = '0.2435' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'CAMBRIDGE COVE AT SILVERLAKE SEC 1 (A0548-A0721) BLK 1 LOT 2' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot' ,`LotSize` = '10607' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '685' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '42 - Pearland' ,`SchoolElementary` = 'SILVERLAKE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GLENDA DAWSON HIGH SCHOOL' ,`SchoolMiddle` = 'BERRY MILLER JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cambridge Cove At Silverlake S' ,`TaxAmount` = '9389' ,`TaxRate` = '2.3537' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1997' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664277400' WHERE `Matrix_Unique_ID` = '211707120' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-27T05:57:46.683' ,`MLSNumber` = '16522731' ,`ListAgentFullName` = 'Amy Shelton' ,`ListOfficeName` = 'Fife Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.125151' ,`Longitude` = '-95.461903' ,`PhotoCount` = '37' ,`PostalCode` = '77380' ,`RoomCount` = '8' ,`ListPrice` = '414900.00' ,`Status` = 'Active' ,`StreetName` = 'N Dreamweaver' ,`StreetNumber` = '170' ,`StreetSuffix` = 'Circle' ,`City` = 'The Woodlands' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2544' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '!!NEWLY RENOVATED!! Please see ADDITIONAL INFO PAGE!!This 4 bedroom 2.5 bathroom will surprise you at every turn. BONUS ROOM how about two!! You will love the neat and fun additions that have been added to make this home MOST comfortable. Space and Storage are no issue here. Did I mention RENOVATIONS?! Paint, flooring, kitchen cabinets, back splash and counter tops have turned this home into a GEM!! NEW NEW NEW Stainless Steel Appliances!! ATTIC SPACES, there are two all with wood flooring. Both attics have modern, metal stairs with built-in insulation. \r\nEasy access to I45 and 99! The Woodlands Pools and community offer entertainment for all ages. You will know your close when you see the beautiful tall trees that make The Woodlands a staple community. DO NOT MISS OUT!! This home will not last long!!' ,`Acres` = '0.17' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'WDNLDS VIL GROGANS ML 65, BLOCK 3, LOT 15' ,`LotDesciption` = 'Other' ,`LotSize` = '7412' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'SAM HAILEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'THE WOODLANDS COLLEGE PARK HIGH SCHOOL' ,`SchoolMiddle` = 'KNOX JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'WDNLDS VIL GROGANS ML' ,`TaxAmount` = '7380' ,`TaxRate` = '2.18' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1994' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664277400' WHERE `Matrix_Unique_ID` = '212028278' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-27T05:49:05.663' ,`MLSNumber` = '45517537' ,`ListAgentFullName` = 'Lara Leikam' ,`ListOfficeName` = 'eXp Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.984182' ,`Longitude` = '-95.649186' ,`PhotoCount` = '20' ,`PostalCode` = '77429' ,`RoomCount` = '13' ,`ListPrice` = '410000.00' ,`Status` = 'Active' ,`StreetName` = 'Stonemeade' ,`StreetNumber` = '14923' ,`StreetSuffix` = 'Place' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2766' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Lovely single story home with a great floor plan in the Longwood Village golf course community! Large cul-de-sac lot with an oversized park-like backyard. 3-bedroom, 2.5-bathroom with great flexible floor plan with two additional bonus rooms that can be used for flex space. Enjoy an eat in kitchen complete with island and granite countertops, living room has cozy fireplace and beautiful built ins. Don’t wait to make this home yours!' ,`Acres` = '0.4026' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 11 BLK 3 LONGWOOD VILLAGE SEC 1' ,`LotDesciption` = 'Cul-De-Sac,In Golf Course Community' ,`LotSize` = '17539' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1112' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'HAMILTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CY-FAIR HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Longwood Village' ,`TaxAmount` = '7569' ,`TaxRate` = '2.4837' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1994' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664277400' WHERE `Matrix_Unique_ID` = '212265417' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-27T05:49:53.883' ,`MLSNumber` = '66254863' ,`ListAgentFullName` = 'Alfonso Garcia' ,`ListOfficeName` = 'Generation Realty & Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.009340' ,`Longitude` = '-95.186526' ,`PhotoCount` = '13' ,`PostalCode` = '77346' ,`RoomCount` = '7' ,`ListPrice` = '309900.00' ,`Status` = 'Active' ,`StreetName` = 'Pioneer' ,`StreetNumber` = '19810' ,`StreetSuffix` = 'Court' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2533' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This is the one you have been waiting for. Walk up to a beautifully landscaped yard with a newly poured sidewalk from driveway to door. This home features tons of upgrades from sleek hardwood floors to a gorgeous updated kitchen with granite counter tops and high end Thermador appliances. Also kitchen opens up to breakfast room and large living room perfect for family entertainment. More updates include updated primary bath, light fixtures, gas fire place, and LED lighting through out. This home is move in ready and waiting for the right family. Book your appointment today because it won\'t last long. DID NOT FLOOD' ,`Acres` = '0.1874' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Atascocita North' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 56 BLK 15 OAKS OF ATASCOCITA SEC 3 R/P' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '8165' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '477' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Wood Shingle' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'OAKS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ATASCOCITA HIGH SCHOOL' ,`SchoolMiddle` = 'TIMBERWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Oaks Atascocita Sec 03 R/P' ,`TaxAmount` = '5203' ,`TaxRate` = '2.613' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1987' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664277400' WHERE `Matrix_Unique_ID` = '212422178' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-27T05:59:28.643' ,`MLSNumber` = '53468222' ,`ListAgentFullName` = 'Maria McDill' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.990700' ,`Longitude` = '-95.515353' ,`PhotoCount` = '48' ,`PostalCode` = '77069' ,`RoomCount` = '10' ,`ListPrice` = '389500.00' ,`Status` = 'Active' ,`StreetName` = 'Foxmoor' ,`StreetNumber` = '13718' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2501' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WELCOME HOME. A unique charming place in Huntwick. Great street on cul de sac. Corner lot w/mature trees and beautiful brick elevation. As you enter the home, you are welcomed to a full view of the pool/patio thru an oversize window. Great kitchen space & breakfast room with gorgeous view to the backyard. Study or hobby room has a window facing the front of the house, next to kitchen. Step down Living room/Formal dining area has a large bookcase surrounding the gas log brick fireplace. Upstairs all rooms are large w/very spacious closets. Primary bedroom is oversize with a bookcase on corner. Large window, his and her closet, combo shower/tub. This house is absolutely beautiful with tons of potentials to make it even nicer, if desired. Patio is an oasis with a large pool, mature live oak and shaded plants. It has a side yard for pets or a small garden. This house won\'t last. Elegant elevation makes this home very attractive as you see it from the street. Beautiful inside and outside!!!' ,`Acres` = '0.2479' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 5 BLK 13 HUNTWICK FOREST SEC 4' ,`LotDesciption` = 'Corner,Cul-De-Sac,Subdivision Lot' ,`LotSize` = '10800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '165' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'YEAGER ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CYPRESS CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'BLEYL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Huntwick Forest' ,`TaxAmount` = '5559' ,`TaxRate` = '2.4306' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1973' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664277401' WHERE `Matrix_Unique_ID` = '212566914' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-27T04:40:50.107' ,`MLSNumber` = '34309093' ,`ListAgentFullName` = 'Bunnang Chy' ,`ListOfficeName` = 'NB Elite Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.539857' ,`Longitude` = '-95.354512' ,`PhotoCount` = '11' ,`PostalCode` = '77584' ,`RoomCount` = '3' ,`ListPrice` = '385000.00' ,`Status` = 'Active' ,`StreetName` = 'Webber' ,`StreetNumber` = '4103' ,`StreetSuffix` = 'Drive' ,`City` = 'Pearland' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2341' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.1941' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'SOUTHWYCK, BLOCK 4, LOT 1 SEC 8-PHASE 1, A0548 HT&BRR' ,`LotDesciption` = 'Cleared,Corner' ,`LotSize` = '8455' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '530' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '42 - Pearland' ,`SchoolElementary` = 'MASSEY RANCH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GLENDA DAWSON HIGH SCHOOL' ,`SchoolMiddle` = 'PEARLAND JUNIOR HIGH SOUTH' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Southwyck' ,`TaxAmount` = '7971' ,`TaxRate` = '2.5552' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1995' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664277401' WHERE `Matrix_Unique_ID` = '212985115' --> Updated record success