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-10T14:18:47.857' ,`MLSNumber` = '43652994' ,`ListAgentFullName` = 'Caroline Billipp' ,`ListOfficeName` = 'Greenwood King Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.738185' ,`Longitude` = '-95.420095' ,`PhotoCount` = '8' ,`PostalCode` = '77098' ,`RoomCount` = '6' ,`ListPrice` = '1349000.00' ,`Status` = 'Active' ,`StreetName` = 'Lake' ,`StreetNumber` = '3014' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3365' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New property offered by Lake Street Homes located in Upper Kirby. Walkability to some of Houston’s finest restaurants, shopping, grocery and night life. 3014 is a free standing brick residence with generous two car garage and private driveway. Details like a painted wood door and copper gas lanterns welcome guests into the home with 12 foot ceilings, gorgeous wood moldings, natural hardwood flooring and grand spiral staircase. The kitchen opens to the den with gas log fireplace and large sliding doors to backyard. Dining has a wine room adjacent and powder bath and mudroom on main floor. 3 large bedrooms including primary suite up with ensuite baths, walk in closets and a large Laundry. Elevator capable. Pre-wired for security and sound. All per Seller' ,`Acres` = '' ,`Area` = '16' ,`BuilderName` = 'Lake Street Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Upper Kirby' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 1 Block 1, David Crockett Second Replat Partial Replat' ,`LotDesciption` = 'Patio Lot' ,`LotSize` = '4557' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '100' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'POE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LANIER MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'David Crockett' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663696694' WHERE `Matrix_Unique_ID` = '204114136' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-10T15:23:40.843' ,`MLSNumber` = '23454414' ,`ListAgentFullName` = 'Phyllis Young' ,`ListOfficeName` = 'Longitude Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.633252' ,`Longitude` = '-96.312016' ,`PhotoCount` = '38' ,`PostalCode` = '77840' ,`RoomCount` = '10' ,`ListPrice` = '469900.00' ,`Status` = 'Active' ,`StreetName` = 'Neal Pickett' ,`StreetNumber` = '1115' ,`StreetSuffix` = 'Drive' ,`City` = 'College Station' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Custom built home near Texas A&M. This 4 bed, 3 1/2 bath home with over 3360 sq.ft. has been built with superb craftsmanship. This one owner home with family room, 2 dining areas, media room, sunroom, and in-house shop has lots of amenities. Some which are custom trim throughout, high grade laminate flooring, 2 fireplaces with gas logs, stainless steel appliances, granite countertops in kitchen, jacuzzi tub in master bath, and the house is wired for emergency generator in kitchen/shop area. The backyard has an oversize deck for gatherings and barbecues and storage shed with electricity. This home has a 2019 50 year roof and a 2017 HVAC system. All this for $489,900.' ,`Acres` = '0.2537' ,`Area` = '61' ,`BuilderName` = 'Hartman' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'Lot 8 Block 6' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '11050' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '153 - College Station' ,`SchoolElementary` = 'COLLEGE HILLS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'A & M CONSOLIDATED HIGH SCHOOL' ,`SchoolMiddle` = 'A & M CONSOLIDATED MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Carter\'s grove' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663696694' WHERE `Matrix_Unique_ID` = '209542192' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-10T14:20:45.790' ,`MLSNumber` = '83037715' ,`ListAgentFullName` = 'Timothy Anthony' ,`ListOfficeName` = 'Anthony Upton Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.758813' ,`Longitude` = '-95.388341' ,`PhotoCount` = '50' ,`PostalCode` = '77019' ,`RoomCount` = '11' ,`ListPrice` = '1699000.00' ,`Status` = 'Active' ,`StreetName` = 'Mckinney' ,`StreetNumber` = '1963' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3032' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Truly rare opportunity to own this exquisite 5 bedroom home with extensive updates throughout and situated within one of houston\'s most sought after neighborhoods. First time on the market! Offers oak wood, marble, travertine and tile throughout. Premier location only steps from Allen Parkway & Buffalo Bayou\'s hike, bike and running trails. Custom throughout with all new doors and windows, 2 wine refrigerators/coffee bars, gourmet kitchen with custom granite, 6 burner gas Thermador cooktop and oven W/KitchenAid appliances, three bowl sink W/pot filler, island, tons of storage in the custom built cabinets through entire house & closets. Recent sound system downstairs. Bath includes double sinks, urinal, jetted tub, separate oversized shower with 4 shower heads (2 Rain head). Fresh interior paint walls, trim and interior closets as well as recent fixtures 2022. home was taken to the studs. R38 insulation 2022. Never flooded. Too many updates to list.' ,`Acres` = '0.1148' ,`Area` = '16' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Montrose' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'LT 36 BLK 5 TEMPLE TERRACE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '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 Left Side,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Temple Terrace' ,`TaxAmount` = '14217' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1936' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663696694' WHERE `Matrix_Unique_ID` = '209876438' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-10T15:08:44.120' ,`MLSNumber` = '10188800' ,`ListAgentFullName` = 'Chae Cho' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.813985' ,`Longitude` = '-95.510458' ,`PhotoCount` = '28' ,`PostalCode` = '77080' ,`RoomCount` = '7' ,`ListPrice` = '399900.00' ,`Status` = 'Active' ,`StreetName` = 'Lakeshore bend' ,`StreetNumber` = '8815' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2759' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This is beautiful 3-story home in a gated community of Spring Branch. This property features: gorgeous wood floors, 3 bed and 3.5 baths, high ceilings, iron spindles, stainless steel appliances, washer and dryer included, refrigerator included, gas fireplace, granite countertops, huge Master bedroom, closet, etc. Conveniently located near 290 HWY, I-610, and I-10. You are less than 10 miles from Memorial City Mall, CITY CENTRE, and restaurants. This home is a must see!' ,`Acres` = '0.0499' ,`Area` = '24' ,`BuilderName` = 'Intown Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 20 BLK 3 HILSHIRE LAKES SEC 1 PAR R/P' ,`LotDesciption` = 'Other' ,`LotSize` = '2175' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'EDGEWOOD ELEMENTARY SCHOOL (SPRING BRANCH)' ,`SchoolHigh` = 'NORTHBROOK HIGH SCHOOL' ,`SchoolMiddle` = 'SPRING WOODS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Hilshire Lakes Sec 01 Pt' ,`TaxAmount` = '9533' ,`TaxRate` = '2.6139' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663696694' WHERE `Matrix_Unique_ID` = '210298818' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-10T14:50:29.063' ,`MLSNumber` = '4172451' ,`ListAgentFullName` = 'Jonathan McNabb' ,`ListOfficeName` = 'Nest Ahead' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.831058' ,`Longitude` = '-95.190438' ,`PhotoCount` = '9' ,`PostalCode` = '77049' ,`RoomCount` = '5' ,`ListPrice` = '303990.00' ,`Status` = 'Active' ,`StreetName` = 'Wembley Heights' ,`StreetNumber` = '13407' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1847' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The one-story 4 bedroom and 3 bathroom Prism plan is the ideal home for a family. In this home, you will enjoy a spacious kitchen, dining and family room area. The kitchen features brand new stainless steel appliances, granite countertops, large island and upgraded cabinets. The photos are stock photos, and do not represent the exact home.' ,`Acres` = '' ,`Area` = '2' ,`BuilderName` = 'Starlight Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Imperial Forest Section 4 Block 4 Lot 11' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '360' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '46 - Sheldon' ,`SchoolElementary` = 'ROYALWOOD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CE KING HIGH SCHOOL' ,`SchoolMiddle` = 'C.E. KING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Imperial Forest' ,`TaxAmount` = '' ,`TaxRate` = '3.6051' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663696694' WHERE `Matrix_Unique_ID` = '210328126' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-10T15:44:05.453' ,`MLSNumber` = '12873598' ,`ListAgentFullName` = 'Janelle Whatley' ,`ListOfficeName` = 'Barger Capital Realty PLLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.656064' ,`Longitude` = '-95.350563' ,`PhotoCount` = '23' ,`PostalCode` = '77033' ,`RoomCount` = '5' ,`ListPrice` = '421000.00' ,`Status` = 'Active' ,`StreetName` = 'Wilmington' ,`StreetNumber` = '4841' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '3361' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'YOUR NEW HOME AWAITS! HUGE LOT OVER 12000 SQUARE FEET BIG ENOUGH TO ADD A POOL AND STILL HAVE PLENTY OF GREEN SPACE. HOME WAS FINISHED IN 2016 TOP OF THE LINE FIXTURES AND FINISHES THIS HOME WAS BUILT TO LAST. GRANITE COUNTER TOPD STONE IN PRIMARY BATH BREAKFAST BAR WOOD FINISHES IN KITCHEN TOO MUCH TO NAME! YOU DONT WANT TO MISS THIS ONE EVERYTHING IN THE HOME STAYS THERE ALSO THERE IS PLENTY OF LOT SPACE BEHIND HOME FOR A HORSE STABLE STORAGE OR WORKSHOP. SELLER IS MOTIVATED PLEASE SEND YOUR OFFERS' ,`Acres` = '0.2755' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Medical Center South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 27 BLK 11 SUNNYSIDE GARDENS' ,`LotDesciption` = 'Other' ,`LotSize` = '12000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WOODSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'THOMAS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sunnyside Gardens' ,`TaxAmount` = '11533' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663696694' WHERE `Matrix_Unique_ID` = '210766704' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-10T15:03:03.753' ,`MLSNumber` = '81487794' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Long Lake LTD' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.495983' ,`Longitude` = '-95.811150' ,`PhotoCount` = '18' ,`PostalCode` = '77471' ,`RoomCount` = '14' ,`ListPrice` = '434604.00' ,`Status` = 'Active' ,`StreetName` = 'Ehrlich' ,`StreetNumber` = '4627' ,`StreetSuffix` = 'Court' ,`City` = 'Rosenberg' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2608' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home is under construction. This fantastic Lake Ridge Builders home in Briarwood Crossing is what you’ve been looking for. Resting on a spacious lot, this 3-sided brick home boasts a premium elevation, tile flooring, sprinkler system, wrought iron spindles, faux wood blinds, and a covered patio. Spend quality time in the kitchen, equipped with granite countertops, stainless steel appliances, 42” upper cabinets, and undercabinet lighting. The serene primary suite features an owner’s retreat, a 36” tub, and a separate shower. Community comforts include a 5-acre park, pool, recreation area with a splash pad, and walking trails. Commuters enjoy easy access to Hwy 59 and the Grand Parkway. Zoned to the highly acclaimed Lamar Consolidated ISD. Don’t wait – call now to learn more!' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Lake Ridge Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 7 Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '533' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'CULVER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RANDLE HIGH SCHOOL' ,`SchoolMiddle` = 'WRIGHT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Briarwood Crossing' ,`TaxAmount` = '' ,`TaxRate` = '3.47' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663696695' WHERE `Matrix_Unique_ID` = '210935445' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-10T15:05:24.133' ,`MLSNumber` = '60471341' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Long Lake LTD' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.495983' ,`Longitude` = '-95.811150' ,`PhotoCount` = '17' ,`PostalCode` = '77471' ,`RoomCount` = '15' ,`ListPrice` = '517035.00' ,`Status` = 'Active' ,`StreetName` = 'Trembling Aspen' ,`StreetNumber` = '5010' ,`StreetSuffix` = 'Lane' ,`City` = 'Rosenberg' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2958' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home is under construction. This amazing Briarwood Home in Briarwood Crossing could be your dream home. Situated on a spacious lot, this 4-sided brick home boasts tile flooring, full gutters, a sprinkler system, wrought iron spindles, faux wood blinds, cast stone fireplace, a media room with surround sound pre-wire, a study with French doors, a mud set walk-in shower in the primary suite, and a covered patio. Cook up new cuisines in the kitchen, equipped with granite countertops, stainless steel appliances, 42” upper cabinets, and undercabinet lighting. Community comforts include a 5-acre park, pool, recreation area with a splash pad, and walking trails. Commuters enjoy easy access to Hwy 59 and the Grand Parkway. Zoned to the highly acclaimed Lamar Consolidated ISD. Call today!' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Briarwood Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 21 Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '533' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'CULVER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RANDLE HIGH SCHOOL' ,`SchoolMiddle` = 'WRIGHT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Briarwood Crossing' ,`TaxAmount` = '' ,`TaxRate` = '3.47' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663696695' WHERE `Matrix_Unique_ID` = '210936309' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-10T15:03:37.230' ,`MLSNumber` = '29259030' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Long Lake LTD' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.495075' ,`Longitude` = '-95.810915' ,`PhotoCount` = '18' ,`PostalCode` = '77471' ,`RoomCount` = '15' ,`ListPrice` = '448495.00' ,`Status` = 'Active' ,`StreetName` = 'Fogmist' ,`StreetNumber` = '3242' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosenberg' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3129' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home is under construction. Escape the city to this lovely Lake Ridge Builders home in Briarwood Crossing. Situated on a spacious lot, this 3-sided brick home boasts a premium elevation, tile flooring, full gutters, sprinkler system, wrought iron spindles, faux wood blinds, a study with French doors, and a covered patio. Whip up meals for guests in the kitchen, equipped with granite countertops, stainless steel appliances, 42” upper cabinets, and undercabinet lighting. The spa-like primary suite features dual vanities, a 42” tub, and a separate shower. Community comforts include a 5-acre park, pool, recreation area with a splash pad, and walking trails. Commuters enjoy easy access to Hwy 59 and the Grand Parkway. Zoned to the highly acclaimed Lamar Consolidated ISD. Don’t wait – call now to learn more!' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Lake Ridge Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 29 Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '533' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'CULVER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RANDLE HIGH SCHOOL' ,`SchoolMiddle` = 'WRIGHT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Briarwood Crossing' ,`TaxAmount` = '' ,`TaxRate` = '3.47' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663696695' WHERE `Matrix_Unique_ID` = '210938914' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-10T15:04:46.447' ,`MLSNumber` = '36827854' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Long Lake LTD' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.495075' ,`Longitude` = '-95.810915' ,`PhotoCount` = '18' ,`PostalCode` = '77471' ,`RoomCount` = '14' ,`ListPrice` = '444925.00' ,`Status` = 'Active' ,`StreetName` = 'Fogmist' ,`StreetNumber` = '3302' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosenberg' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2620' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home is under construction. Feel at ease in this beautiful Lake Ridge Builders home in Briarwood Crossing. Resting on a spacious lot, this 3-sided brick home boasts a premium elevation, tile flooring, full gutters, sprinkler system, 3-car garage, wrought iron spindles, faux wood blinds, study with French doors, and a covered patio. Master new recipes in the kitchen, equipped with granite countertops, stainless steel appliances, 42” upper cabinets, and undercabinet lighting. Spend evenings relaxing in the primary suite features dual vanities, a 42” tub, and a separate shower. Community comforts include a 5-acre park, pool, recreation area with a splash pad, and walking trails. Commuters enjoy easy access to Hwy 59 and the Grand Parkway. Zoned to the highly acclaimed Lamar Consolidated ISD. Don’t wait – call now to learn more!' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Lake Ridge Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 28 Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '533' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Freestanding Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'CULVER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RANDLE HIGH SCHOOL' ,`SchoolMiddle` = 'WRIGHT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Briarwood Crossing' ,`TaxAmount` = '' ,`TaxRate` = '3.47' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663696695' WHERE `Matrix_Unique_ID` = '210940154' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-10T15:15:58.303' ,`MLSNumber` = '3201092' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Long Lake LTD' ,`SellingAgentFullName` = ' Non-MLS Agent' ,`SellingOfficeName` = 'Non-MLS ' ,`Latitude` = '30.015063' ,`Longitude` = '-95.650220' ,`PhotoCount` = '11' ,`PostalCode` = '77429' ,`RoomCount` = '14' ,`ListPrice` = '459740.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Poplar Lake' ,`StreetNumber` = '14627' ,`StreetSuffix` = 'Trail' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2657' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '*This home is under construction.*' ,`Acres` = '' ,`Area` = '35' ,`BuilderName` = 'Lake Ridge Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 12 Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'BLACK ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CY-FAIR HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Telge Ranch' ,`TaxAmount` = '' ,`TaxRate` = '3.07' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663696695' WHERE `Matrix_Unique_ID` = '211184499' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-10T15:21:21.090' ,`MLSNumber` = '83321841' ,`ListAgentFullName` = 'Bryan Anthony' ,`ListOfficeName` = 'Allstar Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.322537' ,`Longitude` = '-95.463392' ,`PhotoCount` = '18' ,`PostalCode` = '77301' ,`RoomCount` = '8' ,`ListPrice` = '220000.00' ,`Status` = 'Active' ,`StreetName` = 'Everett' ,`StreetNumber` = '703' ,`StreetSuffix` = 'Street' ,`City` = 'Conroe' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1600' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Live/Work opportunity in this well located unrestricted property in Conroe, TX. The back room has a full bath w/ Shower. A Kitchen w/ Dining Area! There\'s a half bath up front. Lots of windows for natural light. Many rooms, large and small plus a waiting/living room and a reception area. Rear parking lot, ample parking.' ,`Acres` = '0.1693' ,`Area` = '19' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Conroe Northeast' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'S792000 - PINE HILL, BLOCK 1, LOT 2' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '7375' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Built Up' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'HOUSTON ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Pine Hill' ,`TaxAmount` = '2754' ,`TaxRate` = '2.1863' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1973' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663696695' WHERE `Matrix_Unique_ID` = '211262771' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-10T15:16:17.660' ,`MLSNumber` = '9186610' ,`ListAgentFullName` = 'Shannon Rampley' ,`ListOfficeName` = 'Keller Williams Realty Austin' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.828724' ,`Longitude` = '-96.960066' ,`PhotoCount` = '23' ,`PostalCode` = '77901' ,`RoomCount` = '4' ,`ListPrice` = '225000.00' ,`Status` = 'Active' ,`StreetName` = 'Cabana' ,`StreetNumber` = '111' ,`StreetSuffix` = '' ,`City` = 'Victoria' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1144' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning 2 bedroom 2 bathroom patio home! Waiting for its new owners to move right in & be at home! Open concept with everything you could want in a home. Brand new flowerbeds, patio & small backyard for minimal outside maintenance. Call today for a private showing! This house will not last long!' ,`Acres` = '' ,`Area` = '66' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'TANGERINE II LOT 6 BLOCK 6' ,`LotDesciption` = 'Patio Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '191 - Victoria' ,`SchoolElementary` = 'MARTIN DE LEON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'VICTORIA EAST HIGH SCHOOL' ,`SchoolMiddle` = 'HOWELL MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Craftsman,Traditional' ,`Subdivision` = 'Tangerine' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1981' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663696696' WHERE `Matrix_Unique_ID` = '211268491' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-10T15:34:34.620' ,`MLSNumber` = '63703208' ,`ListAgentFullName` = 'Matthew Guzman' ,`ListOfficeName` = 'RE/MAX Universal' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.724161' ,`Longitude` = '-95.938477' ,`PhotoCount` = '6' ,`PostalCode` = '77423' ,`RoomCount` = '8' ,`ListPrice` = '369990.00' ,`Status` = 'Active' ,`StreetName` = 'Franklin Brooks' ,`StreetNumber` = '32923' ,`StreetSuffix` = 'Drive' ,`City` = 'Fulshear' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1848' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to your beautiful Wetherby Floor Plan 1 Story, 3 Bedroom, 2 Bath, with an attached 2 Car Garage. This floor plan boasts High Ceilings and a Spacious OPEN CONCEPT FLOOR PLAN with the Family Room with direct vent Fireplace, Kitchen, Breakfast Room, Study/Flex Room, and 3 spacious bedrooms. COVERED PATIO with fenced backyard. Tile and Carpet throughout. COST AND ENERGY EFFICIENCY FEATURES: 16 Seer HVAC System, Honeywell Thermostat, Pex Hot & Cold Water Lines, Radiant Barrier, and Vinyl Double Pane Low E Windows that open to the inside of the home for cleaning. A scenic overlook greets visitors as soon as they drive in, revealing a lakeside view that gives way to an open-air pavilion and amenity center. Amenities include RESORT-STYLE SWIMMING POOL! SPLASHPAD! CHILDREN’S PLAYGROUND! Convenient to I-10, TX Hwy 359, and Westpark Tollway. Lamar CISD!' ,`Acres` = '0.1636' ,`Area` = '30' ,`BuilderName` = 'Anglia Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fulshear/South Brookshire/Simonton' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'VANBROOKE SEC 2, BLOCK 6, LOT 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7125' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'HUGGINS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Vanbrooke' ,`TaxAmount` = '2082' ,`TaxRate` = '3.2948' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663696696' WHERE `Matrix_Unique_ID` = '211270638' --> Updated record success