Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-12T01:22:00.240' ,`MLSNumber` = '64367888' ,`ListAgentFullName` = 'Joe Rothchild' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.226109' ,`Longitude` = '-95.702707' ,`PhotoCount` = '14' ,`PostalCode` = '77354' ,`RoomCount` = '9' ,`ListPrice` = '319990.00' ,`Status` = 'Active' ,`StreetName` = 'Bay Warbler' ,`StreetNumber` = '40319' ,`StreetSuffix` = 'Way' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1754' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '1 Story, 3 Bedroom, 2 Bath, All Brick, Primary Bedroom has 2 Walk-In Closets, Open Concept Kitchen/Dining Combo, Dual Vanities in Primary Bath, Vinyl Plank Floors in Dining Room, Kitchen, Family Room and All Wet Areas, Granite Kitchen Countertops, Island Kitchen, Tile Backsplash, Undermount Stainless Steel Sink with Pull Out Faucet, Upgraded Stainless Steel Appliances with Microwave, 42” Upper Kitchen Cabinets, Upgraded Lighting & Trim Packages, 2\" Faux Wood Blinds, Covered Patio, Landscaping with Full Sod and Irrigation, Tech Shield Radiant Barrier, Environments for Living Home, plus more…AVAILABLE JULY/AUGUST.' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'Devon Street Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 17 BLK 3 SEC 2A' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1850' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'MAGNOLIA PARKWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Audubon' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663709541' WHERE `Matrix_Unique_ID` = '206281770' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-12T01:03:05.603' ,`MLSNumber` = '19557567' ,`ListAgentFullName` = 'Macarena Korth' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.342722' ,`Longitude` = '-96.610847' ,`PhotoCount` = '22' ,`PostalCode` = '77879' ,`RoomCount` = '3' ,`ListPrice` = '115000.00' ,`Status` = 'Active' ,`StreetName` = 'Acorn Oak' ,`StreetNumber` = '315' ,`StreetSuffix` = 'Street' ,`City` = 'Somerville' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '1' ,`SqFtTotal` = '640' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Perfect vacation home recently moved into Somerville Place Subdivision. It\'s 640 sq. 1 bed/1bath home with metal roof in amazing condition. New porch and small room addition built. Electric and water connected. Sits on 4 lots totaling 0.45 acres just minutes to Lake Somerville. These beautiful 4 lots have nice, shaded trees and have been cleared. Low Taxes, Low HOA Fees, Light Restrictions & short distance to Community Pool. Great place for family weekends and entertaining friends. Owner has 3 additional corner lots available for sale that can make the property a little over 0.80 acres. All reasonable offers will be entertained.' ,`Acres` = '0.4592' ,`Area` = '59' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '1' ,`Legal` = 'S2502 SOMERVILLE PLACE LOT 500, 501, 502 and 503' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '20002' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '137' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = 'Enclosed' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '158 - Somerville' ,`SchoolElementary` = 'SOMERVILLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SOMERVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'SOMERVILLE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Somerville Place' ,`TaxAmount` = '403' ,`TaxRate` = '1.7844' ,`WaterSewer` = 'No Sewer,Septic Tank' ,`YearBuilt` = '0' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663709541' WHERE `Matrix_Unique_ID` = '206293646' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-12T01:22:00.240' ,`MLSNumber` = '54178815' ,`ListAgentFullName` = 'Terin Varghese' ,`ListOfficeName` = 'XAG Properties, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.592260' ,`Longitude` = '-95.593697' ,`PhotoCount` = '31' ,`PostalCode` = '77478' ,`RoomCount` = '5' ,`ListPrice` = '319000.00' ,`Status` = 'Active' ,`StreetName` = 'Honey Creek' ,`StreetNumber` = '3418' ,`StreetSuffix` = 'Drive' ,`City` = 'Sugar Land' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1749' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'RARE FIND! One story home with 3 Beds 2 Baths. NO CARPETS IN THIS HOME! A great floor plan with lots of upgrades from Appliances, Full Bathroom Renovated with beautiful Quarts tops, sink, shower surround and tiling. LOCATED IN DESIRABLE CREEKSHIRE SUBDIVISION. WALKING DISTANCE TO LOST CREEK PARK. HOME FEATURES FAMILY ROOM WITH BEAUTIFUL BRICK FIREPLACE; FORMAL DINING ROOM; KITCHEN WITH BREAKFAST BAR; SPACIOUS MASTER BEDROOM; MASTER BATH WITH DOUBLE SINKS; JETTED TUB & SEPARATE SHOWER; HUGE WALK-IN CLOSET; NEW ROOF OCTOBER 2017.' ,`Acres` = '0.113' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'CREEKSHIRE SEC 2, BLOCK 3, LOT 34' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4923' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '810' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'HIGHLANDS ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'DULLES HIGH SCHOOL' ,`SchoolMiddle` = 'DULLES MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Creekshire Sec 2' ,`TaxAmount` = '5033' ,`TaxRate` = '2.1594' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1987' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663709541' WHERE `Matrix_Unique_ID` = '208407969' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-12T01:22:00.240' ,`MLSNumber` = '98594054' ,`ListAgentFullName` = 'Jeanette Bufkin' ,`ListOfficeName` = 'Vista Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.406448' ,`Longitude` = '-95.083143' ,`PhotoCount` = '48' ,`PostalCode` = '77510' ,`RoomCount` = '7' ,`ListPrice` = '750000.00' ,`Status` = 'Active' ,`StreetName` = 'AVE J' ,`StreetNumber` = '2500' ,`StreetSuffix` = '' ,`City` = 'Santa Fe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2335' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'CHARMING HOME ON aprox.6 ACRES. WITH 50X40 RV SPACE, SHOP, AND STORAGE.PLUS SOME COVERED PARKING. THIS LOVELY HOME HAS 4 BEDROOMS.THE LARGE LIVING ROOM AND 4TH BEDROOM HAS A DOOR TO THE OUTSIDE PATIOS. MASTER BEDROOM WITH TWO CLOSETS PLUS LINEN CABINET. THE LAUNDRY AND PANTRY ROOM IS A GREAT SIZE WITH LOTS OF CABINETS. LARGE OPENING BETWEEN KITCHEN, DINING, AND LIVING ROOM IS GREAT FOR ENTERTAINING. THIS PEACEFUL SITTING HAS A ORANGE ,1 PEARS ,AND OAKS TREES.ROOM TO RELAX AWAY FROM THE WORLD BUT STILL CLOSE THE STORES AND SHOPPING. NO SURVEY OLD DEED SHOWS A LITTLE OVER 6ACRES WHICH INCLUDEDS THE ROAD ( FROMTHE CAD S PLAT MAP )' ,`Acres` = '6' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Santa Fe' ,`HeatSystem` = 'Propane' ,`HOAMandatory` = '0' ,`Legal` = 'PT OF LOT 170 (170-5) THAMANS 3RD SUB' ,`LotDesciption` = 'Cleared' ,`LotSize` = '260488' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '45 - Santa Fe' ,`SchoolElementary` = '' ,`SchoolHigh` = 'SANTA FE HIGH SCHOOL' ,`SchoolMiddle` = 'SANTA FE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'THAMAN 3RD' ,`TaxAmount` = '11157' ,`TaxRate` = '2.35362' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '1981' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663709541' WHERE `Matrix_Unique_ID` = '208453652' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-12T01:34:26.893' ,`MLSNumber` = '77963422' ,`ListAgentFullName` = 'Monique Guidry' ,`ListOfficeName` = 'Texas New Homebuilder Solutions LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.149618' ,`Longitude` = '-95.584096' ,`PhotoCount` = '50' ,`PostalCode` = '77354' ,`RoomCount` = '11' ,`ListPrice` = '999999.00' ,`Status` = 'Active' ,`StreetName` = 'Burdekin' ,`StreetNumber` = '8614' ,`StreetSuffix` = 'Road' ,`City` = 'Magnolia' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '6' ,`SqFtTotal` = '4891' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'CALL/TEXT for appts. Mid-Century MOD MANSION MAGNOLIA! Incredible SIX-bedroom, FOUR and a half-bathroom architectural GEM in desirable Northgrove community, featuring contemporary painted brick upgrade, high ceilings, wood-look waterproof flooring, auto lawn sprinkler, formal dining, great room, and extended covered patio in pool ready backyard. Island kitchen, custom cabinets complete with granite, designer backsplash, gas cooktop, walk-in pantry, and breakfast bar. The comfortable primary suite is equipped with a dual walk-in closet, dual vanities, a freestanding tub, and a separate double shower. Neighborhood amenities include a 9,400-sq.-ft. clubhouse, resort-style pool, fitness center, hike & bike trails, community dog park, tennis courts, and acres of green space. Shopping/dining can be found nearby in The Woodlands, Grand Parkway Marketplaces & Old Town Spring. Multiple golf courses and Burroughs Park behind home. Best price per sqft value for one of Northgrove’s largest homes' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'Perry' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Owner/Agent' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 11 BLK 1 Northgrove Section 5' ,`LotDesciption` = 'Cul-De-Sac,Greenbelt,Subdivision Lot,Wooded' ,`LotSize` = '10623' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1295' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'CEDRIC C. SMITH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access,Lockbox Back,Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Northgrove' ,`TaxAmount` = '' ,`TaxRate` = '3.37' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663709541' WHERE `Matrix_Unique_ID` = '209954822' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-12T01:22:00.240' ,`MLSNumber` = '10238209' ,`ListAgentFullName` = 'Khuong Do' ,`ListOfficeName` = 'AMX Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.140360' ,`Longitude` = '-95.048385' ,`PhotoCount` = '18' ,`PostalCode` = '77554' ,`RoomCount` = '6' ,`ListPrice` = '605000.00' ,`Status` = 'Active' ,`StreetName` = 'Grayson' ,`StreetNumber` = '4102' ,`StreetSuffix` = 'Drive' ,`City` = 'Galveston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1490' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW CONSTRUCTION - JULY COMPLETION located in Sea Isle! Elegantly designed open floor plan includes island bar, state of the art kitchen, premium cabinetry, quartz counters throughout, and SS appliances! Durable wood-look Luxury Vinyl Plank flooring below and soaring 11ft vaulted ceiling above! Extra large front porch for group enjoyment with a private rear porch accessible from the master bedroom. Master en suite with oversized frameless glass shower and double vanity makes it the perfect way to wake up in paradise! High efficiency spray foam insulation, hurricane proof grade windows and doors, outdoor shower, oversized garage! Subdivision amenities include pool, boat launch, fishing pier, tennis court. *Representative photos of the same completed floor plan*' ,`Acres` = '0.1439' ,`Area` = '33' ,`BuilderName` = 'Private Builder' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'West End' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 121 HALL & JONES SUR LOT 1545 SEA ISLE 3RD EXTENSION' ,`LotDesciption` = 'Other' ,`LotSize` = '6270' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '216' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Sea Isle Ext 3' ,`TaxAmount` = '1351' ,`TaxRate` = '2.0324' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663709541' WHERE `Matrix_Unique_ID` = '209984651' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-12T00:27:27.530' ,`MLSNumber` = '36213754' ,`ListAgentFullName` = 'Diane Driscoll' ,`ListOfficeName` = 'Rock Edwards & Associates,' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.694678' ,`Longitude` = '-95.534240' ,`PhotoCount` = '22' ,`PostalCode` = '77036' ,`RoomCount` = '8' ,`ListPrice` = '318000.00' ,`Status` = 'Active' ,`StreetName` = 'Langdon' ,`StreetNumber` = '8418' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1930' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fabulous SHARPSTOWN house with LOTS OF UPDATES - UPDATED KITCHEN w/ GLASS FRONT CABINETS, DRAWERS, GLASS-TOP STOVE, LOW-e HURRICANE-RESISTANT WINDOWS (2013 - UP TO 175 mph), STORM DOORS (2013), ROOF replaced 2016, A/C Coils & Condenser (2013), Gas Water Heater (2018). NO CARPET! EXTRA-LARGE LIVING ROOM! WATER LINES RE-PIPED with PEX 2021. WHOLE-HOUSE GENERATOR (2020)!!! WALK-IN TUB (2018) CEDAR-LINED Coat Closet. NEST DIGITAL THERMOSTAT will convey with house.' ,`Acres` = '0.1896' ,`Area` = '21' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sharpstown Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 15 BLK 43 SHARPSTOWN COUNTRY CLUB TERRACE SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8260' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'NEFF ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SHARPSTOWN HIGH SCHOOL' ,`SchoolMiddle` = 'SUGAR GROVE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sharpstown Cc Terrace Sec 02' ,`TaxAmount` = '5071' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1961' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663709541' WHERE `Matrix_Unique_ID` = '210014175' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-12T01:22:00.240' ,`MLSNumber` = '13615244' ,`ListAgentFullName` = 'Jennifer Cannon' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.744385' ,`Longitude` = '-95.596229' ,`PhotoCount` = '16' ,`PostalCode` = '77077' ,`RoomCount` = '7' ,`ListPrice` = '499900.00' ,`Status` = 'Active' ,`StreetName` = 'Rocky Knoll' ,`StreetNumber` = '12218' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2688' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful Energy Corridor Home in the established Shadow Briar Subdivision. Enjoy your drive home to this award winning community with mature trees and amenities that include enticing swimming pools, tennis courts, and a clubhouse. This spacious 4 bedroom 3.5 bath home with an office features updated bathrooms and kitchen with granite countertops. Brand new hardwoods covering the 1st floor. The primary\'s ensuite bathroom has an Egyptian style tub shower combo, double walk-in closets with builtins and double sinks. Upstairs are three other spacious bedrooms, one with a lovely ensuite bathroom while the other two are adjoined by a jack-n-jill with double sinks. New light fixtures and a brand new A.C. were added in August 2021! New Roof and siding added in April of 2022! The detached garage has a covered walkway and is equip with floor to ceiling California storage cabinets and epoxy flooring. Come sit in your backyard oasis and enjoy the tranquility this home offers.' ,`Acres` = '0.1782' ,`Area` = '31' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Energy Corridor' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 5 BLK 4 SHADOWBRIAR SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7762' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ASHFORD/SHADOWBRIAR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'WEST BRIAR MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,English,Other Style,Split Level,Traditional' ,`Subdivision` = 'Shadowbriar' ,`TaxAmount` = '7238' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663709542' WHERE `Matrix_Unique_ID` = '210307017' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-12T01:22:00.240' ,`MLSNumber` = '58427906' ,`ListAgentFullName` = 'Nola Lusk' ,`ListOfficeName` = 'A\'Lon Realty Co.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.824769' ,`Longitude` = '-95.436372' ,`PhotoCount` = '50' ,`PostalCode` = '77018' ,`RoomCount` = '7' ,`ListPrice` = '1150000.00' ,`Status` = 'Active' ,`StreetName` = 'Wakefield' ,`StreetNumber` = '1419' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '4229' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning 4-bedroom home located in the highly sought-after neighborhood of Oak Forest. Entry features a 42 Inch wide Solid Mahagony Leaded Glass Door with artistic iron grills. Spacious living area with gas fireplace, Solid Red Oak 4-inch-wide plank flooring. Large formal dining room w/beautiful trim work. The spacious kitchen features granite countertops, huge custom island with seating for 4, Wolfe 6 burner gas range with griddle, floor to ceiling cabinets. Butler\'s pantry. Subzero fridge stays. All wet areas feature Travertine tile. Primary suite offers oversized shower, air jacuzzi tub, granite countertops, dual sinks and large walk-in closet! Upstairs presents Generously sized bedrooms and one bedroom has a private Bath. Media Room, Private office with custom built cabinetry and a Game Room. Custom blinds by the Shade Shop/Designer Paint Farrow & Ball. Covered patio equipped with provisions for a Summer Kitchen. Immaculately maintained home and Perfect floorplan for entertaining!' ,`Acres` = '0.1625' ,`Area` = '9' ,`BuilderName` = 'Hildago' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Oak Forest East Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 19 BLK 22 OAK FOREST SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7080' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'OAK FOREST ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'BLACK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Mediterranean' ,`Subdivision` = 'Oak Forest Sec 02' ,`TaxAmount` = '22025' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2011' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663709542' WHERE `Matrix_Unique_ID` = '210560622' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-12T01:22:00.240' ,`MLSNumber` = '68995160' ,`ListAgentFullName` = 'Nicholas Hughley' ,`ListOfficeName` = 'NB Elite Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.888683' ,`Longitude` = '-95.724838' ,`PhotoCount` = '43' ,`PostalCode` = '77433' ,`RoomCount` = '4' ,`ListPrice` = '330000.00' ,`Status` = 'Active' ,`StreetName` = 'Honey Pine' ,`StreetNumber` = '7507' ,`StreetSuffix` = 'Lane' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3080' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Spacious and open floor plan located in a cul de sac! This home is ready for you to make your own with SOLAR PANELS to help fight the rising cost of energy bills. Updated TANKLESS WATER HEATER! Plus the WASHER, DRYER and REFRIGERATOR will stay with the home. BRAND NEW stainless steel range/oven. Come enjoy the quiet Canyon Village At Cypress Springs subdivision with its highly rated schools and school district. Spacious bedrooms and game room upstairs make this a great home in a great neighborhood! Schedule your appointment before it’s too late!' ,`Acres` = '0.1503' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Electric,Central Gas,Solar Assisted' ,`HOAMandatory` = '1' ,`Legal` = 'LT 32 BLK 3 CANYON VILLAGE AT CYPRESS SPRINGS SEC 8' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '6545' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '550' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'WALKER ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CYPRESS PARK HIGH SCHOOL' ,`SchoolMiddle` = 'HOPPER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,No Supra Keybox,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Canyon Spgs' ,`TaxAmount` = '6749' ,`TaxRate` = '2.69' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663709542' WHERE `Matrix_Unique_ID` = '210566476' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-12T01:22:00.240' ,`MLSNumber` = '19798626' ,`ListAgentFullName` = 'Dionne Randle' ,`ListOfficeName` = 'MOD Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.539357' ,`Longitude` = '-95.583590' ,`PhotoCount` = '40' ,`PostalCode` = '77479' ,`RoomCount` = '10' ,`ListPrice` = '600000.00' ,`Status` = 'Active' ,`StreetName` = 'Stoney Ridge' ,`StreetNumber` = '4619' ,`StreetSuffix` = 'Court' ,`City` = 'Sugar Land' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3084' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to Riverstone: you can now breathe, this home is zoned to Fort Bend schools, and near all the highways and tollways. This Meritage Waterleaf floor plan is an oversized 1 story that has it all, 4 bedrooms, 3 full baths, covered patio/deck, study/office, media room, and an extra room which is great for a study nook, along with some upgraded features: epoxy garage, water softener, reverse osmosis, bidets, washer, dryer, soft doors, plus wood, tile, and marble flooring. No carpet. The home is also set up with gutters, sprinkler system, ring doorbell, alarm system, and camera system if you would like to take over the service. This home is energy efficient with great community amenities, so come and take a look today!' ,`Acres` = '0.1656' ,`Area` = '29' ,`BuilderName` = 'Meritage' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land South' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'AUBURN MANOR AT RIVERSTONE SEC 3, BLOCK 2, LOT 18' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7213' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1110' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'SULLIVAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ELKINS HIGH SCHOOL' ,`SchoolMiddle` = 'FORT SETTLEMENT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Auburn Manor At Riverstone Sec 3' ,`TaxAmount` = '9010' ,`TaxRate` = '2.4529' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663709542' WHERE `Matrix_Unique_ID` = '211442075' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','211766236','1663709542','211766236','2022-09-12T01:22:00.240','73418393','Stanley Mani','MIH REALTY, LLC','','','29.524544','-95.550851','50','77459','13','609900.00','Active','Pointed Leaf','5402','Drive','Missouri City','3','1','5','3552','Single-Family','Beautifully young maintained energy-efficient Meritage home nestled on a large corner cul de sac lot in the GATED Pecan Estates of Anderson Springs Community in Sienna Plantation. Located minutes from Highway 6, this home features a great Open floorplan with 5 bedrooms, 3.5 baths, 3 car side entrance garage, formal dining, a large family room, office/study, soaring ceilings, spacious kitchen equipped with an island, Xtra long driveway, breakfast area, media, and a game room. The Primary bedroom and secondary bedrooms are comfortable and cozy, nicely sized for furniture of your choice! Primary bath has double sinks and vanities with a relaxing garden/soaking tub and stand-alone shower. Wood floors throughout the 1st floor with a carpeted second story. Then take a step outside to the gorgeous backyard with a garden already set up and planted fruit trees to watch mature throughout the years and memories in this home. Zoned to top-ranked Ft. Bend ISD schools. Schedule a tour today!','0.3378','38','Meritage','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gas Connections,Gaslog Fireplace','1','Sienna Area','Central Gas','1','PECAN ESTATES AT ANDERSON SPRINGS SEC 2, BLOCK 2, LOT 8','Cul-De-Sac,In Golf Course Community,Subdivision Lot','14716','Appraisal District','','2045','0','','3','Gas Oven','0','','','Gas Range','','Composition','19 - Fort Bend','SCHIFF ELEMENTARY SCHOOL','RIDGE POINT HIGH SCHOOL','BAINES MIDDLE SCHOOL','Appointment Required,Supra Keybox','Appraisal District','2','Traditional','SIENNA','11688','2.8129','Public Sewer,Public Water,Water District','2015','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212283378','1663709542','212283378','2022-09-12T00:25:26.493','14861192','Kimblay West','Glass House Realty LLC','','','29.809219','-94.928451','25','77521','7','300000.00','Active','Hunters Way','6811','Lane','Baytown','2','0','4','1931','Single-Family','Amazing 4 bed/2 bath home in Hunters Creek. This home has the ideal open floor plan. Granite kitchen counter tops with a large island. Master suite has whirlpool tub, great after a long hard day. 4th bedroom right off the master suite can be used as a home office. New carpet (9/2022) in living area and front bedrooms. Home equipped with many energy features that you will love. Neighborhood offers a water splashpad and playground within walking distance of home. Comes equipped with security system including doorbell camera. You don\'t want to miss out on this amazing home. Schedule your viewing today! Don\'t wait!','0.1389','2','','','','','Mud,Sellers Disclosure','1','','','Baytown/Harris County','Central Gas','1','LT 18 BLK 3 HUNTERS CREEK SEC 1','Subdivision Lot','6050','Appraisal District','','480','0','','2','Gas Oven','0','','','Gas Range','','Composition','23 - Goose Creek Consolidated','STEPHEN F. AUSTIN ELEMENTARY SCHOOL (GOOSE CREEK)','STERLING HIGH SCHOOL (GOOSE CREEK)','GENTRY JUNIOR HIGH SCHOOL','Accompany,Appointment Required,Lockbox Front,Supra Keybox,Vacant/Unoccupied','Appraisal District','1','Contemporary/Modern','Hunters Crk Sec 01','7461','3.63','Public Sewer,Public Water,Water District','2011','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212412385','1663709542','212412385','2022-09-12T00:52:47.890','13288305','Sylvia Estrada','HomeSmart','','','29.884984','-95.366374','50','77093','3','350000.00','Active','Hartwick','1405','Road','Houston','1','1','3','2408','Single-Family','LOCATION! Great investment opportunity to own this home that sits on an acre of UNRESTRICTED land. Lots of potential, property is located with both residential and commercial businesses on the same street. Conveniently located off Hardy Toll Road, south of Beltway 8, and north of 610 Loop. Being sold \"AS IS\" WHERE IS- No Repairs. Per Seller never flooded while he has owned the property.','1.0582','34','','','','','Sellers Disclosure','','Wood Burning Fireplace','1','Northside','Central Gas','0','TRS 14 & 15B VIRGINIA ACRES','Subdivision Lot','46096','Appraisal District','','','0','','0','','0','','','Gas Cooktop','','Composition','27 - Houston','BARRICK ELEMENTARY SCHOOL','SAM HOUSTON MATH SCIENCE AND TECHNOLOGY CENTER','PATRICK HENRY MIDDLE SCHOOL','Accompany,Appointment Required,Lockbox Front,Supra Keybox','Appraisal District','1','Traditional','Virginia Acres','4596','1.9741','Septic Tank,Well','1950','Appraisal District'); --> New record created successfully