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-08-13T01:22:00.700' ,`MLSNumber` = '84721771' ,`ListAgentFullName` = 'Lyle Jackson' ,`ListOfficeName` = 'LJ Group Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.974191' ,`Longitude` = '-95.980220' ,`PhotoCount` = '37' ,`PostalCode` = '77414' ,`RoomCount` = '4' ,`ListPrice` = '249999.00' ,`Status` = 'Active' ,`StreetName` = 'Le Tulle' ,`StreetNumber` = '2901' ,`StreetSuffix` = 'Avenue' ,`City` = 'Bay City' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1770' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New Construction in Bay City!... Come out and view this 4 bedroom 2.5 bath home on a corner lot, that is walking distance to an elementary school. No carpet on the 1st floor; artistic color schemes that will match your new décor. Homes comes with a certified energy package that will save you monthly! Builder provides a 1-2-10 year new homes warranty. Call today to enquire about the builder package. Realtors see agent remarks!' ,`Acres` = '0.172' ,`Area` = '54' ,`BuilderName` = 'Censeo Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'Park Addition' ,`LotDesciption` = 'Cleared' ,`LotSize` = '7492' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition,Other' ,`SchoolDistrict` = '132 - Bay City' ,`SchoolElementary` = '' ,`SchoolHigh` = 'BAY CITY HIGH SCHOOL' ,`SchoolMiddle` = 'BAY CITY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Park Addition' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663697815' WHERE `Matrix_Unique_ID` = '208364525' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-13T01:22:00.700' ,`MLSNumber` = '74547770' ,`ListAgentFullName` = 'George Snyder' ,`ListOfficeName` = 'Southern Star Properties, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.250067' ,`Longitude` = '-95.538168' ,`PhotoCount` = '41' ,`PostalCode` = '77384' ,`RoomCount` = '11' ,`ListPrice` = '1200000.00' ,`Status` = 'Active' ,`StreetName` = 'Wind River' ,`StreetNumber` = '15' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3892' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful custom home nestled on 1.82 acres in Lake Creek Forest zoned to The Woodlands Schools*LOW TAX RATE*NO MUD TAXES* dramatic staircase, chandeliers, hardwood floors, new carpet. This stunning home has 4 bedrooms and 3-1/2 baths along with an additional storage room w/ laundry chute from upstairs. Kitchen features a 6 burner JennAir stove and double oven. Plantation shutters, double tray ceiling, his/hers closet with built in island, jetted tub, frameless shower with dual shower heads/double vanity, 2 tankless water heaters, ring door bell, and window treatments included. Large walk-in closets throughout home. Three bedrooms are located on 1st floor. Oversized laundry room with sink and cabinets, 8” baseboards, crown molding, covered patio, built in grill, mosquito spray system. Heated pool w/sun shelf and hot tub. Oversized workshop that sits on the back of property for RV/Boats or massive man cave! This is a rare find and will not last long!!' ,`Acres` = '1.82' ,`Area` = '15' ,`BuilderName` = 'Partners In Building' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S661300 - LAKE CREEK FOREST 01, BLOCK 3, LOT 50, 51, ACRES 1' ,`LotDesciption` = 'Cleared,Cul-De-Sac' ,`LotSize` = '79279' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '264' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Grill' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'BUSH ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'THE WOODLANDS HIGH SCHOOL' ,`SchoolMiddle` = 'MCCULLOUGH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lake Creek Forest 01' ,`TaxAmount` = '13457' ,`TaxRate` = '1.8488' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663697815' WHERE `Matrix_Unique_ID` = '208667206' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-13T01:22:00.700' ,`MLSNumber` = '30300942' ,`ListAgentFullName` = 'Flor Velasquez' ,`ListOfficeName` = 'Lions Gate Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.259421' ,`Longitude` = '-94.187178' ,`PhotoCount` = '43' ,`PostalCode` = '77657' ,`RoomCount` = '4' ,`ListPrice` = '335000.00' ,`Status` = 'Active' ,`StreetName` = 'Trahan' ,`StreetNumber` = '165' ,`StreetSuffix` = 'Road' ,`City` = 'Lumberton' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1972' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '***Beautiful brick home in Lumberton***\r\nThis home sits on 3.8622 acres of land with mature trees which offers a country and privacy. Hardin County tax records says 4 acres, to be confirmed by survey. \n Inside you will find a beautiful and spacious kitchen, granite countertops, a huge master bedroom, a beautiful living room with a fire place. The hallways include additional closets. Backyard has a covered warehouse, a metal RV carport, and a chicken coop. DO NOT miss the opportunity to own a peace of Lumberton !!\r\nSchedule a showing today!!\r\nThis home will not last.' ,`Acres` = '4.06' ,`Area` = '49' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'AB 53 S K VANMETER P# 53-110-A I# 2017-80693 12/13/2017' ,`LotDesciption` = 'Other' ,`LotSize` = '176854' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '154 - Lumberton' ,`SchoolElementary` = 'LUMBERTON PRIMARY SCHOOL' ,`SchoolHigh` = 'LUMBERTON HIGH SCHOOL' ,`SchoolMiddle` = 'LUMBERTON MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'VANMETER' ,`TaxAmount` = '4074' ,`TaxRate` = '1.8866' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1974' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663697815' WHERE `Matrix_Unique_ID` = '208786773' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-13T01:22:00.700' ,`MLSNumber` = '40255909' ,`ListAgentFullName` = 'Sandra Smith' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.683274' ,`Longitude` = '-95.426327' ,`PhotoCount` = '25' ,`PostalCode` = '77025' ,`RoomCount` = '11' ,`ListPrice` = '455000.00' ,`Status` = 'Active' ,`StreetName` = 'Mitchell Landing' ,`StreetNumber` = '3109' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2344' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Please submit all offers. Premium corner lot located inside 610 loop in the highly desirable gated community of Buffalo Manor! Beautiful energy efficient David Weekley home! Modern concept home. First floor has a room with a private bathroom. French doors in this room opens to a patio. Second floor has a beautiful open concept that features a patio, dining area, kitchen, half bath, & a family room. The kitchen has attractive granite countertops. Third floor has a master suite with an oversized shower & another bedroom with a private bathroom. The side & back yards are delightful. Throughout this family home are high-end features & fixtures with tasteful flooring & stunning painted walls that help family & friends feel like there is no place like this home. This is the perfect home for family and friends to gather for fun & entertainment to create memories. The refrigerator, washer & dryer will remain. Inside home recently painted. Minutes from the Medical Center, NRG, & Galleria.' ,`Acres` = '' ,`Area` = '17' ,`BuilderName` = 'David Weekley Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Knollwood/Woodside Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 6 BLK 3 BUFFALO MANOR' ,`LotDesciption` = 'Corner' ,`LotSize` = '1878' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '3185' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LONGFELLOW ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'BELLAIRE HIGH SCHOOL' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Buffalo Manor' ,`TaxAmount` = '9840' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663697816' WHERE `Matrix_Unique_ID` = '208893977' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-13T01:22:00.700' ,`MLSNumber` = '26483953' ,`ListAgentFullName` = 'Troy Brock' ,`ListOfficeName` = 'NextHome Realty Center' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.060842' ,`Longitude` = '-95.725416' ,`PhotoCount` = '28' ,`PostalCode` = '77377' ,`RoomCount` = '5' ,`ListPrice` = '425000.00' ,`Status` = 'Active' ,`StreetName` = 'Noble Arabian' ,`StreetNumber` = '20319' ,`StreetSuffix` = 'Drive' ,`City` = 'Tomball' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2614' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Don\'t miss out on this incredible Beazer home located in Tomball\'s coveted community of Amira. Wood like tile greets you as you enter the front door and flows throughout the bottom floor of this two-story home. Work from home or enjoy the kid\'s playroom in the study/flex room. Granite countertops, stainless-steel appliances, and a gas cooktop make the kitchen a chef\'s paradise while the huge island adds extra seating and is perfect for entertaining. The downstairs primary bedroom flows into the large primary bathroom with walk-in closet. Upstairs you will find a game room along with two secondary bedrooms and a full bathroom. Enjoy your morning coffee or afternoon beverage in your own private backyard oasis. The community of Amira offers a resort-style pool, fitness center, beautiful lakes, and many other amenities for the whole family. Conveniently located close to shopping, restaurants, and entertainment in Tomball, Cypress, and The Woodlands. Make this your new home now!' ,`Acres` = '0.155' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Tomball Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 18 BLK 3 AMIRA SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6752' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '975' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'GRAND OAKS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'GRAND LAKES JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Amira' ,`TaxAmount` = '10872' ,`TaxRate` = '3.4925' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663697816' WHERE `Matrix_Unique_ID` = '208979578' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-13T01:22:00.700' ,`MLSNumber` = '75521601' ,`ListAgentFullName` = 'Roberto Garza' ,`ListOfficeName` = 'Keller Williams HoustonCentral' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.610339' ,`Longitude` = '-95.247691' ,`PhotoCount` = '9' ,`PostalCode` = '77075' ,`RoomCount` = '3' ,`ListPrice` = '235000.00' ,`Status` = 'Active' ,`StreetName` = 'Misty Bridge' ,`StreetNumber` = '9431' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1456' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this wonderful 3 bed 2 bath home! This home has been well maintained and been freshly painted and ready for it’s new buyer! Walk inside where you will be flooded with lots of natural light, ceiling fans in the rooms keep you nice and cool from the scorching hot Texas summers. Located off of beltway 8 this allows you to get to major locations quickly. Close to good schools and grocery stores. Call today for a private showing!' ,`Acres` = '0.1515' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Southbelt/Ellington' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 30 BLK 1 SOUTHBRIDGE SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'ATKINSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DOBIE HIGH SCHOOL' ,`SchoolMiddle` = 'BEVERLYHILLS INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Southbridge Sec 01' ,`TaxAmount` = '4597' ,`TaxRate` = '2.6863' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1981' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663697816' WHERE `Matrix_Unique_ID` = '209252876' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-13T01:22:00.700' ,`MLSNumber` = '77972297' ,`ListAgentFullName` = 'Tammi Freund' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.613927' ,`Longitude` = '-95.566664' ,`PhotoCount` = '28' ,`PostalCode` = '77477' ,`RoomCount` = '11' ,`ListPrice` = '600000.00' ,`Status` = 'Active' ,`StreetName` = 'Whitney Oaks' ,`StreetNumber` = '407' ,`StreetSuffix` = 'Lane' ,`City` = 'Stafford' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3646' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to this gorgeous Westin Home in Estates at Promenade!*home features elegant entry way with formal dining & living room that has double crown molding ,column entry, extended height baseboards*Wrought iron stair rails *Grand sized family room with high ceilings & wall of windows to let in the natural lighting* Open floor plan great for entertaining * Spacious island kitchen sure to please the chef in the family with and abundance of cabinets & granite countertops*Large master suite w/recessed ceiling & elegant en suite bath with seperate shower w/bench seat & corner tub * Game room up with recessed ceiling large enough for a pool table* Oversized rear patio and oversized back yard that offers Lemon,Apple,Plum,Orange,Guava,Pomegranate,& Banana fruit trees as well as Grape & Sugar Cane * Dont miss your opportunity to see this one call today to schedule your private showing!' ,`Acres` = '0.321' ,`Area` = '29' ,`BuilderName` = 'westin' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Stafford Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'ESTATES AT PROMENADE SEC 1, BLOCK 2, LOT 21' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '13981' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '596' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '50 - Stafford' ,`SchoolElementary` = 'STAFFORD ELEMENTARY SCHOOL (STAFFORD MSD)' ,`SchoolHigh` = 'STAFFORD HIGH SCHOOL' ,`SchoolMiddle` = 'STAFFORD INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Estates At Promenade Sec 1' ,`TaxAmount` = '8430' ,`TaxRate` = '1.9342' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663697816' WHERE `Matrix_Unique_ID` = '209860519' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-13T01:22:00.700' ,`MLSNumber` = '26121050' ,`ListAgentFullName` = 'Jarad Mollon' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.851383' ,`Longitude` = '-95.817590' ,`PhotoCount` = '22' ,`PostalCode` = '77493' ,`RoomCount` = '7' ,`ListPrice` = '389900.00' ,`Status` = 'Active' ,`StreetName` = 'Marisol cove dr' ,`StreetNumber` = '5310' ,`StreetSuffix` = '' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2850' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'It\'s on a lake! Built in December 2021, this Beazer home is one you don\'t want to miss! The rod-iron fence provides a nice view from the back covered patio. Passing the porch and landscaped maintained by a sprinkler system, you will enter the home on 12\" wood tile floors that leads into the kitchen with quartz countertops which opens to high ceilings in the family room. A newer home with oversized rooms and a mother in law suite. Walk-in pantry, walk-in laundry and more! Come check it out, before its too late!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Beazer' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 19 BLK 1 MARISOL SEC 2' ,`LotDesciption` = 'Waterfront' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'MCELWAIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Marisol' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663697816' WHERE `Matrix_Unique_ID` = '209985174' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-13T01:22:00.700' ,`MLSNumber` = '40464525' ,`ListAgentFullName` = 'Jessica Abelow' ,`ListOfficeName` = 'Berkshire Hathaway HomeServices Premier Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.456379' ,`Longitude` = '-95.474033' ,`PhotoCount` = '32' ,`PostalCode` = '77583' ,`RoomCount` = '4' ,`ListPrice` = '380000.00' ,`Status` = 'Active' ,`StreetName` = 'Sawmill Ridge' ,`StreetNumber` = '114' ,`StreetSuffix` = 'Road' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2874' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home! This nearly new build is the one you have been looking for. Enter through the grand foyer to the formal office space. Proceed through to the formal dining and beautiful kitchen space. The kitchen is open to the first living space. The primary bedroom suite, located on the first floor, is sizable and bath contains separate shower and tub, and generous closet. Continue upstairs to three secondary bedrooms and secondary living space, all considerable in size. You\'ll also find the upstairs media room, ideal for movie nights. The extensive backyard contains a covered patio and plenty of outdoor recreational space. Don\'t let this one slip through your fingers, schedule your showing today.' ,`Acres` = '0.1471' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'HUNTINGTON PLACE SEC 2, BLOCK 1, LOT 14' ,`LotDesciption` = 'Other' ,`LotSize` = '6408' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '585' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'HERITAGE ROSE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Accompany,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Huntington Place Sec 2' ,`TaxAmount` = '8604' ,`TaxRate` = '3.2629' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663697816' WHERE `Matrix_Unique_ID` = '210079913' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-13T01:36:40.733' ,`MLSNumber` = '65698770' ,`ListAgentFullName` = 'Maria Llanas' ,`ListOfficeName` = '4 Rivers Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.145724' ,`Longitude` = '-95.243239' ,`PhotoCount` = '19' ,`PostalCode` = '77357' ,`RoomCount` = '3' ,`ListPrice` = '170000.00' ,`Status` = 'Active' ,`StreetName` = 'Liberty' ,`StreetNumber` = '20819' ,`StreetSuffix` = 'Street' ,`City` = 'New Caney' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1216' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Seller is selling AS-IS and will make no repairs. Please make an appointment before going to the property. \r\nSchedule your appointment through Showing Smart. Large backyard with mature trees. Close to US 59 Freeway and mayor stores in less than 7 minutes away from the Manufacture Home.' ,`Acres` = '0.5817' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Porter/New Caney West' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'S928700 - TRINITY WAY, LOT 52, SERIAL # TXFLR12A21582, LABEL' ,`LotDesciption` = 'Cleared' ,`LotSize` = '25338' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Wood Shingle' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'VALLEY RANCH ELEMENTARY SCHOOL (NEW CANEY)' ,`SchoolHigh` = 'NEW CANEY HIGH SCHOOL' ,`SchoolMiddle` = 'NEW CANEY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Trinity Way' ,`TaxAmount` = '1573' ,`TaxRate` = '2.5981' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1994' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663697816' WHERE `Matrix_Unique_ID` = '210100642' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-13T01:22:00.700' ,`MLSNumber` = '47438612' ,`ListAgentFullName` = 'John Newsom' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.727271' ,`Longitude` = '-95.827706' ,`PhotoCount` = '50' ,`PostalCode` = '77494' ,`RoomCount` = '13' ,`ListPrice` = '575000.00' ,`Status` = 'Active' ,`StreetName` = 'Juniper Forest Fall' ,`StreetNumber` = '26618' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '6' ,`SqFtTotal` = '4151' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Almost new. New kitchen appliances, new carpet, fresh paint inside, new front door, new cabinet fronts. Has that new home smell. Large open area kitchen, breakfast and family room, great for and those that want to entertain. Primary closet is large walk in. Secondary bedroom on first floor with full bath. 4 bedrooms upstairs with a gameroom and media/computer gaming room. Notice on aerial how close the home is to the splash pad. Walking distance' ,`Acres` = '0.1516' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'PINE MILL RANCH SEC 5, BLOCK 1, LOT 15' ,`LotDesciption` = 'Cul-De-Sac,Greenbelt,Subdivision Lot' ,`LotSize` = '6603' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '550' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'KEIKO DAVIDSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMPKINS HIGH SCHOOL' ,`SchoolMiddle` = 'TAYS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'French' ,`Subdivision` = 'Pine Mill Ranch Sec 5' ,`TaxAmount` = '9072' ,`TaxRate` = '2.7845' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2010' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663697816' WHERE `Matrix_Unique_ID` = '210156552' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-13T01:22:00.700' ,`MLSNumber` = '34944704' ,`ListAgentFullName` = 'William Crafts' ,`ListOfficeName` = 'RE/MAX Fine Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.653109' ,`Longitude` = '-95.586883' ,`PhotoCount` = '32' ,`PostalCode` = '77477' ,`RoomCount` = '7' ,`ListPrice` = '359900.00' ,`Status` = 'Active' ,`StreetName` = 'Meadowdale' ,`StreetNumber` = '11926' ,`StreetSuffix` = 'Drive' ,`City` = 'Meadows Place' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2149' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'House was just remodeled with NEW kitchen, bathroom and laundry room cabinets, new flooring, New GRANITE countertops in kitchen and bathrooms. Kitchen was expanded to create more room. Both Showers were redone with new tile, showerheads and valves. New toilets. House has PEX pipes for water. New ceiling fans throughout. New Carpet in bedrooms. New air ducts were installed. New driveway. New fencing. No HOA in this neighborhood and very low taxes. Walk to community pools. Convenient to new elementary in the neighborhood. Bathroom Mirrors will be installed by Friday July 22nd. Microwave over the range will be installed by Friday as well.' ,`Acres` = '0.1685' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Stafford Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'THE MEADOWS SEC 2, BLOCK 14, LOT 26' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7338' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'MEADOWS ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'DULLES HIGH SCHOOL' ,`SchoolMiddle` = 'DULLES MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Mdws' ,`TaxAmount` = '5822' ,`TaxRate` = '2.4949' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1971' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663697817' WHERE `Matrix_Unique_ID` = '210344393' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-13T01:22:00.700' ,`MLSNumber` = '29635060' ,`ListAgentFullName` = 'Alane Savoie' ,`ListOfficeName` = 'Keller Williams Realty - Clear Lake/ NASA' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.327612' ,`Longitude` = '-94.940033' ,`PhotoCount` = '50' ,`PostalCode` = '77563' ,`RoomCount` = '5' ,`ListPrice` = '470000.00' ,`Status` = 'Active' ,`StreetName` = 'Ling' ,`StreetNumber` = '302' ,`StreetSuffix` = 'Street' ,`City` = 'Bayou Vista' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1632' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Wonderful waterfront property located in Bayou Vista! This 3 bedroom 2 bath home sits on one and half lots, features a boat house, large party decks all around, and ample driveway parking. The kitchen has beautiful granite, under cabinet lighting, and new cabinet doors. The bathroom has a marble shower and porcelain floors that were completed in 2022 and has a beautiful clear hickory cabinet built in for all your storage needs. Come enjoy the sunrises and sunsets on the covered back patio and everything else this house has to offer!' ,`Acres` = '0.1463' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Bayou Vista' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 7 PAGE 7 LOT 302 & E 1/2 OF LOT 303 (302-1) NEW BAYOU V' ,`LotDesciption` = 'Waterfront' ,`LotSize` = '6375' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '52 - Texas City' ,`SchoolElementary` = 'HAYLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA MARQUE HIGH SCHOOL (TEXAS CITY)' ,`SchoolMiddle` = 'LA MARQUE MIDDLE SCHOOL (TEXAS CITY)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'New Bayou Vista 3' ,`TaxAmount` = '9507' ,`TaxRate` = '2.635' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1975' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663697817' WHERE `Matrix_Unique_ID` = '210512135' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-13T01:22:00.700' ,`MLSNumber` = '84497078' ,`ListAgentFullName` = 'Yvette Donato' ,`ListOfficeName` = 'Sapphire Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.943306' ,`Longitude` = '-95.208869' ,`PhotoCount` = '39' ,`PostalCode` = '77346' ,`RoomCount` = '12' ,`ListPrice` = '450000.00' ,`Status` = 'Active' ,`StreetName` = 'Ronan Mist' ,`StreetNumber` = '15327' ,`StreetSuffix` = 'Drive' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2725' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful home is a former model home with many upgrades including being a smart home is located in a gated community. This is truly a 4 bedroom 3 full bathroom home, there is a discrepancy in HCAD. With Granite countertops, open concept, home office, a tankless water heater, with large bedrooms and a few more surprises what more would you like? A large backyard you say, with a sprinkler system? This home has that too! The amenities are the lagoon, a coming soon dog park, playground and basketball court, the community is thriving and waiting on you! Come see this home soon.' ,`Acres` = '0.2501' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Summerwood/Lakeshore' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 32 BLK 1 BALMORAL SEC 13' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10894' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'RIDGE CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'AUTUMN RIDGE MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Balmoral Sec' ,`TaxAmount` = '9539' ,`TaxRate` = '2.9873' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663697817' WHERE `Matrix_Unique_ID` = '210599647' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-13T01:22:00.700' ,`MLSNumber` = '23278452' ,`ListAgentFullName` = 'Christi Borden' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.852983' ,`Longitude` = '-95.595661' ,`PhotoCount` = '49' ,`PostalCode` = '77041' ,`RoomCount` = '10' ,`ListPrice` = '640000.00' ,`Status` = 'Active' ,`StreetName` = 'Calico Falls' ,`StreetNumber` = '12227' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4259' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning Lakes on Eldridge North listing. Elegant curb appeal located on a large corner lot with detached full three car garage. Dramatic entry with striking wood floors, custom lighting features, fabulous wet bar area for entertaining, French Doors enclose a terrific study/den/media, large formal dining and living area with fireplace and windows overlooking sparkling private pool. The island kitchen offers elegant cherry stained cabinetry, stainless appliances, double ovens and task desk. The master is oversized with sitting area and large en-suite bath with garden jetted tub, oversized shower and abundant closet space. Upstairs, you will love the huge game-room, spacious 3 bedrooms with 2 baths. You will love entertaining friends and family in your gorgeous backyard with a wonderful pool/spa, large covered patio, mature trees and gardening space. (Photos accurately reflect property condition but taken prior to tenancy).' ,`Acres` = '0.3003' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure,Tenant Occupied' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Eldridge North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1 BLK 2 LAKES ON ELDRIDGE NORTH SEC 1' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '13082' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1854' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'KIRK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'TRUITT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakes On Eldridge North Sec 01' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663697817' WHERE `Matrix_Unique_ID` = '210625163' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-13T01:22:00.700' ,`MLSNumber` = '73777491' ,`ListAgentFullName` = 'Shamim Momin' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.704263' ,`Longitude` = '-95.791913' ,`PhotoCount` = '50' ,`PostalCode` = '77494' ,`RoomCount` = '9' ,`ListPrice` = '749900.00' ,`Status` = 'Active' ,`StreetName` = 'Gentle Moss' ,`StreetNumber` = '23918' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3600' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful HIGH CEILING home with resort style Swimming Pool in the sought-after community of SEVEN MEADOWS! Zoned to top-ranked KATY ISD schools! Low Tax rate! Open Floorplan offers Spacious living room, formal sitting area, dinning area, Game room, Huge Media Room. Charming Master suite w/patio acess door. Master bathroom Tub to relax and spacious walking closet with mirrored sliding doors. Beautiful kitchen with granite countertops,backsplash and lots of cabinet space. Another 3 large bedrooms on the 2nd floor. Backyard has covered patio, sparkling pool with spa perfect for entertaining. Enjoy the amenties like Walking Trails, a community pool,Parks, Fitness center and planned neighborhood events. Conveniently located near Grocery stores, Restaurants, and major highways-Grand Pkwy 99 and Westpark tollway.' ,`Acres` = '0.1918' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'SEVEN MEADOWS SEC 6, BLOCK 2, LOT 13' ,`LotDesciption` = 'Corner' ,`LotSize` = '8353' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'HOLLAND ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'SEVEN LAKES HIGH SCHOOL' ,`SchoolMiddle` = 'BECKENDORFF JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Seven Meadows Sec 6' ,`TaxAmount` = '9530' ,`TaxRate` = '2.5145' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663697817' WHERE `Matrix_Unique_ID` = '210832550' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-13T01:22:00.700' ,`MLSNumber` = '26089168' ,`ListAgentFullName` = 'Pompello Rubio' ,`ListOfficeName` = 'Texas Key Holders Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.132546' ,`Longitude` = '-95.391914' ,`PhotoCount` = '40' ,`PostalCode` = '77386' ,`RoomCount` = '11' ,`ListPrice` = '480000.00' ,`Status` = 'Active' ,`StreetName` = 'Linder Green' ,`StreetNumber` = '3219' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3277' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Looking for that one special place that you can call home and feel like you are at paradise? Look no further, super clean come that has it all. Plenty of space for the family or friends to hang out. Large living room area that opens up to the kitchen. This home is made for entertaining. Back door paradise. Home has a ton of upgrades. Come and lock this home in now to be yours before the interest rates take leap.' ,`Acres` = '0.1691' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S328308 - CANYON GATE AT LEGENDS RANCH 08, BLOCK 3, LOT 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7366' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '990' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'BIRNHAM WOODS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GRAND OAKS HIGH SCHOOL' ,`SchoolMiddle` = 'YORK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Canyon Gate At Legends Ranch 0' ,`TaxAmount` = '8033' ,`TaxRate` = '2.5587' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663697817' WHERE `Matrix_Unique_ID` = '210941922' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-13T01:22:00.700' ,`MLSNumber` = '10473491' ,`ListAgentFullName` = 'Danita Wiltz' ,`ListOfficeName` = 'C.R.Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.851564' ,`Longitude` = '-95.805206' ,`PhotoCount` = '42' ,`PostalCode` = '77493' ,`RoomCount` = '6' ,`ListPrice` = '399000.00' ,`Status` = 'Active' ,`StreetName` = 'Ivory Glass' ,`StreetNumber` = '5338' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2236' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Check out this 4 bedroom, 2 1/2 bath, 2 car garage home located in the highly desirable community of Kings Crossing in Katy, Texas. Meticulously maintained and full of builder upgrades & seller updates! The kitchen boasts an oversized island, granite countertops, gas range, tile backsplash, stainless steel appliances and tons of natural light. The open concept floor plan is perfect for entertaining! This beautiful home comes with laminate wood flooring in common areas, granite throughout, and a covered patio on an extra large corner lot, ideal for outdoor entertainment. Commuters will love the easy access to I-10 and the Grand Parkway. Students attend the highly acclaimed Katy Independent School District. Neighborhood Pool, Splashpad, Playground, and Dog Park! Don’t wait – schedule your showing today!' ,`Acres` = '0.1776' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 10 BLK 3 KING CROSSING SEC 3' ,`LotDesciption` = 'Corner' ,`LotSize` = '7738' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'BETHKE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKDICK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'King Xing Sec 3' ,`TaxAmount` = '8755' ,`TaxRate` = '3.4768' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663697817' WHERE `Matrix_Unique_ID` = '211107292' --> Updated record success