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-12T22:45:28.130' ,`MLSNumber` = '24674199' ,`ListAgentFullName` = 'Cathy Lakey' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.224269' ,`Longitude` = '-95.532867' ,`PhotoCount` = '36' ,`PostalCode` = '77382' ,`RoomCount` = '10' ,`ListPrice` = '540000.00' ,`Status` = 'Active' ,`StreetName` = 'Connemara' ,`StreetNumber` = '407' ,`StreetSuffix` = 'Drive' ,`City` = 'The Woodlands' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '2193' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This gorgeous Martin Ray floor plan in the area\'s premier active adult community is loaded with luxury features! Builder upgrades include the high-end front elevation with porch and stone accents, sunroom, 4-foot garage extension, gourmet white kitchen, huge 9-foot shower in primary bath, fireplace framed by a wall of stacked stone, plus hardwood flooring throughout except baths and utility which are tile. NO CARPET! Sellers added custom built-ins in the study, including a sliding \"barn\" door, custom closet built-ins in both bedrooms, cabinets in the utility room, a custom \"drop zone,\" plus cabinets and a sink in the garage. A huge glass shower was also added in the secondary bath. This lovely home is framed by beautiful flowering gardens in both front yard and back, with a pretty patio done with pavers and accented with a pergola, perfect for relaxing in privacy as there are no back neighbors. Plus iron fencing, water softener, insulated garage door and a whole-house generator!' ,`Acres` = '0.1456' ,`Area` = '15' ,`BuilderName` = 'Pulte' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S402303 - DEL WEBB THE WOODLANDS 03, BLOCK 1, LOT 35' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '6341' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2560' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'TOM R. ELLISOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Del Webb The Woodlands 03' ,`TaxAmount` = '7094' ,`TaxRate` = '1.8587' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668418296' WHERE `Matrix_Unique_ID` = '203687831' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-12T22:51:06.453' ,`MLSNumber` = '47837323' ,`ListAgentFullName` = 'Leonor Anguiano' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.880265' ,`Longitude` = '-95.634443' ,`PhotoCount` = '50' ,`PostalCode` = '77095' ,`RoomCount` = '9' ,`ListPrice` = '429900.00' ,`Status` = 'Active' ,`StreetName` = 'Halfpenny' ,`StreetNumber` = '7014' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3340' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This Spacious home is in a rare find and sits off the golf course, which is central to the Heartstone Country Club Community. It has no history of flooding and enjoys convenient access to area amenities via Highway 529, Highway 6, Beltway 8, and 290. The 5 BR /3.5 BA home has a detached 2-car garage with a WORKSHOP and a side door for golf cart access and additional parking. Recent updates include lighting, flooring, paint, recent foundation repairs; NEW ROOF,, slate entry floor, upstairs air handler (installed 2022) new heat pump for downstairs (installed 2021) Upgraded electrical panel;, the whole house reverses osmosis water system; \"Low E\" windows; and PEX piping throughout. Primary en suites are located on both, First and Second floors, plus extensive storage throughout the home\'s interior decked attic and detached garage. PEX piping. Optional membership to the Hearthstone Country Club offers premium golf, tennis, swimming, dining, and exercise facilities.' ,`Acres` = '0.2525' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Copperfield Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 14 BLK 3 FAIRWAY WEST SEC 1 R/P' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '11000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '560' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'OWENS ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CYPRESS FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'LABAY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Hearthstone' ,`TaxAmount` = '7053' ,`TaxRate` = '2.501' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1977' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668418296' WHERE `Matrix_Unique_ID` = '209809935' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-12T21:16:14.383' ,`MLSNumber` = '12052589' ,`ListAgentFullName` = 'Karen Turney' ,`ListOfficeName` = 'Coldwell Banker RealtyThe Willis Office' ,`SellingAgentFullName` = 'Karen Turney' ,`SellingOfficeName` = 'Coldwell Banker RealtyThe Willis Office' ,`Latitude` = '30.408079' ,`Longitude` = '-95.650155' ,`PhotoCount` = '34' ,`PostalCode` = '77356' ,`RoomCount` = '6' ,`ListPrice` = '600000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Grand Harbor' ,`StreetNumber` = '18747' ,`StreetSuffix` = 'Point' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2626' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning 4 bedroom 2 1\\2 bath home with incredible views of Lake Conroe. Situated on a 1 acre lot, fully fenced backyard. Lovely in ground pool with spa, meditation area and a handmaid vegetable garden. Double pane windows, Geninstar in second attic. Stairway in home leads to a multi purpose room, could be used as a game/media/activity room. Primary bathroom completely renovated last year. Some of the features include steam shower, oversized jacuzzi tub, mach fireplace & custom tile work. Beautiful landscaped yard, sprinkler system and generator included. THIS IS A MUST SEE!' ,`Acres` = '0.9' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'HOA First Right of Refusal' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S538002 - GRAND HARBOR 02, BLOCK 2, LOT 3-A' ,`LotDesciption` = 'Corner' ,`LotSize` = '39204' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'MADELEY RANCH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MONTGOMERY HIGH SCHOOL' ,`SchoolMiddle` = 'MONTGOMERY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Grand Harbor 02' ,`TaxAmount` = '7227' ,`TaxRate` = '1.8242' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668418296' WHERE `Matrix_Unique_ID` = '212257444' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-12T22:37:01.223' ,`MLSNumber` = '35084477' ,`ListAgentFullName` = 'Stanley Mani' ,`ListOfficeName` = 'MIH REALTY, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.699345' ,`Longitude` = '-95.720080' ,`PhotoCount` = '50' ,`PostalCode` = '77407' ,`RoomCount` = '11' ,`ListPrice` = '420000.00' ,`Status` = 'Active' ,`StreetName` = 'Belford Park' ,`StreetNumber` = '7107' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2949' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '***CANCELLED- SUNDAY 11/13 OPEN HOUSE*** Gorgeous Updated 4bed 3.5Bath David Weekley Home tucked away in the beautiful \"Grand Mission\" Master-Planned community! As you take a step inside you are greeted by the foyer flanked by the study/office, and formal dining. Notice the updated wood tile-like flooring as you make your way through the first floor into the living area with built shelving, a brick-face fireplace, recessed lighting, and premium shutters. The kitchen comes with marble countertops, a buffet addition for extra cabinet and counter space, stainless steel appliances, updated cabinets/hardware/lighting/fixtures, and more! The primary bedroom has also been updated with new flooring, new entry door to the bedroom and primary bath, large walking closet with custom shelving and drawers! Primary bath equipped with soaking tub, stand-alone shower with bench, double sinks. Upstairs includes the spacious 3 secondary bedrooms, jack and bath, game room, and an additional 3rd full bath.' ,`Acres` = '0.1993' ,`Area` = '37' ,`BuilderName` = 'David Weekley' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'GRAND MISSION SEC 4, BLOCK 1, LOT 13' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '8682' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '965' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'SEGUIN ELEMENTARY (FORT BEND)' ,`SchoolHigh` = 'BUSH HIGH SCHOOL' ,`SchoolMiddle` = 'CROCKETT MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Grand Mission' ,`TaxAmount` = '6214' ,`TaxRate` = '2.5097' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668418296' WHERE `Matrix_Unique_ID` = '213022231' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-12T21:07:01.003' ,`MLSNumber` = '57387592' ,`ListAgentFullName` = 'Ward Arnold' ,`ListOfficeName` = 'Ward Arnold Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.749799' ,`Longitude` = '-95.394093' ,`PhotoCount` = '49' ,`PostalCode` = '77006' ,`RoomCount` = '8' ,`ListPrice` = '1650000.00' ,`Status` = 'Active' ,`StreetName` = 'Drew' ,`StreetNumber` = '1206' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '5' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4098' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning Ultra Modern Home located in the heart of Montrose. Home features outdoor entertainment area that includes hot-tub, firepit complete out door kitchen, and custom bar surrounding hot-tub! Entertainment area w/ it\'s own private bath. Hardwood flooring throughout. Primary bedroom features soaring ceiling custom lighting & extraordinary amounts of natural lighting. Primary bath that features quartz counter top\'s and wet area for tub & custom shower. All secondary room have private baths. Custom window coverings throughout. Elevator ready!! Game / Study that leads to balcony overlooking the outdoor entertainment area. New roof and A/C & Heating replaced in October 2022. Private security gate that leads into covered walkway. Complete sprinkler system. Custom window coverings. Gourmet kitchen that has abundant amounts of cabinet\'s and counter space. Quartz counter tops and island. Kitchen overlooks family room great for entertaining. Custom wine rack like no other in the dining room.' ,`Acres` = '0.1148' ,`Area` = '16' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Montrose' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'LT 36 WESTOVER' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WILLIAM WHARTON K-8 DUAL LANGUAGE ACADEMY' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'GREGORY-LINCOLN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Back,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Westover' ,`TaxAmount` = '24320' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668418297' WHERE `Matrix_Unique_ID` = '213205563' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-12T22:07:01.473' ,`MLSNumber` = '62659448' ,`ListAgentFullName` = 'Elisa Gonzalez' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.884706' ,`Longitude` = '-95.632671' ,`PhotoCount` = '25' ,`PostalCode` = '77095' ,`RoomCount` = '12' ,`ListPrice` = '335000.00' ,`Status` = 'Active' ,`StreetName` = 'El Miranda' ,`StreetNumber` = '14918' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2274' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This exceptional 2 story home located in the very desirable, golfing community of Hearthstone, close to local schools. Home features a fresh and bright interior, crown molding, gas log fireplace, plantation shutters, and built-ins. Make yourself at home in the spacious primary bedroom with en-suite bath with large closet, his and her vanities, whirlpool tub, and separate shower. Walking distance to Hearthstone Country Club complete with championship golf course. Community amenities include park and walking trails. Great location with easy access to SH 290 and Highway 6. Schools are zoned to Cypress-Fairbanks ISD.' ,`Acres` = '0.1928' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Copperfield Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 12 BLK 13 HEARTHSTONE SEC 1' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot' ,`LotSize` = '8400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '560' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'OWENS ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CYPRESS FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'LABAY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Hearthstone Sec 01' ,`TaxAmount` = '5718' ,`TaxRate` = '2.501' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668418297' WHERE `Matrix_Unique_ID` = '213584730' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-12T22:41:24.343' ,`MLSNumber` = '39216849' ,`ListAgentFullName` = 'Kelley Brouillette' ,`ListOfficeName` = 'Berkshire Hathaway HomeServicePremier Properties' ,`SellingAgentFullName` = 'Kelley Brouillette' ,`SellingOfficeName` = 'Berkshire Hathaway HomeServicePremier Properties' ,`Latitude` = '29.694744' ,`Longitude` = '-95.789371' ,`PhotoCount` = '36' ,`PostalCode` = '77406' ,`RoomCount` = '8' ,`ListPrice` = '415000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Villa Lisa' ,`StreetNumber` = '23902' ,`StreetSuffix` = 'Drive' ,`City` = 'Richmond' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '2417' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'REDUCED! Former model home with over 60K in Builder upgrades which include Kitchen Aide 5-burner gas stove, 2 pantries, upgraded granite kitchen counters, 42 inch solid wood glazed cabinets, over-sized driveway located on cue-de-sac lot. Home has an optional bedroom/office with French Doors and a closet located on the first floor. Game room and 3 additional bedrooms located upstairs. 2 full baths upstairs with granite and upgraded tile and cabinet colors! This home boasts natural light throughout, beautiful granite and tile floors as well as light colored paint and cabinetry. Picky buyers will LOVE. Energy efficient home with double paned windows, Tech Shield attic and less than 5 years young! Zoned to Exemplary school! Neighborhood has 2 pools, club house and work out facility, endless bike trails surrounding beautiful fountain lined ponds. Less than .5 miles from the Wetspark toll road and 99.' ,`Acres` = '0.1859' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LAKES OF BELLA TERRA SEC 37 REPLAT NO 1, BLOCK 2, LOT 20' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '8096' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'HUBENAK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakes Of Bella Terra' ,`TaxAmount` = '8558' ,`TaxRate` = '3.0848' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668418297' WHERE `Matrix_Unique_ID` = '213696242' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-12T21:40:24.360' ,`MLSNumber` = '47490480' ,`ListAgentFullName` = 'Mowanuola Apapa Isitor' ,`ListOfficeName` = 'The Wellspring Life Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.692342' ,`Longitude` = '-95.754265' ,`PhotoCount` = '20' ,`PostalCode` = '77407' ,`RoomCount` = '10' ,`ListPrice` = '362000.00' ,`Status` = 'Active' ,`StreetName` = 'Crainfeld' ,`StreetNumber` = '21603' ,`StreetSuffix` = 'Drive' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2353' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A beautiful 4 bedroom, 2 and a half bath, 2 story Home located in the Lost Creek subdivision in Richmond, TX. This home has an elegant entry way that leads to a spacious Formal Dinning and Family Room. Home comes with an Open Kitchen, Breakfast Bar, Breakfast Nook, Granite Countertops, 42\'\' cabinets and wooden floors on the first floor. Family Room leads to covered rear patio. Master Suite features bay windows, separate tub and shower, and dual sinks. Large Gameroom and Study Nook upstairs. Schedule your tour today!' ,`Acres` = '0.1377' ,`Area` = '37' ,`BuilderName` = 'Taylor Morrison' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Seller may be subject to foreign tax and Buyer withholding per IRS,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOST CREEK SEC 5, BLOCK 2, LOT 6' ,`LotDesciption` = 'Other' ,`LotSize` = '6000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '726' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'ADOLPHUS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FOSTER HIGH SCHOOL' ,`SchoolMiddle` = 'WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lost Creek' ,`TaxAmount` = '6583' ,`TaxRate` = '2.7615' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668418297' WHERE `Matrix_Unique_ID` = '213990167' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-12T21:57:47.953' ,`MLSNumber` = '56615362' ,`ListAgentFullName` = 'Travis Nichols' ,`ListOfficeName` = 'Keller Williams Realty - Memorial' ,`SellingAgentFullName` = 'Sari Quinlan' ,`SellingOfficeName` = 'HomeSmart' ,`Latitude` = '30.309922' ,`Longitude` = '-95.593483' ,`PhotoCount` = '34' ,`PostalCode` = '77316' ,`RoomCount` = '12' ,`ListPrice` = '899000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Lyndsey' ,`StreetNumber` = '119' ,`StreetSuffix` = 'Drive' ,`City` = 'Montgomery' ,`BathsFull` = '3' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '3579' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous home in a private setting surrounded on three sides by tree lines, colorful azaleas & manicured land. A warm covered patio & glass pane entry doors welcome you to comfortable elegance. Design features include 4-inch plantation shutters, transom windows, elegant custom wood cabinetry & built-ins w/ many architectural details, multiple tray & double tray ceilings w/ extensive crown molding & engineered wood floors on much of the 1st floor. Private study off the entry. Open concept island kitchen, living & dining overlook a relaxing pool, patio & serene grounds. The primary suite includes a separate flex room & overlooks the pool through a wall of windows. Generous primary bath w/jetted tub, large double side shower & walk in closet. Lives like a 1 story w/ 3 bedrooms down. A private well provides the irrigation needed to keep the property green & lush. Leave the park-like setting behind the pool or use the additional acreage for your horse. A wonderful place to call home!' ,`Acres` = '2.372' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'MONTGOMERY TRACE 05, BLOCK 3, LOT 22' ,`LotDesciption` = 'Corner,Wooded' ,`LotSize` = '103324' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'STEWART ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Montgomery Trace 05' ,`TaxAmount` = '11073' ,`TaxRate` = '1.8488' ,`WaterSewer` = 'Aerobic,Public Water,Septic Tank,Well' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668418298' WHERE `Matrix_Unique_ID` = '214059127' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-12T22:02:49.040' ,`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 6.5 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`='1668418298' WHERE `Matrix_Unique_ID` = '214209738' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-12T22:58:32.227' ,`MLSNumber` = '30656857' ,`ListAgentFullName` = 'Jordan Schilleci' ,`ListOfficeName` = 'Jo & Co. Realty Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.362990' ,`Longitude` = '-95.389599' ,`PhotoCount` = '29' ,`PostalCode` = '77303' ,`RoomCount` = '11' ,`ListPrice` = '464525.00' ,`Status` = 'Active' ,`StreetName` = 'Hazel Lake' ,`StreetNumber` = '6154' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2588' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'You have just found your dream home. This two-story, 4 bedroom, 3 bathroom home backs up to a 20-acre lake reserve with breathtaking views in the new community of Deer Trails Estates. Alta Homes built this new construction home with designer upgrades which include granite countertops, beautiful tile backsplash, luxury vinyl floor planking, and shaker-style kitchen cabinets. On the first floor of this home, you will find the primary bedroom with an ensuite bathroom, a study (or first-floor flex space), a large open family and dining space, an oversized kitchen, and a wood-burning fireplace. 2nd floor: 3 bedrooms + bathroom, a huge loft/game room. This luxurious home has plenty of space to grow and will be ready to move in soon! The builder is offering $14,500 for you to use how you like. LOW TAXES! Call or stop by today!' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = 'Alta Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Conroe Northeast' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 10 Blk 1' ,`LotDesciption` = 'Greenbelt,Subdivision Lot,Wooded' ,`LotSize` = '16500' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '480' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'PATTERSON ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Deer Trail Estates' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668418298' WHERE `Matrix_Unique_ID` = '214237043' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-12T22:16:09.720' ,`MLSNumber` = '71687686' ,`ListAgentFullName` = 'Ashley Burton-Smith' ,`ListOfficeName` = 'Keller Williams Realty - Memorial' ,`SellingAgentFullName` = 'Tamara Ledyard' ,`SellingOfficeName` = 'BHGRE Gary Greene' ,`Latitude` = '29.760715' ,`Longitude` = '-95.796667' ,`PhotoCount` = '42' ,`PostalCode` = '77494' ,`RoomCount` = '10' ,`ListPrice` = '469900.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Blue Water Bay' ,`StreetNumber` = '2406' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2945' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Amazing home in the sought after Falcon Point Subdivision on a huge lot with pool and no back neighbors. This stunning home offers it all: tall ceilings, natural light, open floorplan, no carpet, spacious rooms, tons of storage and the cherry on top, breathtaking backyard space with screened-in porch, patio, glistening pool and spa, plenty of grass space, all backing up to greenspace for a private oasis. Sellers are leaving pool gates that can easily be installed for child/pet safety, and home includes water softener/filtration system. Conveniently located close to shopping and highway access for easy commuting. Book your tour today!' ,`Acres` = '0.2554' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'FALCON POINT SEC 6, BLOCK 1, LOT 23' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot,Wooded' ,`LotSize` = '11126' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '635' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'RYLANDER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'WOODCREEK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Falcon Point Sec 6' ,`TaxAmount` = '8085' ,`TaxRate` = '2.4445' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668418298' WHERE `Matrix_Unique_ID` = '214266323' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-12T22:45:11.783' ,`MLSNumber` = '10328865' ,`ListAgentFullName` = 'Jason Whittington' ,`ListOfficeName` = 'SanDoray Real Estate LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.156450' ,`Longitude` = '-95.439699' ,`PhotoCount` = '17' ,`PostalCode` = '77515' ,`RoomCount` = '4' ,`ListPrice` = '169900.00' ,`Status` = 'Active' ,`StreetName` = 'Bryan' ,`StreetNumber` = '617' ,`StreetSuffix` = 'Street' ,`City` = 'Angleton' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1084' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This cute little 3/1/1 home is perfect for a first-time home buyer. Hidden away in the Southwest side of traditional Angleton, and 15 minutes round trip to almost everything, you will find a great spot to start your family! Enjoy quiet days and nights in a thriving community outside of the big city hustle and bustle. Don\'t forget to bring the dogs to enjoy the big back yard. Schedule a showing today!' ,`Acres` = '0.1653' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Angleton' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ERIC WEST (ANGLETON) BLK 1 LOT 17' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '5 - Angleton' ,`SchoolElementary` = 'WESTSIDE ELEMENTARY SCHOOL (ANGLETON)' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Eric West Angleton' ,`TaxAmount` = '3648' ,`TaxRate` = '2.6102' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668418298' WHERE `Matrix_Unique_ID` = '214293284' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-12T21:59:57.523' ,`MLSNumber` = '17128083' ,`ListAgentFullName` = 'Vicki Lacy' ,`ListOfficeName` = 'Premier Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.022434' ,`Longitude` = '-95.100201' ,`PhotoCount` = '15' ,`PostalCode` = '77336' ,`RoomCount` = '8' ,`ListPrice` = '235000.00' ,`Status` = 'Active' ,`StreetName` = 'Corydon' ,`StreetNumber` = '1007' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1678' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Lovely 3 bedroom 2 bath home on oversized corner lot. Beautifully updated kitchen with granite counter tops, subway tile backsplash, and stainless steel appliances. Laminate flooring in kitchen, dining, formal dining ,and den/flex space. Bathrooms have been nicely updated. Large backyard with covered patio. The side garage and driveway allows for lots of parking space. Subdivision features lake access. Low tax rate and low HOA dues. Above ground pool and outdoor play equipment stays or can be removed. There are great programs available for this home' ,`Acres` = '0.2548' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Huffman Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 652 BLK 31 LAKEWOOD HEIGHTS SEC 3 R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11100' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '168' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '28 - Huffman' ,`SchoolElementary` = 'HUFFMAN ELEMENTARY SCHOOL (HUFFMAN)' ,`SchoolHigh` = 'HARGRAVE HIGH SCHOOL' ,`SchoolMiddle` = 'HUFFMAN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakewood Heights' ,`TaxAmount` = '4217' ,`TaxRate` = '2.4592' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1967' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668418299' WHERE `Matrix_Unique_ID` = '214341690' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-12T21:36:17.140' ,`MLSNumber` = '33788167' ,`ListAgentFullName` = 'Paul Compton' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = 'Jennifer Hawes' ,`SellingOfficeName` = 'Coldwell Banker Realty' ,`Latitude` = '29.925972' ,`Longitude` = '-95.173417' ,`PhotoCount` = '34' ,`PostalCode` = '77044' ,`RoomCount` = '9' ,`ListPrice` = '319900.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Brighton Park' ,`StreetNumber` = '13815' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2138' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Conveniently located just minutes from the Beltway and downtown Houston, yet located in a quiet subdivision, this updated home is exactly what you have been looking for! This home has everything you would expect from the welcoming front porch with sitting area to high ceilings, open-concept floor plan, luxury vinyl plank flooring, gas log fireplace, and modern light fixtures. The recently updated kitchen includes new quartz counters, new backsplash, large kitchen island, and stainless appliances. In the spacious primary suite, you will find double sinks with vanity area, frameless glass shower, soaker tub, and large walk-in closet. And in addition to the 3 spacious bedrooms there is also a dedicated office with French doors for privacy. The exterior features a large, covered patio and accommodating backyard - the perfect place to relax and grill. Only a short walk to the nearby elementary school, no flooding ever, AND brand new AC this incredible opportunity is now ready for you!' ,`Acres` = '0.1769' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Summerwood/Lakeshore' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 24 BLK 2 SUMMERWOOD SEC 11' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '7704' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '925' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'SUMMERWOOD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'WOODCREEK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Summerwood' ,`TaxAmount` = '6180' ,`TaxRate` = '2.733' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668418299' WHERE `Matrix_Unique_ID` = '214392840' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-12T22:25:51.647' ,`MLSNumber` = '44655894' ,`ListAgentFullName` = 'Stacey Calderon' ,`ListOfficeName` = 'Red Door Realty & Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.036499' ,`Longitude` = '-95.228559' ,`PhotoCount` = '26' ,`PostalCode` = '77339' ,`RoomCount` = '8' ,`ListPrice` = '430000.00' ,`Status` = 'Active' ,`StreetName` = 'Walnut' ,`StreetNumber` = '1717' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2059' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WOW, ABSOLUTE MUST SEE!!! ONE STORY HOME NESTLED ON LARGE CORNER LOT ESTABLISHED NEIGHBORHOOD IN THE FRONT OF KINGWOOD WITH EASY ACCESS TO 59 NORTH AND KINGWOOD DRIVE. THIS HOME SITS ON OVER AN ACRE WITH A POOL, DETACHED 3 CAR GARAGE WITH 3 CAR-CARPORT AND LOTS OF SPACE FOR PARKING, STORAGE BUILDING. ALL THIS AND LOCATED APROXIMATELY 30 MINUTES FROM DOWNTOWN HOUSTON. THIS HOME IS A MUST SEE, DON\'T DELAY CALL TODAY!' ,`Acres` = '1.0191' ,`Area` = '32' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate,Probate' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Kingwood West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 9 BLK 33 FOREST COVE SEC 5 U/R' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '44390' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '160' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'FOSTER ELEMENTARY SCHOOL (HUMBLE)' ,`SchoolHigh` = 'KINGWOOD PARK HIGH SCHOOL' ,`SchoolMiddle` = 'KINGWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Forest Cove Sec 05 U/R' ,`TaxAmount` = '6709' ,`TaxRate` = '2.5839' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1971' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668418299' WHERE `Matrix_Unique_ID` = '214398132' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-12T21:41:04.310' ,`MLSNumber` = '12027115' ,`ListAgentFullName` = 'Emil Ramirez' ,`ListOfficeName` = 'RE/MAX Signature Galleria' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.628416' ,`Longitude` = '-96.105867' ,`PhotoCount` = '48' ,`PostalCode` = '77485' ,`RoomCount` = '3' ,`ListPrice` = '330000.00' ,`Status` = 'Active' ,`StreetName` = 'Fm 1093' ,`StreetNumber` = '2367' ,`StreetSuffix` = 'Road' ,`City` = 'Wallis' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1808' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful renovated 3 BR home on 2.5 acres in Wallis. The home has all new roof, new HVAC, new PEX plumbing, quartz counters, updated tile bathrooms, new cabinets throughout, stainless appliances, and fresh paint throughout! The home has a 2 car garage plus 2 car carport. This home is a must see!' ,`Acres` = '2.5' ,`Area` = '57' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'A093 J STEVENS' ,`LotDesciption` = 'Other' ,`LotSize` = '75402' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '54 - Brazos' ,`SchoolElementary` = 'BRAZOS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRAZOS HIGH SCHOOL' ,`SchoolMiddle` = 'BRAZOS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Wallis' ,`TaxAmount` = '3702' ,`TaxRate` = '1.8402' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1913' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668418299' WHERE `Matrix_Unique_ID` = '214425455' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-12T21:27:07.460' ,`MLSNumber` = '79611487' ,`ListAgentFullName` = 'Linh Nguyen' ,`ListOfficeName` = '5th Stream Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.657149' ,`Longitude` = '-95.633414' ,`PhotoCount` = '28' ,`PostalCode` = '77498' ,`RoomCount` = '7' ,`ListPrice` = '235000.00' ,`Status` = 'Active' ,`StreetName` = 'Clear Forest' ,`StreetNumber` = '13923' ,`StreetSuffix` = 'Drive' ,`City` = 'Sugar Land' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1274' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This 3bedroom/2 bathroom is a MUST SEE and a small extra room for a library. It\'s beautifully maintained and conveniently located with easy access to fine dining restaurants and shopping at First Colony Mall, Home Depot, and Kroger. The home is in a quiet neighborhood, new range/stove and a new wash Disher (will replace on Nov 16). Pretty laminate flooring, The big living room allows natural light to shine through. LOW TAXES, LOW HOA. Minutes to significant freeways, Fwy 69, Westpark, and 90 make it easy to get to work. SALE AS IS NO REPAIR.' ,`Acres` = '0.1263' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'TOWNEWEST SEC 6, BLOCK 3, LOT 2' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '5500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '360' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'SUGAR MILL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KEMPNER HIGH SCHOOL' ,`SchoolMiddle` = 'SUGAR LAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front,No Supra Keybox,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Colonial,Other Style' ,`Subdivision` = 'Townewest Sec 6' ,`TaxAmount` = '3513' ,`TaxRate` = '2.3329' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668418300' WHERE `Matrix_Unique_ID` = '214467309' --> 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','214678222','1668418300','214678222','2022-11-12T22:47:17.890','86880575','Estella Alas','Realty Associates','','','30.225394','-95.441741','42','77385','10','450000.00','Active','Ginger Springs','18','Place','The Woodlands','2','1','4','2806','Single-Family','GORGEOUS 1-Story with Lots of Privacy Backing to a Reserve! 4 Bedrooms, 2 Full Baths & 1 Half Bath. Formal Dining. French Doors. Engineered Wood Floors Through-Out Entry, Dining,Kitchen, Breakfast Rm & Living area. Island Kitchen, Quartz Counters, Stainless Appliances. Large Master with Sitting Area and Master Bath with Whirlpool Tub + Separate Shower. Large Media Room hard to find in 1 Story Homes. High Ceilings, Kitchen open to Living Room. Roof 4 Years old. Fresh Paint. Covered Back Patio...Backs to a Reserve! The Woodlands Village of Harper\'s Landing is one of the most conveniently located villages in The Woodlands with just minutes to just about everything you need. Quick access to highway, grocery stores, hospitals, The Woodlands Mall, Cynthia Woods Mitchell Pavilion, Market Street. Harper\'s Landing offers gorgeous walking trails, Tennis, Village Pool, Basketball, Soccer, Skating and even a pet park. A Must See!','0.1954','15','','','Electric Dryer Connections,Gas Dryer Connections','','Mud,Sellers Disclosure','1','Gaslog Fireplace','1','The Woodlands','Central Electric','0','WDLNDS HARPER\'S LND COLLEGE PK 14, BLOCK 1, LOT 21','Cleared,Cul-De-Sac,Greenbelt,Subdivision Lot,Wooded','8510','Appraisal District','','','0','','2','Electric Oven','0','','','Electric Cooktop','','Composition','11 - Conroe','POWELL ELEMENTARY SCHOOL (CONROE)','THE WOODLANDS COLLEGE PARK HIGH SCHOOL','KNOX JUNIOR HIGH SCHOOL','Lockbox Front,Supra Keybox','Appraisal District','1','Contemporary/Modern','Wdlnds Harpers Lnd College Park','7295','2.2719','Water District','2003','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-12T22:48:08.497' ,`MLSNumber` = '56450829' ,`ListAgentFullName` = 'Vanessa Hyman' ,`ListOfficeName` = 'NB Elite Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.613641' ,`Longitude` = '-95.745241' ,`PhotoCount` = '2' ,`PostalCode` = '77406' ,`RoomCount` = '5' ,`ListPrice` = '379000.00' ,`Status` = 'Active' ,`StreetName` = 'Allegro Dr' ,`StreetNumber` = '2402' ,`StreetSuffix` = '' ,`City` = 'Richmond' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'CUL-DE-SAC \r\n5 Bedroom , Home Office, Game room , Bright natural light , ready for a little rehab !' ,`Acres` = '' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'RIO VISTA SEC 1, BLOCK 1, LOT 19' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '475' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'AUSTIN ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'LAMAR CONSOLIDATED HIGH SCHOOL' ,`SchoolMiddle` = 'WESSENDORF/LAMAR JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = '' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Rio Vista' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668418300' WHERE `Matrix_Unique_ID` = '214684912' --> 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','214698752','1668418300','214698752','2022-11-12T21:21:50.663','61573435','Alex Anthony','Allstar Properties','','','30.329680','-95.613297','36','77316','6','269900.00','Active','Highline','6177','Drive','Montgomery','2','0','3','1200','Single-Family','Cute one-story wood frame home on almost an acre of land located on the fringes of Lake Bonanza and adjacent to the subdivision airstrip. The home is cozy and features a split floor plan with recent touch ups including interior/exterior paint and deck staining. Kitchen features granite countertops & gas range. Floors are wood laminate throughout the home. All rooms have ceiling fans & all windows are vinyl. The 20\'x50\' metal building is wired for power and is built on a concrete slab & serves as a garage plus shop area. There are also two smaller buildings on the property for additional storage needs. The parking pad is 40\'x20\' with a 30 amp plug for an RV. Come see what this home has to offer. Montgomery ISD, NO HOA Fees (Joining is optional to enjoy subdivision amenities), No MUD, Low Taxes. Located near Lake Conroe.','0.98','39','','','Electric Dryer Connections,Washer Connections','','Home Protection Plan,Sellers Disclosure','0','','','Lake Conroe Area','Central Gas','0','LAKE BONANZA U/R SOUTH, TR 9, ACRES 0.98','Airpark,In Golf Course Community,Subdivision Lot,Wooded','42689','Appraisal District','','','0','','4','Gas Oven','0','','','Gas Range','','Composition','37 - Montgomery','LONE STAR ELEMENTARY SCHOOL (MONTGOMERY)','LAKE CREEK HIGH SCHOOL','OAK HILL JUNIOR HIGH SCHOOL','Supra Keybox','Appraisal District','1','Traditional','Lake Bonanza 04','2806','1.825','Other Water/Sewer,Public Water,Septic Tank','1987','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','214699496','1668418300','214699496','2022-11-12T21:18:07.933','28946858','Jana Riley','Keller Williams SoutheastTexas','','','30.038473','-93.855212','29','77611','7','212000.00','Active','Bernice','1190','Lane','Bridge City','2','0','2','1650','Single-Family','Spacious 2 Bedroom 2 Bathroom Brick Home with 2 Living Areas, Arched Entries and Ceramic Tile Flooring throughout. Enter through the Leaded-Glass Front Door to the Living Room with recessed lights and ceiling fan. The Kitchen features Granite Countertops with Tile Backsplash, Real Wood Cabinets, Island, Gas Stove, Microwave, and Dishwasher. The Large Den includes recessed lights and ceiling fan. The Master Bedroom En Suite features 3 Closets and a Master Bathroom with Granite Countertop Vanity and a Tub/Shower Combo. The Main Bathroom includes a Double Sink Vanity with a Tub/Shower Combo. The 2nd Bedroom also includes 2 Closets. Double Doors from the Den leads to the Sunroom with Tile Flooring. There is also a good sized fenced-in backyard. Make your appointment to see today!','0.194','50','','','','','Estate','1','','','','Central Gas','0','LOT 10 BLK 6 SCHOFIELD PLACE','Cleared','8451','Appraisal District','','','0','','1','Freestanding Oven,Gas Oven','0','','','Freestanding Range,Gas Range','','Composition','367 - Bridge City','BRIDGE CITY ELEMENTARY SCHOOL','BRIDGE CITY HIGH SCHOOL','BRIDGE CITY MIDDLE SCHOOL','Appointment Required','Appraisal District','1','Ranch','Schofield Place','3574','2.3117','Public Sewer,Public Water','1966','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','214700094','1668418300','214700094','2022-11-12T21:49:21.547','16773917','Lance Johnson','CENTURY 21 Western Realty','','','29.876391','-95.725950','0','77449','7','235000.00','Active','Baron Bend Lane','20519','Lane','Katy','2','0','3','1439','Single-Family','This is an Anglia Home built with a nice traditional floor plan. This property comes with a three bedroom and two full bathrooms. The floors are an upgrade of Mohawk floors. The home was freshly painted and have a range and built microwave under one year old. This is the perfect home for a first-time home buyer or investor.','0.1023','25','Anglia Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Corporate Listing','1','','','Bear Creek South','Central Electric,Central Gas','1','LT 3 BLK 1 HIGHLAND CREEK RANCH SEC 5','Subdivision Lot','4458','Appraisal District','','450','0','','2','Gas Oven','0','','','Gas Cooktop','','Composition','13 - Cypress-Fairbanks','WALKER ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)','CYPRESS PARK HIGH SCHOOL','ROWE MIDDLE SCHOOL','Supra Keybox,Vacant/Unoccupied','Appraisal District','1','Traditional','Highland Crk Ranch Sec 05','4764','2.69','Public Sewer,Public Water','2010','Appraisal District'); --> New record created successfully