Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-11T21:43:55.103' ,`MLSNumber` = '35681459' ,`ListAgentFullName` = 'Marcus Williams' ,`ListOfficeName` = 'Keller Williams Hou Preferred' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.561708' ,`Longitude` = '-95.367025' ,`PhotoCount` = '50' ,`PostalCode` = '77584' ,`RoomCount` = '11' ,`ListPrice` = '465000.00' ,`Status` = 'Active' ,`StreetName` = 'Sunfish' ,`StreetNumber` = '2615' ,`StreetSuffix` = 'Drive' ,`City` = 'Pearland' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3382' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning all brick two-story with four spacious bedrooms and 3 ½ baths in the highly desired Sunrise Lakes subdivision! The home of your dreams is a one owner property that has been well maintained that features a very spacious open floor plan with lake views from multiple rooms, and access from the backyard. The outside features are the property comes with an extended patio and, an abundant amount of off-street parking. \r\n\r\nZoned to Dawson High School. Schedule your appointment today.....' ,`Acres` = '0.2066' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SUNRISE LAKES SEC 1 (A0721) (PEARLAND) BLK 5 LOT 7' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '8999' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '42 - Pearland' ,`SchoolElementary` = 'CHALLENGER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GLENDA DAWSON HIGH SCHOOL' ,`SchoolMiddle` = 'BERRY MILLER JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sunrise Lakes Sec 1' ,`TaxAmount` = '9370' ,`TaxRate` = '2.8851' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668294599' WHERE `Matrix_Unique_ID` = '210388016' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-11T21:32:33.390' ,`MLSNumber` = '27231597' ,`ListAgentFullName` = 'Gayla Gayden' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.702043' ,`Longitude` = '-95.706274' ,`PhotoCount` = '25' ,`PostalCode` = '77407' ,`RoomCount` = '11' ,`ListPrice` = '324990.00' ,`Status` = 'Active' ,`StreetName` = 'Telford Hollow' ,`StreetNumber` = '6923' ,`StreetSuffix` = 'Trail' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1717' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New One story Ranch Style home- by D.R. Horton! Completed!! Beautiful Vinyl Wood Large Plank Flooring throughout the high traffic areas, Tile in all Wet Areas & Luxurious Carpeting in Bedrooms! The Casual Dining Room & Family Room flows gracefully into the Gourmet Kitchen! Gourmet Kitchen is a Chef\'s dream with Upgraded Quartz Counters, Tile Back-splash, Large Eat-in Working Island with Under-mount Stainless Sink, Drinking Water Filtration System, Stainless Steel Appliances, Tall Shaker Cabinets & more! Primary Private Suite with Luxurious Bathroom/Spa featuring Double Sink Vanity, Massive Shower with Seamless Glass Door, Walk-in Closet! 3 Guest Bedrooms & 1 Full Bath! Covered Patio! LOW Utility Cost with the outstanding Energy Features including: HERS Energy Rated, Tankless/On-Demand H2O Heater, 2 USB outlets & \"Smart Home Automation\" Control your home from anywhere w/Echo & Dot! NO FLOODING! Amenities include: Pool, & Splash Pad! Just 20 minutes to The Galleria! Soon Updated Photos' ,`Acres` = '' ,`Area` = '37' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Mission Bend Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lakeview Retreat Lot: 27/Block: 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '850' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'SEGUIN ELEMENTARY (FORT BEND)' ,`SchoolHigh` = 'BUSH HIGH SCHOOL' ,`SchoolMiddle` = 'CROCKETT MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Leave Business Card,No Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Ranch' ,`Subdivision` = 'Lakeview Retreat' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668294599' WHERE `Matrix_Unique_ID` = '210399110' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-11T22:46:19.807' ,`MLSNumber` = '65368463' ,`ListAgentFullName` = 'Michael Sproba' ,`ListOfficeName` = 'Synergy Real Estate' ,`SellingAgentFullName` = 'Claire Warren' ,`SellingOfficeName` = 'BHGRE Gary Greene' ,`Latitude` = '30.425472' ,`Longitude` = '-95.632054' ,`PhotoCount` = '50' ,`PostalCode` = '77356' ,`RoomCount` = '15' ,`ListPrice` = '624900.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Bent Tree' ,`StreetNumber` = '153' ,`StreetSuffix` = 'Lane' ,`City` = 'Montgomery' ,`BathsFull` = '3' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '4147' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Texas living with a Mediterranean flair. At just a 7 minute walk to the Bentwater Club House, this property truly boasts resort style living. Lot next door is available for purchase. NEW ROOF. Head inside to find living area complete with stunning windows and grand entertainment center. This kitchen features ornate cabinetry, ample counter and cabinet space, large island, gas range, breakfast bar and butler\'s pantry. Downstairs you will find a guest suite complete with an attached bath and sizable closet. Primary suite is complete with jetted tub, double sinks, and walk-in shower with double rainfall shower heads. Primary closet is a show-stopper with ample storage room. Upstairs you will find a theater room with surround-sound and 2 additional bedrooms. WHOLE HOUSE GENERATOR. Your backyard is sure to wow with pergola, outdoor fireplace, kitchen and water feature. Pool heater can turn the pool into a giant hot tub! You don\'t want to miss this one - come see it today!' ,`Acres` = '0.2506' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'BENTWATER 19, BLOCK 1, LOT 5' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot' ,`LotSize` = '10914' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '187' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'LINCOLN ELEMENTARY SCHOOL (MONTGOMERY)' ,`SchoolHigh` = 'MONTGOMERY HIGH SCHOOL' ,`SchoolMiddle` = 'MONTGOMERY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Bentwater' ,`TaxAmount` = '10246' ,`TaxRate` = '2.1142' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668294600' WHERE `Matrix_Unique_ID` = '210512844' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-11T21:37:19.250' ,`MLSNumber` = '12522287' ,`ListAgentFullName` = 'Tracy Ostrofsky-King' ,`ListOfficeName` = 'Century 21 Top Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.688950' ,`Longitude` = '-95.767341' ,`PhotoCount` = '30' ,`PostalCode` = '77407' ,`RoomCount` = '6' ,`ListPrice` = '310000.00' ,`Status` = 'Active' ,`StreetName` = 'Misty Morning' ,`StreetNumber` = '6803' ,`StreetSuffix` = 'Trace' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1858' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Truly exceptional, this open floor plan features a charming, light and uplifting interior and contains a generously sized living area and formal dining room. Fall in love with this recently updated kitchen, equipped with granite countertops and a spacious pantry. Enjoy the enormous backyard that comes complete with a large patio and plenty of space to add a custom pool. Ideally located in the sought after Meadows Of Parkway Lakes neighborhood, this one will go fast!' ,`Acres` = '0.2868' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'MEADOWS OF PARKWAY LAKES SEC 1, BLOCK 1, LOT 22' ,`LotDesciption` = 'Corner,Cul-De-Sac,Subdivision Lot' ,`LotSize` = '12492' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '765' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'HUBENAK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FOSTER HIGH SCHOOL' ,`SchoolMiddle` = 'WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Meadows Of Pkwy Lakes Sec 1' ,`TaxAmount` = '5682' ,`TaxRate` = '2.7615' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668294600' WHERE `Matrix_Unique_ID` = '211364110' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-11T22:23:24.380' ,`MLSNumber` = '90479856' ,`ListAgentFullName` = 'Jane Draughon' ,`ListOfficeName` = 'RE/MAX The Woodlands & Spring' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.147366' ,`Longitude` = '-95.478713' ,`PhotoCount` = '40' ,`PostalCode` = '77380' ,`RoomCount` = '10' ,`ListPrice` = '725000.00' ,`Status` = 'Active' ,`StreetName` = 'Timberwagon' ,`StreetNumber` = '10712' ,`StreetSuffix` = 'Circle' ,`City` = 'The Woodlands' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3887' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Unique updated French style home in the heart of The Woodlands. Exquisite finishes and architectural details throughout with beautiful double iron front doors. The raised grand entry descends to the family room, featuring a spectacular fireplace which extends to the ceiling, surrounded by tall, elegant arched windows. The home features double pane energy efficient Anderson windows throughout, gorgeous updated hardwood floors, and a huge workshop w/ A/C. The lifetime Mansard roof shakes, metal stair balusters, stainless steel appliances, custom cabinets and granite kitchen and bath countertops are a few of the upgrades. Game room could also be 2nd primary ensuite bedroom. The remodeled primary bath has a huge walk-in shower, custom cabinets with quartz countertops, and new fixtures, toilet & lighting. The downstairs primary bedroom, with it\'s own cozy fireplace, has a gorgeous view of the huge, picturesque backyard oasis with multi-level decking for relaxing under the canopy of trees.' ,`Acres` = '0.4886' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Gas,Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'WDLNDS VIL GROGANS ML 06, BLOCK 6, LOT 20' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot,Wooded' ,`LotSize` = '21283' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Aluminum,Other' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'SAM HAILEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'THE WOODLANDS COLLEGE PARK HIGH SCHOOL' ,`SchoolMiddle` = 'KNOX JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'French' ,`Subdivision` = 'Wdlnds Village Grogans Ml 06' ,`TaxAmount` = '7924' ,`TaxRate` = '2.0469' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668294600' WHERE `Matrix_Unique_ID` = '211414642' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-11T21:46:47.260' ,`MLSNumber` = '31153677' ,`ListAgentFullName` = 'Jennifer Maxwell' ,`ListOfficeName` = 'Jane Byrd Properties INTL.' ,`SellingAgentFullName` = 'Charity Burkland' ,`SellingOfficeName` = 'Allegiance Realty Assoc., LLC' ,`Latitude` = '29.519689' ,`Longitude` = '-95.039575' ,`PhotoCount` = '42' ,`PostalCode` = '77573' ,`RoomCount` = '14' ,`ListPrice` = '374000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'White Sands' ,`StreetNumber` = '3208' ,`StreetSuffix` = 'Way' ,`City` = 'League City' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2414' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great single story with wonderful floor plan, 4 bedrooms, 2.5 bathrooms, formal dining room, and office with double doors, many upgrades in the last two years. South Shore location, low tax rate, not in a flood zone, and CCISD schools. Great location in a golf course community and close to Kemah and 25 minutes to Galveston. \r\nThe screened porch is such a wonderful place to enjoy time with family and friends. The family room focal point is the fireplace with new custom surround and shelving, open to kitchen. This home has vaulted ceilings and plenty of natural light. Split floorplan offers privacy for the main bedroom, with secondary bedrooms off back hallway.\r\nThe large bright open kitchen with vaulted ceilings and breakfast nook is perfect place to entertain. This is a warm and inviting home, come see today.' ,`Acres` = '0.1698' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 18 SOUTH SHORE VILLAGE SEC 6 (98), BLOCK 1, LOT 4, ACRE' ,`LotDesciption` = 'Other' ,`LotSize` = '7396' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '465' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'HYDE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'LEAGUECITY INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'South Shore Village Sec 6 98' ,`TaxAmount` = '6582' ,`TaxRate` = '2.0697' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1668294600' WHERE `Matrix_Unique_ID` = '211808940' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-11T21:23:18.467' ,`MLSNumber` = '45951982' ,`ListAgentFullName` = 'Heather Niemeyer' ,`ListOfficeName` = 'Camelot Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.806090' ,`Longitude` = '-95.575151' ,`PhotoCount` = '23' ,`PostalCode` = '77043' ,`RoomCount` = '11' ,`ListPrice` = '399000.00' ,`Status` = 'Active' ,`StreetName` = 'Sherwood Forest' ,`StreetNumber` = '2069' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1876' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to a coveted neighborhood of sought after Spring Branch! This lovely single family residence has been meticulously maintained with many updates since it was built in 2019. Brand new hard wood floors installed. Fresh landscaping completed with raised, double layered sod, hedges, rocks and flat stones! Shutters and new hardware installed through out the entire home! New cabinetry added within the utility room. Fresh paint through out. New irrigation system installed. Some fixtures are new as well! Location is prime being that you’ll have quick access to i10 and the beltway. With City Centre, Energy Corridor, downtown Houston and more just minutes away! Schedule a tour today!' ,`Acres` = '0.0464' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 11 BLK 1 BEYOND METRONOME' ,`LotDesciption` = 'Patio Lot' ,`LotSize` = '2021' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '670' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'SHERWOOD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING WOODS HIGH SCHOOL' ,`SchoolMiddle` = 'SPRING OAKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Photos/No Videos,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Beyond Metronome' ,`TaxAmount` = '8243' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668294601' WHERE `Matrix_Unique_ID` = '211963480' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-11T21:07:13.633' ,`MLSNumber` = '54339785' ,`ListAgentFullName` = 'Krystyna Fennelly' ,`ListOfficeName` = 'Bay Area Elite Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.499711' ,`Longitude` = '-94.935033' ,`PhotoCount` = '30' ,`PostalCode` = '77539' ,`RoomCount` = '0' ,`ListPrice` = '428500.00' ,`Status` = 'Active' ,`StreetName` = 'Port' ,`StreetNumber` = '131' ,`StreetSuffix` = 'Street' ,`City` = 'San Leon' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2635' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Grab your coffee and head out on your deck to catch the morning sunrise! This stunning Mediterranean style waterfront home sits in San Leon\'s gated community of Mariner\'s Cove. You’re welcomed by a lovely spiral staircase with New carpet and Fresh paint. Entry splits two garages and features window to one garage where you can showcase your favorite vehicle. Bottom floor features game room with kitchenette, laundry and full bathroom. Second level offers kitchen with double oven, built-in cooktop and custom cabinetry overlooking the large family room with vaulted ceiling and wood-burning fireplace, and adjoining dining room. Stunning views from all rooms on rear of home and balconies from every bedroom, front balconies also offer bay views. Spend your evening fishing off your bulkhead in the backyard, nothing like the taste of a fresh catch! Community offers clubhouse, pool and pier and hosts gatherings throughout the year.' ,`Acres` = '0.17' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Bacliff/San Leon' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 10 PAGE 2 MARINER\'S COVE SEC 1 (98), LOT 14, ACRES 0.17' ,`LotDesciption` = 'Cul-De-Sac,Water View,Waterfront' ,`LotSize` = '7405' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2280' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'SAN LEON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'JOHN AND SHAMARION BARBER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Mariners Cove Sec 1 98' ,`TaxAmount` = '7945' ,`TaxRate` = '2.521' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1991' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668294601' WHERE `Matrix_Unique_ID` = '212214410' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-11T21:06:44.650' ,`MLSNumber` = '12865191' ,`ListAgentFullName` = 'Kristi Johanson' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.562493' ,`Longitude` = '-95.267232' ,`PhotoCount` = '19' ,`PostalCode` = '77581' ,`RoomCount` = '5' ,`ListPrice` = '345000.00' ,`Status` = 'Active' ,`StreetName` = 'Lee Circle' ,`StreetNumber` = '3105' ,`StreetSuffix` = 'Court' ,`City` = 'Pearland' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1821' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stylish finishes and thoughtful design are displayed in this outstanding home. Nestled on a generously proportioned cul-de-sac lot, this wonderful home is ready for your most discerning buyers. This handsome two story features a spacious primary retreat w/ensuite bath on the second floor with his and her closets. Additionally upstairs you\'ll find a game-room with balcony, two bedrooms, and another full bathroom to complete the second story. In the heart of the home, is an open-concept kitchen w/large peninsula-island, dining area, light-filled family room, half bathroom down stairs suitable for guests. The ideal setting is perfect for outdoor entertaining with a covered patio & plenty of green space.This fabulous location is close to a multitude of dining options, shopping, and entertainment nearby. Low tax rate, great schools and gently lived in. New carpet and tile floors, new paint and all fixtures. An absolute gem & must see!' ,`Acres` = '0.1617' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ALEXANDER LANDING SEC 4 (A0198 T J GREEN)(PEARLAND) BLK 2 LO' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '7044' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '0' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '42 - Pearland' ,`SchoolElementary` = 'C J HARRIS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PEARLAND HIGH SCHOOL' ,`SchoolMiddle` = 'PEARLAND JUNIOR HIGH EAST' ,`ShowInstructions` = 'Leave Business Card,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Alexander Landing Sec 4' ,`TaxAmount` = '4482' ,`TaxRate` = '2.5552' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1984' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668294601' WHERE `Matrix_Unique_ID` = '212341359' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-11T21:37:57.360' ,`MLSNumber` = '5817162' ,`ListAgentFullName` = 'Cindey Edwards' ,`ListOfficeName` = 'Southern Star Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.041089' ,`Longitude` = '-95.526579' ,`PhotoCount` = '50' ,`PostalCode` = '77379' ,`RoomCount` = '12' ,`ListPrice` = '475000.00' ,`Status` = 'Active' ,`StreetName` = 'River Rapids' ,`StreetNumber` = '7030' ,`StreetSuffix` = 'Lane' ,`City` = 'Spring' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4647' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'As the seller\'s have moved out, envision your moving into new beginnings with everything you can imagine & room enough for anything your heart desires! 5 Bedrooms, 3.5 Baths, Formal Living & Dining, French Doors leading into Study & out to front patio!!! Game room!!! Mediaroom!!! Lakes & walking trails! Amenity Center with kid galore activities! So much to offer you! See that Rainbow across the front of the home!!! Must See to make your own!!! Don’t Delay, Call Today! Get your Keys right away!!!' ,`Acres` = '0.1797' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 20 BLK 2 TWIN FALLS SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7829' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'KUEHNLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN HIGH SCHOOL' ,`SchoolMiddle` = 'KRIMMEL INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Twin Falls Sec 5' ,`TaxAmount` = '9639' ,`TaxRate` = '2.5085' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668294601' WHERE `Matrix_Unique_ID` = '212651364' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-11T22:46:02.290' ,`MLSNumber` = '24233394' ,`ListAgentFullName` = 'Heather Groom' ,`ListOfficeName` = 'Doug Erdy Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.096038' ,`Longitude` = '-95.259520' ,`PhotoCount` = '30' ,`PostalCode` = '77365' ,`RoomCount` = '10' ,`ListPrice` = '464999.00' ,`Status` = 'Active' ,`StreetName` = 'Enloe Rd' ,`StreetNumber` = '24274' ,`StreetSuffix` = 'Drive' ,`City` = 'Porter' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1620' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Looking for solitude? Looking for a place to call home? Look no further! This 3-bedroom 2 bath home sits on 4.372 acres 35 mins from Downtown Houston. Enjoy living on acreage but the convenience of the city! Not a part of this home goes unnoticed, start with the custom-built iron door, new wood flooring, updated bathrooms, modern fixtures, a flex room to be used as your office or craft room, or let me not forget the large building in the back yard! Come enjoy a cup of coffee on the front porch, bring your animals, run your business! The possibilities are endless!' ,`Acres` = '4.372' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Porter/New Caney West' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'A0393-MCFADDENSARAH,TRACT 2A-9,ACRES4.372' ,`LotDesciption` = 'Cleared,Wooded' ,`LotSize` = '190444' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'BENS BRANCH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PORTER HIGH SCHOOL (NEW CANEY)' ,`SchoolMiddle` = 'WHITE OAK MIDDLE SCHOOL (NEW CANEY)' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'SARAH MCFADDEN' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1996' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668294601' WHERE `Matrix_Unique_ID` = '213199776' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-11T21:22:00.983' ,`MLSNumber` = '958345' ,`ListAgentFullName` = 'Kristi Johanson' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.498648' ,`Longitude` = '-95.196929' ,`PhotoCount` = '18' ,`PostalCode` = '77546' ,`RoomCount` = '6' ,`ListPrice` = '524000.00' ,`Status` = 'Active' ,`StreetName` = 'Brill' ,`StreetNumber` = '1704' ,`StreetSuffix` = 'Drive' ,`City` = 'Friendswood' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2588' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Luxurious elegance in this single-story home in the quaint and quiet Keystone neighborhood in Friendswood ISD! Almost Every detail in this 4 bedroom home has been updated or replaced! Including updated Kitchen, and bathrooms, and beautiful new luxury vinyl flooring all over and brand new carpet in bedrooms only. Fine finishes in this spacious design include a charming wood-burning fireplace in the sunlit family room, high ceilings with designer lighting, an elegant dining room, an impressive island kitchen with quartz countertops, & stainless appliances including double ovens, and a breakfast room over looking the lush landscaping of the back yard. Escape to the primary suite to find a deep soaking tub, a walk-in shower, and two generous walk-in closets. Outdoors, enjoy extensive decking overlooking the lush, fenced yard. Don\'t miss your chance to call this one home...' ,`Acres` = '0.2686' ,`Area` = '33' ,`BuilderName` = 'Ryland Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Friendswood' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 151 PAGE 8 LOT 27 BLK 1 KEYSTONE MEADOWS' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11700' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '20 - Friendswood' ,`SchoolElementary` = 'CLINE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FRIENDSWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'FRIENDSWOOD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Keystone Meadows 91' ,`TaxAmount` = '6658' ,`TaxRate` = '2.2832' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1991' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668294602' WHERE `Matrix_Unique_ID` = '213203445' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-11T21:14:12.030' ,`MLSNumber` = '41793281' ,`ListAgentFullName` = 'Andres Jones' ,`ListOfficeName` = 'JPAR-The Sears Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.693991' ,`Longitude` = '-95.796804' ,`PhotoCount` = '50' ,`PostalCode` = '77406' ,`RoomCount` = '7' ,`ListPrice` = '449900.00' ,`Status` = 'Active' ,`StreetName` = 'Bludana' ,`StreetNumber` = '24327' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2692' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning Ashton Woods Single Story home on Premium Corner Homesite! 4 Bedrooms including Mother-In-Law Suite, Huge Primary Bedroom PLUS a Primary Bathroom With Dual Vanities and Separate Tub and Shower. Spacious Study. Soaring 12 ft Ceilings, Upgraded Vinyl Plank Flooring Throughout Most of The Home, Highly Sought After White Cabinets and Silestone Countertops, Reverse Osmosis, Custom Backsplash, and Premium Whirlpool Stainless Steel Kitchen Appliances. Tremendous Island Perfect for Preparing and Entertaining All Open To Your Great Room. Gorgeous Silestone in Bathrooms, Oversized Primary Walk-in Closet. Covered Back Patio With a Jacuzzi Tub, Full Sprinkler System, and Super Clean Garage with Epoxy Coating and Cabinets. House Has Plumbing Set Up For a Water Softener. Call Today For Your Private Tour!' ,`Acres` = '0.1842' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LAKES OF BELLA TERRA WEST SEC 1, BLOCK 3, LOT 29' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8025' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '925' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'HUBENAK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakes Of Bella Terra West Sec 1' ,`TaxAmount` = '10461' ,`TaxRate` = '3.0848' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668294602' WHERE `Matrix_Unique_ID` = '213459065' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-11T21:05:16.450' ,`MLSNumber` = '54771873' ,`ListAgentFullName` = 'MeiMei JamesOu' ,`ListOfficeName` = 'RE/MAX Fine Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.712831' ,`Longitude` = '-95.823760' ,`PhotoCount` = '49' ,`PostalCode` = '77494' ,`RoomCount` = '13' ,`ListPrice` = '1380000.00' ,`Status` = 'Active' ,`StreetName` = 'Prescott Glen' ,`StreetNumber` = '10410' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '5' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '5101' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Absolutely gorgeous custom home offers a SPARKLING POOL & OUTDOOR KITCHEN With wet bar, situated on a large lot in desirable GATED community RESERVE@SPRING LAKE. Spectacular front elevation, impressive double door leads to a grand foyer with high ceilings, it is elegant & welcoming. Excellent floor plan, Many features, upgrades & updates. quality construction with attention to details. Elegant arches, tray ceilings, crown moldings & high ceilings throughout. amazing island kitchen, wood floor in the entire home except Media room &tiles in wet areas, wine cellar with iron door & cooler, two bedrooms down with 2 full bathrooms & half bath, one of the bathroom by backdoor can use as a pool bathroom. two kitchens, 4 car garages with extra big space, new interior paint & new paint in kitchen & master, new pool pump & computer control panel board. large balcony with beautiful view of pool/backyard. Big two story cover patio area, Shows beautifully like a model home. Come to see today!' ,`Acres` = '0.3535' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'CINCO RANCH SOUTHWEST SEC 21, BLOCK 4, LOT 10' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '15400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1795' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'STANLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SEVEN LAKES HIGH SCHOOL' ,`SchoolMiddle` = 'SEVEN LAKES JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Mediterranean' ,`Subdivision` = 'Cinco Ranch Southwest Sec 21' ,`TaxAmount` = '25792' ,`TaxRate` = '2.7045' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2011' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668294602' WHERE `Matrix_Unique_ID` = '213468542' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-11T21:38:18.920' ,`MLSNumber` = '2359028' ,`ListAgentFullName` = 'Linda Tello' ,`ListOfficeName` = 'Berkshire Hathaway HomeServicePremier Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.804380' ,`Longitude` = '-95.385384' ,`PhotoCount` = '39' ,`PostalCode` = '77009' ,`RoomCount` = '10' ,`ListPrice` = '1100000.00' ,`Status` = 'Active' ,`StreetName` = 'Robbie' ,`StreetNumber` = '1021' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3280' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This Charming and impressive custom built home located in the sought out Sunset Heights, offers a downstairs living, private driveway and private backyard! No HOA! The family room offers a custom fireplace, and abundance of natural light with automatic blinds, stunning wood floors and high ceilings through out the entire home. The kitchen offers beautiful quarts countertops, high end appliances (Thermador) lots of counter space, cabinets and more storage. Spa like master suite bathroom with Hollywood bath with marble as well as separate shower with delightful spacious walk in closets. 2nd Floor offers spacious split level bedrooms, two full baths, media room and utility room. Private and low maintenance backyard provides for ample relaxation and enjoyment. Zone to highly acclaimed schools and easy access to the city. No Flooding issues!' ,`Acres` = '0.1033' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Corporate Listing,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TR 5 BLK 10 STUDES SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'FIELD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Studes Add Sec 01' ,`TaxAmount` = '19419' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668294602' WHERE `Matrix_Unique_ID` = '213557657' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-11T21:12:36.390' ,`MLSNumber` = '61823636' ,`ListAgentFullName` = 'Stacy Johnson' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.834226' ,`Longitude` = '-95.749913' ,`PhotoCount` = '14' ,`PostalCode` = '77449' ,`RoomCount` = '8' ,`ListPrice` = '340000.00' ,`Status` = 'Active' ,`StreetName` = 'Boundary Peak' ,`StreetNumber` = '21602' ,`StreetSuffix` = 'Way' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2732' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to your home in the well desired KISD school district! This beautiful home offers 2 stories, 4 bedrooms and 2.5 bathrooms with an abundance of natural light throughout. Upon entry, you are greeted by the den (which could be used as office space) and a formal dining room. As you continue towards the back of the home you enter the kitchen, which has quite a bit of cabinetry, a separate pantry and there is plenty of space for a breakfast table. The kitchen looks into the oversized living room where you can enjoy your gas fireplace. As you head upstairs you walk into the game room/entertainment/or office area. All bedrooms are upstairs. The primary bedroom has 2 large walk in closets! This home offers phenomenal entertaining and dining space throughout, brand new carpet installed upstairs, prewired for surround sound and an oversized backyard covered patio! Solar panels were recently installed on the home so you will get all the benefits of saving $.' ,`Acres` = '0.1313' ,`Area` = '25' ,`BuilderName` = 'Ryland' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 25 BLK 3 MASON LAKES SEC 1 AMEND' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5720' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '420' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'GOLBOW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'MCDONALD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Mason Lakes Sec 01 Amd' ,`TaxAmount` = '6870' ,`TaxRate` = '2.7857' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668294603' WHERE `Matrix_Unique_ID` = '213570632' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-11T21:32:39.800' ,`MLSNumber` = '91734764' ,`ListAgentFullName` = 'Aldo Di Vece' ,`ListOfficeName` = 'Beth Wolff, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.652110' ,`Longitude` = '-95.628830' ,`PhotoCount` = '33' ,`PostalCode` = '77498' ,`RoomCount` = '9' ,`ListPrice` = '939000.00' ,`Status` = 'Active' ,`StreetName` = 'Skyview' ,`StreetNumber` = '13821' ,`StreetSuffix` = 'Drive' ,`City` = 'Sugar Land' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2033' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Rare opportunity to own nearly 2 acres just minutes from all the Sugar Land and Houston amenities. Lush landscaping across the grounds enhances the 1980s home plus full size barn, 4-car air conditioned garage, and additional pavilion/carport. A sparkling pool surrounded by tropical flora provides a private oasis. This multipurpose property offers the ability to live and work from home such as running an urban farm raising chickens, bees, etc. or growing organic vegetables and flowers. The variety of outbuildings would also serve the production of small-batch products such as soap or candles. With numerous additional options for conversion, the flexibility and scale of this property in its premier location is a must see!' ,`Acres` = '1.9' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land North' ,`HeatSystem` = 'Central Electric,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'SKYVIEW FARMS, LOT 20, ACRES 1.9' ,`LotDesciption` = 'Wooded' ,`LotSize` = '82764' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'BARRINGTON PLACE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KEMPNER HIGH SCHOOL' ,`SchoolMiddle` = 'SUGAR LAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Skyview Farms' ,`TaxAmount` = '4364' ,`TaxRate` = '1.6629' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668294603' WHERE `Matrix_Unique_ID` = '213624601' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-11T22:20:11.367' ,`MLSNumber` = '91503318' ,`ListAgentFullName` = 'Debra Shelly' ,`ListOfficeName` = 'Westchase Realty Services' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.595340' ,`Longitude` = '-95.501030' ,`PhotoCount` = '29' ,`PostalCode` = '77489' ,`RoomCount` = '5' ,`ListPrice` = '219900.00' ,`Status` = 'Active' ,`StreetName` = 'Gatebriar' ,`StreetNumber` = '15838' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1246' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Single family property; NOT a duplex, with large bedrooms and upgraded bathrooms and no carpeting. Master bedroom has his and her closets and remodeled bathroom with new tile, bathtub and sink. Master bedroom designer ceramic flooring. Secondary bedroom has a large walk in closet. Another bedroom can be added to the secondary bedroom. Secondary bathroom has new bathtub, tile and sink. Kitchen has all electrical appliances, new tiled floors and new stove. Kitchen has ample space for cooking. All plumbing replaced with PEX pipes per Seller. New garage door installed. Beautiful front and back yards. No MUD taxes.' ,`Acres` = '0.1566' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'BRIARGATE SEC 8, BLOCK 11, LOT 10' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6820' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '150' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'BRIARGATE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLOWRIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'MCAULIFFE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Briargate Sec 8' ,`TaxAmount` = '3071' ,`TaxRate` = '2.2137' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1981' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668294603' WHERE `Matrix_Unique_ID` = '213800813' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-11T21:40:21.187' ,`MLSNumber` = '17134782' ,`ListAgentFullName` = 'Christina Conn' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.674828' ,`Longitude` = '-95.759651' ,`PhotoCount` = '44' ,`PostalCode` = '77406' ,`RoomCount` = '8' ,`ListPrice` = '395000.00' ,`Status` = 'Active' ,`StreetName` = 'Prairie Crest' ,`StreetNumber` = '21507' ,`StreetSuffix` = 'Drive' ,`City` = 'Richmond' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2448' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This is it! Fantastic 1.5 story in coveted Long Meadow Farms. So many upgrades! Whole house generator! Roof 2020. First huge master bedroom, 2 guest rooms and study all down stairs. Split plan. One room up...second master bedroom or game room. Open flowing floor plan w/ vaulted ceiling. Huge kitchen opens to the dining room and extra large family room. No carpet on first floor. Granite in kitchen and all baths. Crown molding, mini blinds and ceiling fans throughout. Covered and screened in back porch with and additional extended porch and pergola. Sprinkler system, osmosis filter system, water softener, TAEX pest control system and built in speakers. Excellent schools. Be sure to read all of the features and upgrades under the pictures! NO FLOODING.\r\nClose to dining, retail and entertainment. Easy access to 59,99 and 1093.' ,`Acres` = '0.1362' ,`Area` = '37' ,`BuilderName` = 'Ryland' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LONG MEADOW FARMS SEC 16, BLOCK 2, LOT 11' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5935' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '815' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'ADOLPHUS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FOSTER HIGH SCHOOL' ,`SchoolMiddle` = 'WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Back,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Long Meadow Farms Sec 16' ,`TaxAmount` = '6035' ,`TaxRate` = '2.5248' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2011' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668294603' WHERE `Matrix_Unique_ID` = '213852105' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-11T21:41:04.040' ,`MLSNumber` = '22956639' ,`ListAgentFullName` = 'Melanie Foreman' ,`ListOfficeName` = 'Lake Houston Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.106958' ,`Longitude` = '-95.113070' ,`PhotoCount` = '37' ,`PostalCode` = '77336' ,`RoomCount` = '7' ,`ListPrice` = '295000.00' ,`Status` = 'Active' ,`StreetName` = 'Blue Lake' ,`StreetNumber` = '31' ,`StreetSuffix` = 'Drive' ,`City` = 'Huffman' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1196' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming 3/2/2 one story on 1 3/4 acres! Large covered back porch with outdoor kitchen overlooks the huge back yard with in-ground pool. Plenty of room for your pets or farm animals! Living room with cathedral ceiling expands into the dining area with an open view to the beautiful grounds. The kitchen features solid wood cabinets, granite counters and stainless appliances with refrigerator included. Great curb appeal with wrought iron fence and automatic driveway gate. 2 car garage, RV cover, storage/well house, and additional storage building. Great neighborhood with few restrictions and very low HOA fee! No high water bills with your own water well. This is a great primary residence or a relaxing weekend retreat. Call today for your private showing!' ,`Acres` = '1.45' ,`Area` = '32' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Huffman Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'TR 1B BLK 1 CYPRESS POINT SEC 1 U/R ABST 165 E BENSON' ,`LotDesciption` = 'Cleared,Wooded' ,`LotSize` = '63162' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '50' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '28 - Huffman' ,`SchoolElementary` = 'FALCON RIDGE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HARGRAVE HIGH SCHOOL' ,`SchoolMiddle` = 'HUFFMAN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Left Side,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cypress Point' ,`TaxAmount` = '3911' ,`TaxRate` = '2.0083' ,`WaterSewer` = 'Aerobic,Well' ,`YearBuilt` = '1984' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668294603' WHERE `Matrix_Unique_ID` = '213908887' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-11T21:27:05.953' ,`MLSNumber` = '53014013' ,`ListAgentFullName` = 'Jannett Flores' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.172246' ,`Longitude` = '-94.994103' ,`PhotoCount` = '34' ,`PostalCode` = '77554' ,`RoomCount` = '7' ,`ListPrice` = '725000.00' ,`Status` = 'Active' ,`StreetName` = 'Shaman' ,`StreetNumber` = '18115' ,`StreetSuffix` = 'Drive' ,`City` = 'Galveston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2010' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great opportunity in Galveston! Whether you’re looking for an investment opportunity, great weekend getaway or quiet place to live, this fully furnished 4/2 beach house in Indian Beach Subdivision is the place for you. It’s open concept kitchen/dining/living room & breakfast bar with seating for 6 is great for entertaining. It has high vaulted ceilings, crown molding, engineered wood flooring, granite counters & stainless-steel appliances. Home sits on almost 1/2 an acre with lush tropical landscaping, fully fenced yard, palapa, Jacuzzi tub & great views of the beach & bay from private covered porch off the master bedroom. It sleeps 14 & is a short walk/golf cart ride to the beach, community pool, tennis court & fishing pier. Currently in Ryson Vacation Rental program as \"Beach Retreat\"; 2020 Gross Rental Income=$49,034, 2021 GRI=$58,775 and as of 10/19/22 GRI has been $44,900. Home is ready for you to enjoy island life to the fullest and ready to entertain! All furniture included' ,`Acres` = '0.483' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West End' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 121 HALL & JONES SUR LOT 16 BLK 3 INDIAN BEACH SEC 3' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '21039' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '338' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Accompany,Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Indian Beach 3' ,`TaxAmount` = '8841' ,`TaxRate` = '2.0324' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668294604' WHERE `Matrix_Unique_ID` = '213980410' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-11T22:04:47.857' ,`MLSNumber` = '20229919' ,`ListAgentFullName` = 'Yolanda Williams' ,`ListOfficeName` = 'JPAR - The Sears Group' ,`SellingAgentFullName` = 'Ronald Cheng' ,`SellingOfficeName` = 'Teachout Real Estate Group' ,`Latitude` = '29.631862' ,`Longitude` = '-95.535175' ,`PhotoCount` = '45' ,`PostalCode` = '77489' ,`RoomCount` = '7' ,`ListPrice` = '348500.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Leslie' ,`StreetNumber` = '16215' ,`StreetSuffix` = 'Lane' ,`City` = 'Missouri City' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2787' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A MUST SEE!! Newly fully remolded beautiful (2019) 4 bedroom 2.5 bath home with a gorgeous POOL! Located in the cul-de-sac of the established community of COLONY CROSSING VILLAGE. \r\n\r\nThe home features: \r\n \r\n-Large open family space w/ fireplace, large windows and natural light\r\n-Prefect size kitchen with an island and breakfast area that overlook the pool and large backyard \r\n- Office space\r\n- Large dining area for family dinners and holiday gatherings\r\n- Game room \r\n- Overly sized primary bedroom and full bathroom\r\n- Generous sized secondary bedrooms\r\n- Outdoor in-ground pool with great backyard space for entertaining and grilling\r\n\r\n\r\nThis beauty won\'t last long! Come see it for yourself at our Open House | Saturday | 10/29/2022 | 12-2pm' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'COLONY CROSSING VILLAGE OF TALBOTS MILL SEC 2, BLOCK 1, LOT' ,`LotDesciption` = 'Corner,Cul-De-Sac' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '595' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'E A JONES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MARSHALL HIGH SCHOOL (FORT BEND)' ,`SchoolMiddle` = 'MISSOURI CITY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Colony Crossing Village' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1995' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668294604' WHERE `Matrix_Unique_ID` = '214101314' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-11T21:54:42.360' ,`MLSNumber` = '39610768' ,`ListAgentFullName` = 'Talha Hasan' ,`ListOfficeName` = 'Surge Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.041044' ,`Longitude` = '-95.795981' ,`PhotoCount` = '34' ,`PostalCode` = '77447' ,`RoomCount` = '7' ,`ListPrice` = '259900.00' ,`Status` = 'Active' ,`StreetName` = 'Falling Daylight' ,`StreetNumber` = '24011' ,`StreetSuffix` = 'Drive' ,`City` = 'Hockley' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1906' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'OPEN HOUSE: Sun Nov 13, 2PM-4PM! Welcome To This Newer Construction Home Located On A Cul-De-Sac Street! This Gorgeous Two Story Home Features 4 Bedrooms, 2.5 Bathrooms, 2 Car Garage, & Long Driveway! Foyer Entry To Open Concept Living/Dining Room, Luxury Vinyl Plank Flooring, Kitchen w/ 36\" Designer Cabinets, Freestanding Island Added (Not In Pics) & Quartz Countertops! Primary Owner\'s Suite Bedroom Located On First Floor With Large Walk-In Closet! Large Walk-In Laundry/Utility Room. Spacious Secondary Bedrooms on 2nd Floor! Beautiful Backyard With NO BACK NEIGHBORS! APPLIANCES INCLUDED: Refrigerator, Gas Range, Dishwasher, OTR Microwave! Home Is Energy Efficient w/ 16 SEER HVAC System, Double Pane Windows, & Recent AC Unit Tune-Up! Home Pre-Wired for AT&T Fiber. Great Location w/ Easy Access to 290, Grand Parkway 99, Zube Park, Cypress, Houston Premium Outlets, Costco, Restaurants and Shopping Centers!' ,`Acres` = '' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Owner/Agent' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hockley' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SEC 2 BLK 1 LOT 17' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '5080' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'EVELYN TURLINGTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'SCHULTZ JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Becker Meadows' ,`TaxAmount` = '' ,`TaxRate` = '3.6' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668294604' WHERE `Matrix_Unique_ID` = '214157876' --> 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','214210399','1668294604','214210399','2022-11-11T22:14:21.763','51373541','Janna Westerbeck','Way Maker Realty, LLC','','','29.189792','-95.417557','18','77515','4','214900.00','Active','Molina','1232','Court','Angleton','2','0','3','1348','Single-Family','Welcome Home to this three-bedroom, two bath home on a cul-de-sac street. The kitchen features granite countertops and all appliances. The primary bedroom has a large walk-in closet and vanity area next to the primary bathroom. Large back yard with a deck, storage shed and no back neighbors. No HOA and low taxes. Call today schedule your showing of this great property!','0.1653','5','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','Angleton','Central Gas','0','BROOKHOLLOW SEC II (ANGLETON) (318 T S LEE) LOT 25','Cul-De-Sac,Subdivision Lot','7200','Appraisal District','','','0','','2','Electric Oven','0','','','Electric Range','','Composition','5 - Angleton','NORTHSIDE ELEMENTARY SCHOOL (ANGLETON)','ANGLETON HIGH SCHOOL','ANGLETON MIDDLE SCHOOL','Appointment Required,Request Online Appointment,Supra Keybox','Appraisal District','1','Traditional','Brookhollow Sec II Angleton','4505','2.6102','Public Sewer,Public Water','1981','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-11T22:14:16.197' ,`MLSNumber` = '86891660' ,`ListAgentFullName` = 'Lucille Fendley' ,`ListOfficeName` = 'Greenwood King Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.776531' ,`Longitude` = '-95.540624' ,`PhotoCount` = '23' ,`PostalCode` = '77024' ,`RoomCount` = '11' ,`ListPrice` = '1098000.00' ,`Status` = 'Active' ,`StreetName` = 'Pinerock' ,`StreetNumber` = '12111' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2253' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Sought-after one story with pool & guest quarters tucked on quiet cul-de-sac in Memorial Woods! Formal dining + study, kitchen with granite and stainless steel appliances opens to breakfast and family rm. Family rm with wall of built-ins, wood burning fireplace and two sets of French doors to large patio and sparkling pool! Primary bedroom offers walk-in closet, updated en-suite bath w/ separate shower and tub. Three secondary bedrooms plus second bath with private wet area. Abundant storage throughout! Converted garage offers the perfect gameroom, private home office or quarters w/ full bath. Fresh interior paint 10/22! Pex water lines horizontal and vertical!! Wood floors throughout! HVAC 2017, pool equipment 2018. Sparkling pool surrounded by large patio offers the perfect retreat from the summer heat! SBISD schools (Buyer to verify eligibility). All info per Seller.' ,`Acres` = '0.2192' ,`Area` = '23' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Memorial West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 13 & TR 12A BLK 2 MEMORIAL WOODS SEC 2' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '9550' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '240' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'BUNKER HILL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'MEMORIAL MIDDLE SCHOOL (SPRING BRANCH)' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Memorial Woods' ,`TaxAmount` = '18921' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1965' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668294604' WHERE `Matrix_Unique_ID` = '214285146' --> 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','214289784','1668294605','214289784','2022-11-11T21:03:40.030','56525495','April Peart','eXp Realty, LLC','','','29.927961','-95.707911','33','77433','9','515000.00','Active','Texas Sage','10310','Way','Cypress','3','1','4','2771','Single-Family','Stunning well designed energy efficient home nestled in sought after Towne Lake! Upgrades including water softener, transferable solar panels for energy savings & surround sound system! A spacious open floor plan featuring soaring ceilings & neutral tones with modern touches throughout. Welcoming entry opens to private study followed by a beautiful formal dining room and entertainers kitchen with large center island, ample counter & cabinet space, gas cooktop, beautiful hardware and tile all open to breakfast nook & spacious family room with charming fireplace & access to your beautiful private backyard with large covered patio. Easy family living with bonus game/flex room off of family & three spacious secondary bedrooms. Primary owners suite features beautiful windows, high ceilings & dream oversized spa shower in your private bath. Walking distance to Rennell Elementary, community amenities include fitness center, water park, island lake, community garden, lake house & boardwalk.','0.1722','25','','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','','1','Cypress South','Central Gas','1','LT 13 BLK 2 TOWNE LAKE SEC 29','Subdivision Lot','7500','Appraisal District','','1699','0','','3','','0','','','Gas Cooktop','','Composition','13 - Cypress-Fairbanks','RENNELL ELEMENTARY SCHOOL','CYPRESS RANCH HIGH SCHOOL','ANTHONY MIDDLE SCHOOL (CYPRESS-FAIRBANKS)','Appointment Required','Appraisal District','1','Traditional','Towne Lake Sec 29','11814','3.091','Water District','2014','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','214300891','1668294605','214300891','2022-11-11T22:42:39.370','4798050','Sean Dennis','UTR TEXAS, REALTORS','','','29.677008','-95.217685','24','77502','8','289900.00','Active','Harper','2308','Drive','Pasadena','3','0','4','2725','Single-Family','THIS FOUR BEDROOM, THREE FULL BATH HOME IS REALLY NICE and Features A LOT of Super High-End Updates/Upgrades!...Recent Updates include Interior Paint, Granite Counters, Kitchen/Bathrooms Remodeled, New Cabinets, Appliances, Carpet Replaced, Woodgrain Luxury Vinyl Flooring Installed. Light/Water Fixtures Updated, Efficient A/C System Installed, Plumbing Upgraded, Foundation Leveled w/ Warranty and much more!...The Spacious Floorplan has a Large Family Room/Den w/ Corner Fireplace, Breakfast Bar, Breakfast Room, Formal Dining/Living Room, Great Sized Primary Bedroom and Secondary Bedroom Down, Two HUGE Bedrooms Up... Out Back you will find A Peaceful Private Retreat w/ Cozy Covered Back Patio, Really Neat Rock Waterfall/Water Feature, Landscaping Beds...Oversized Two Car Detached Garage, Covered Parking... All Located in a Quiet, Established Neighborhood with Mature Trees...This Home has so much to offer, you must come see to appreciate. Pride of the Seller shows...Drive By, Take a Look!','0.1784','6','','','Electric Dryer Connections,Gas Dryer Connections','','Estate','1','Gas Connections,Wood Burning Fireplace','1','Pasadena','Central Gas','0','N 10 FT OF LT 52 & S 64 FT OF LT 53 WEDGEWOOD','Subdivision Lot','7770','Appraisal District','','','0','','2','Electric Oven,Freestanding Oven,Single Oven','0','','','Electric Cooktop,Electric Range,Freestanding Range','','Composition','41 - Pasadena','WILLIAMS ELEMENTARY SCHOOL (PASADENA)','PASADENA HIGH SCHOOL','QUEENS INTERMEDIATE SCHOOL','Appointment Required','Appraisal District','1.5','Traditional','Wedgewood','4675','2.6514','Public Sewer,Public Water','1960','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-11T21:23:16.330' ,`MLSNumber` = '63212689' ,`ListAgentFullName` = 'Richard Henderson' ,`ListOfficeName` = 'RE/MAX Grand' ,`SellingAgentFullName` = 'Candace Brawner' ,`SellingOfficeName` = 'Keller Williams Premier RealtyKaty' ,`Latitude` = '29.870376' ,`Longitude` = '-96.154914' ,`PhotoCount` = '50' ,`PostalCode` = '77474' ,`RoomCount` = '13' ,`ListPrice` = '325000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Fm 331' ,`StreetNumber` = '2504' ,`StreetSuffix` = 'Road' ,`City` = 'Sealy' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2269' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This unique 12 acre property has endless possibilities located just north of Sealy. It features 3 bedrooms 2 bathrooms in the main house and a garage apt. Great for living, weekend get aways or farming the 12+ acres. The barn has office area and office storage beside the barn area. The huge trees that surround the homestead are beautiful. This home does need some work and is priced below market and tax values for that reason. Two covered porches looking out over the land and the creek off to the side of the property. Original hardwood floors on the first level with plank siding inside. The house has that historic feel with some modern upgrades. Take a look at the old windmill and image the kids running around the yard playing. Bring the horses or 4 wheelers. This property is not going to last long at this price. Get the value from a little work. At the moment the bridge is under construction so you will need to access from FM 529. Completion time is expect to be done Jan. 2023' ,`Acres` = '12.624' ,`Area` = '57' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Window Unit' ,`HOAMandatory` = '0' ,`Legal` = 'A031 J CUMMINGS' ,`LotDesciption` = 'Other,Ravine' ,`LotSize` = '549901' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '109 - Sealy' ,`SchoolElementary` = 'SEALY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SEALY HIGH SCHOOL' ,`SchoolMiddle` = 'SEALY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Back,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Colonial' ,`Subdivision` = 'J Cummings Acres' ,`TaxAmount` = '6668' ,`TaxRate` = '1.8832' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1916' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668294605' WHERE `Matrix_Unique_ID` = '214373235' --> 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','214437683','1668294605','214437683','2022-11-11T22:27:06.283','4291399','Gloria Lucas','Guardian Angel Properties','','','29.300652','-96.131493','0','77488-5638','3','160000.00','Active','Moutray','621','Avenue','Wharton','2','0','3','','Single-Family','Property needs some TLC, sits on 2 Lots. This Lovely 3 BdRm / 2 Bath is on a corner lot. The living and dining room is separate. Den/family room overlook the large, fenced back yard. Sold AS IS. \r\nALL offers will be considered. ALL offers will be considered.\r\nSq Ft is unknown.','','55','','','Washer Connections','','Sellers Disclosure','','','','','Other Heating','0','Lot 4 & 5; Blk 5','Corner,Subdivision Lot','','','','','0','','1','Gas Oven','0','','','Gas Cooktop','','Composition','180 - Wharton','CG SIVELLS/WHARTON ELEMENTARY SCHOOL','WHARTON HIGH SCHOOL','WHARTON JUNIOR HIGH','Appointment Required','','1','Contemporary/Modern','River Road','','','Public Sewer,Public Water','1900','Seller'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-11T21:37:04.493' ,`MLSNumber` = '89716455' ,`ListAgentFullName` = 'Triska Sparks' ,`ListOfficeName` = 'Keller Williams Elite' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.819520' ,`Longitude` = '-94.995548' ,`PhotoCount` = '26' ,`PostalCode` = '77521' ,`RoomCount` = '6' ,`ListPrice` = '237000.00' ,`Status` = 'Active' ,`StreetName` = 'Amaryllis' ,`StreetNumber` = '4306' ,`StreetSuffix` = 'Avenue' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1325' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Looking for the Perfect Starter Home? Look no Further. This beautiful 4 Bedroom 2 Full baths and 2 car attached garage sets conveniently Near Garth Rd. between Baytown and Highlands. NEVER FLOODED! Located in the wonderful neighborhood of Bay River Colony with 2 parks and walking paths through out perfect for kids to! Rooms are approximate.' ,`Acres` = '0.1278' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 181 BAY RIVER COLONY SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5568' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Wood Shingle' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'BANUELOS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GOOSE CREEK MEMORIAL' ,`SchoolMiddle` = 'HIGHLANDS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Bay River Colony Sec 01' ,`TaxAmount` = '4064' ,`TaxRate` = '2.705' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2009' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668294605' WHERE `Matrix_Unique_ID` = '214464426' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-11T21:35:15.407' ,`MLSNumber` = '20606944' ,`ListAgentFullName` = 'Anthony Tran' ,`ListOfficeName` = 'JPAR-The Sears Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.676704' ,`Longitude` = '-95.584242' ,`PhotoCount` = '31' ,`PostalCode` = '77099' ,`RoomCount` = '12' ,`ListPrice` = '285000.00' ,`Status` = 'Active' ,`StreetName` = 'Evesborough' ,`StreetNumber` = '11659' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2078' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Make this complete makeover home YOURS today!! Complete remodel on a corner lot beautiful 2 story 4BR, 2.5 Bath home. This home has so much to offer! New luxury vinyl plank throughout home, new granite counter tops in kitchen and bathrooms, fresh paint throughout home, new AC, new Roof, new appliances, new tub tile surround, new tubs, new blinds and best of all.. a huge backyard patio cover and a nice size Shed that can be used as a second room, game room, sun room equipped with window unit and 2 fans! WOW! Great size family room and breakfast room for all your family and friends gathering and entertainment. Home is situated about 7-10 minutes away from I-69 and BW8.' ,`Acres` = '0.1251' ,`Area` = '28' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alief' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1 BLK 4 KIRKWOOD COUNTRY SEC 1 R/P' ,`LotDesciption` = 'Corner' ,`LotSize` = '5450' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '474' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '2 - Alief' ,`SchoolElementary` = 'BOONE ELEMENTARY SCHOOL (ALIEF)' ,`SchoolHigh` = 'AISD DRAW' ,`SchoolMiddle` = 'HOLUB MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Kirkwood Country Sec 01 R/P' ,`TaxAmount` = '5262' ,`TaxRate` = '2.4411' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1996' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668294605' WHERE `Matrix_Unique_ID` = '214465670' --> 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','214467309','1668294605','214467309','2022-11-11T21:17:45.960','79611487','Linh Nguyen','5th Stream Realty','','','29.657149','-95.633414','28','77498','7','235000.00','Active','Clear Forest','13923','Drive','Sugar Land','2','0','3','1274','Single-Family','This 3bedroom/2 bathroom is a MUST SEE and a small extra room for a library. It\'s beautifully maintained and conveniently located with easy access to fine dining restaurants and shopping at First Colony Mall, Home Depot, and Kroger. The home is in a quiet neighborhood, new range/stove and a new wash Disher (will replace on Nov 16). Pretty laminate flooring, The big living room allows natural light to shine through. LOW TAXES, LOW HOA. Minutes to significant freeways, Fwy 69, Westpark, and 90 make it easy to get to work. SALE AS IS NO REPAIR.','0.1263','29','','','','','Sellers Disclosure','1','','1','Sugar Land North','Central Gas','1','TOWNEWEST SEC 6, BLOCK 3, LOT 2','Cul-De-Sac','5500','Appraisal District','','360','0','','2','','0','','','','','Composition','19 - Fort Bend','SUGAR MILL ELEMENTARY SCHOOL','KEMPNER HIGH SCHOOL','SUGAR LAND MIDDLE SCHOOL','Lockbox Front,No Supra Keybox,Request Online Appointment','Appraisal District','1','Colonial,Other Style','Townewest Sec 6','3513','2.3329','Public Sewer,Public Water','1982','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','214541621','1668294606','214541621','2022-11-11T21:24:13.780','52655102','Amy Rodriguez','Walzel Properties','','','29.657498','-95.221930','0','77587','3','90000.00','Active','Avenue J','715','','South Houston','1','1','3','1613','Single-Family','LOCATION, LOCATION, LOCATION!!!! DONT MISS OUT ON THIS INVESTORS OPPORTUNITY!! New roof was put i 2017! Great corner lot for a fix and flip or a long term property!','0.163','6','','','','','Sellers Disclosure','','','1','South Houston','Central Electric','0','LT 16 BLK 245 SOUTH HOUSTON','Corner','7100','Appraisal District','','','0','','1','','0','','','','','Composition','41 - Pasadena','PEARL HALL ELEMENTARY SCHOOL','SOUTH HOUSTON HIGH SCHOOL','MILLER INTERMEDIATE SCHOOL','Accompany,Appointment Required,Lockbox Front','Appraisal District','1','Traditional','South Houston','3870','2.8255','Public Water','1960','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','214546575','1668294606','214546575','2022-11-11T21:36:13.810','31092596','Lanard Lane','RE/MAX Pearland','','','29.407414','-95.051950','49','77568','6','389900.00','Active','Ocean Key','2603','Drive','Texas City','2','1','4','2609','Single-Family','Gorgeous Empire home, Wellington Signature Series the only one in Lago Mar. Located in a gated Community, this home features 4 bed, 2.5 baths and over 2,600 sq with all the space your family needs. Open-concept floor plan with a beautiful Kitchen with quarts counter tops, walk-in pantry, GE appliance Pkg. slate, freestanding gas range, subway tile backsplash, and Reverse Osmosis H20.. Primary bedroom downstairs is a retreat. Garden tub, double vanity, separate shower and large walk-in closet. Upstairs game room opens up to 3 bedrooms. Highlights- Energy efficient features, rain gutters, waters softener system, landscape lighting, hurricane panels and pre-wired alarm system. Backyard with covered patio, and storage shed. Welcoming Community- walking trails, parks, lakes,lagoon, club house, swimming pools and much more. Move-in ready.* You Don\'t want to miss all this beautiful home has to offer!','0.1524','33','','','','','Mud,Sellers Disclosure','','','','Texas City','Central Electric,Central Gas','1','LOT 16 BLK 5 LAGO MAR POD 6 SEC 2 (2020) ABST 11','Subdivision Lot','6637','Appraisal District','','800','0','','2','','0','','','','','Composition','17 - Dickinson','LOBIT ELEMENTARY SCHOOL','DICKINSON HIGH SCHOOL','LOBIT MIDDLE SCHOOL','Supra Keybox','Appraisal District','2','Traditional','Lago Mar Pod 6 Sec 2','12442','3.5512','Public Sewer,Public Water','2019','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','214554345','1668294606','214554345','2022-11-11T21:58:01.350','66424606','Lance Loken','Keller Williams Platinum','','','29.501171','-95.513403','50','77459','12','561000.00','Active','Caleb','3615','Lane','Missouri City','4','1','4','4156','Single-Family','This gorgeous 4-bedroom, 4.5-bathroom home in Sienna Steep Bank Village has so much to offer! This home boasts a beautiful brick exterior, high ceilings, wood flooring, a gas log fireplace, study, game room, formal dining and living rooms, a covered patio, and a glistening swimming pool in the spacious backyard. No recipe is a challenge in the island kitchen, fully equipped with granite countertops, tile backsplash, a butler pantry, gas cooktop, double oven, glass-fronted cabinets, breakfast bar, dining nook, pendant lighting, and undercabinet lighting. The spa-like primary suite features a walk-in closet, dual vanities, jetted tub, and a separate shower. Residents of Sienna enjoy a swimming pool, a park, a playground, and walking trails. Situated off Hwy 6, residents are close to shopping and dining at the First Colony Mall, Sugar Land Town Center, and Kitty Hollow Park. Zoned to Fort Bend ISD.','0.2381','38','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud','1','','1','Sienna Area','Central Gas','1','SIENNA STEEP BANK VILLAGE SEC 6B, BLOCK 4, LOT 29','Subdivision Lot','10372','Appraisal District','','1307','0','','2','Double Oven,Electric Oven,Gas Oven','1','In Ground','','Gas Range','','Composition','19 - Fort Bend','SIENNA CROSSING ELEMENTARY SCHOOL','RIDGE POINT HIGH SCHOOL','BAINES MIDDLE SCHOOL','Appointment Required','Appraisal District','2','Traditional','Sienna Steep Bank Village','11076','2.5729','Water District','2003','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-11T22:25:47.020' ,`MLSNumber` = '34224445' ,`ListAgentFullName` = 'Linda Swope' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.720972' ,`Longitude` = '-95.421689' ,`PhotoCount` = '34' ,`PostalCode` = '77005' ,`RoomCount` = '19' ,`ListPrice` = '1825000.00' ,`Status` = 'Active' ,`StreetName` = 'Robinhood' ,`StreetNumber` = '2727' ,`StreetSuffix` = 'Street' ,`City` = 'West University Place' ,`BathsFull` = '5' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4685' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Elegant home situated within walking distance of nearby restaurants and Rice Village. Easy access to Med Center/Central Biz District/Greenway. Enter the large foyer, view the exquisite open living & dining rooms. The kitchen with high end appliances, granite and huge island is adjacent to very spacious breakfast area. The family room with built-ins, fireplace & wall of windows overlooks the pool! A guest half bath is conveniently situated in the wide hallway. A private study with built-in shelves also has a full bath. Head up to the 2nd floor Library with built-in desk area. The Primary bedroom is oversized with sitting area, huge en suite bath with very large closet & built-ins including cabinetry and a vanity. Three more bedrooms all with en suite baths (one with vaulted ceiling) and a 5th bedroom that is perfect for a small child or playroom. In back yard you\'ll find pool with spa and covered dining area. There are 2 water heaters. Clear stucco inspection! Major price reduction!' ,`Acres` = '0.1423' ,`Area` = '17' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'West University/Southside Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TRS 2 & 3A BLK 5 TANGLEY TERRACE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Enclosed,Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WEST UNIVERSITY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Tangley Terrace' ,`TaxAmount` = '35304' ,`TaxRate` = '2.0584' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668294606' WHERE `Matrix_Unique_ID` = '214583481' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-11T21:40:36.570' ,`MLSNumber` = '98857465' ,`ListAgentFullName` = 'Jennifer Gowens' ,`ListOfficeName` = 'Compass RE Texas, LLCKaty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.648411' ,`Longitude` = '-95.730147' ,`PhotoCount` = '41' ,`PostalCode` = '77406' ,`RoomCount` = '8' ,`ListPrice` = '280000.00' ,`Status` = 'Active' ,`StreetName` = 'Lake Buchanan' ,`StreetNumber` = '1519' ,`StreetSuffix` = 'Court' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1734' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to 1519 Lake Buchanan in Waterside Estates! This charming, 3 bedroom, 2 and 1/2 bath home features inviting indoor and outdoor spaces, with abundant natural light! Discover open living, dining and kitchen areas, with planation shutters, updated light fixtures, wood look laminate flooring, and chic painted mantle. In the kitchen, you’ll find gorgeous silestone counters, subway tile backsplash, and a HUGE pantry! Double paned, energy efficient windows! This home offers an enormous owner\'s suite, ample sized secondary bedrooms and great closet storage! With a neutral color palette, this home is move-in ready! Find the outdoor space you\'ve been looking for with the expansive backyard! Ample room for a pool, playground, and/or trampoline. Relax or entertain on the recent wood deck! Waterside Estates offers gorgeous views around the lake, trails, pool, tennis courts, and playground. LOW tax rate!! Quick access to Grand Parkway 99 and nearby shopping and restaurants.' ,`Acres` = '0.1853' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'WATERSIDE ESTATES SEC 9, BLOCK 3, LOT 36' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '8072' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '590' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'OAKLAND ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TRAVIS HIGH SCHOOL (FORT BEND)' ,`SchoolMiddle` = 'BOWIE MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Waterside Estates Sec 9' ,`TaxAmount` = '4659' ,`TaxRate` = '2.2929' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668294606' WHERE `Matrix_Unique_ID` = '214619437' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-11T22:34:54.847' ,`MLSNumber` = '21775758' ,`ListAgentFullName` = 'Selina Cerda' ,`ListOfficeName` = 'Keller Williams Woodlands' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.167058' ,`Longitude` = '-95.294590' ,`PhotoCount` = '23' ,`PostalCode` = '77357' ,`RoomCount` = '4' ,`ListPrice` = '289000.00' ,`Status` = 'Active' ,`StreetName` = 'Lecrete Mill' ,`StreetNumber` = '20128' ,`StreetSuffix` = 'Drive' ,`City` = 'New Caney' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1840' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome! This D.R. Horton home is located in the highly sought after subdivision of Porters Mill, nicely situated on an over sized culdesac lot with backyard gate access to the neighborhood pool and playground! You will fall in love with this open floor plan! This 4 bedroom home is boasting with upgrades from granite counter tops, stainless steal kitchen appliances, to Epoxy finished garage flooring. The home also features a water softner system, a tankless on demand water heater, and is pre-wired with the ADT Smart Home alarm system that can be controlled by your Alexa devices! This is a must see! Located only one mile from the 99 Grand Parkway and minutes away from the Valley Ranch Shopping Center.' ,`Acres` = '0.1822' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Porter/New Caney West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S812703 - PORTERS MILL 03, BLOCK 2, LOT 28' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '7936' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'ROBERT CRIPPEN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PORTER HIGH SCHOOL (NEW CANEY)' ,`SchoolMiddle` = 'WHITE OAK MIDDLE SCHOOL (NEW CANEY)' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Porters Mill 03' ,`TaxAmount` = '8296' ,`TaxRate` = '3.0331' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668294606' WHERE `Matrix_Unique_ID` = '214630251' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-11T22:30:58.747' ,`MLSNumber` = '40017106' ,`ListAgentFullName` = 'Robert Johnson' ,`ListOfficeName` = 'Century 21 Olympian Galleria' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.472173' ,`Longitude` = '-95.048809' ,`PhotoCount` = '19' ,`PostalCode` = '77539' ,`RoomCount` = '6' ,`ListPrice` = '234990.00' ,`Status` = 'Active' ,`StreetName` = 'Acorn' ,`StreetNumber` = '3212' ,`StreetSuffix` = 'Circle' ,`City` = 'Dickinson' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1337' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fantastic house for a Family or Investment! Newly renovated! Includes state of the art tech as well as great updates! This one has an amazing new Kitchen, Master Bathroom, Security Cameras, A.C. and much more! Professional landscaping and a huge deck outside for entertaining and BBQ. This one won’t last long! Set up your appointment to view today!' ,`Acres` = '0.2093' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Dickinson' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 19 PERRY & AUSTIN SUR LOT 19 BLK 2 EDGEWOOD SUB' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '9115' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'SILBERNAGEL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'DUNBAR MIDDLE SCHOOL (DICKINSON)' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Edgewood' ,`TaxAmount` = '4600' ,`TaxRate` = '2.1168' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1987' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668294606' WHERE `Matrix_Unique_ID` = '214637571' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-11T21:14:15.553' ,`MLSNumber` = '13234727' ,`ListAgentFullName` = 'Jasmin Clopton' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.796473' ,`Longitude` = '-95.551283' ,`PhotoCount` = '17' ,`PostalCode` = '77043' ,`RoomCount` = '7' ,`ListPrice` = '739999.00' ,`Status` = 'Active' ,`StreetName` = 'Mayfield' ,`StreetNumber` = '10300' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '3002' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Absolutely stunning remodeled home centrally located in sought-after area. This property is just a short distance from trendy restaurants, wineries, Memorial City Mall, City Centre, the Galleria and Memorial Med center. House features beautiful Spanish engineered hardwood floors flowing throughout common areas. Amazing open concept kitchen boasts plenty of cabinets including a designated dry bar. The grand primary bedroom features beautiful custom tray ceilings and the walk in closet a custom jewelry cabinet. The soaking tub is ready for your stressful days. Don\'t forget to check out the amazing 5 panel bifold patio door. Some of the updates include roof shingles 2022, entire HVAC system 2022, pex plumbing 2022, updated kitchen, all new doors, floors, updated bathrooms and much more to mention. Come walk this beautiful home in a very fast appreciating area' ,`Acres` = '0.1716' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'TR 22 BLK 2 MOSS OAKS' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7475' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'SHADOW OAKS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING WOODS HIGH SCHOOL' ,`SchoolMiddle` = 'SPRING OAKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Moss Oaks' ,`TaxAmount` = '7493' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1668294607' WHERE `Matrix_Unique_ID` = '214655257' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-11T22:21:45.697' ,`MLSNumber` = '47099096' ,`ListAgentFullName` = 'Robin Kitzmiller' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.376402' ,`Longitude` = '-95.534723' ,`PhotoCount` = '49' ,`PostalCode` = '77304' ,`RoomCount` = '8' ,`ListPrice` = '315000.00' ,`Status` = 'Active' ,`StreetName` = 'Kalinago View' ,`StreetNumber` = '11539' ,`StreetSuffix` = 'Lane' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2124' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Adorable 1 story with 4 bedrooms walking distance to Lake Conroe in the fabulous Water Crest neighborhood. Beautiful kitchen with huge island with stainless appliances, granite countertops, lots of cabinet space and room for the chef. kitchen is open to amazing living room with huge vaulted ceilings. Large master bedroom with huge walk in closet and separate shower and tub with beautiful granite counters. Large fenced backyard with covered patio. This neighborhood has boat ramp access to Lake Conroe with a 2 amazing pools, beautiful clubhouse, pier and dog park.' ,`Acres` = '0.1542' ,`Area` = '39' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S954409 - WATER CREST ON LAKE CONROE 09, BLOCK 1, LOT 54' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6719' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '875' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'LAGWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERT P. BRABHAM MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Water Crest On Lake Conroe 09' ,`TaxAmount` = '7819' ,`TaxRate` = '3.0823' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668294607' WHERE `Matrix_Unique_ID` = '214670335' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-11T21:18:54.333' ,`MLSNumber` = '3595291' ,`ListAgentFullName` = 'Nimesh Dave' ,`ListOfficeName` = 'Keller Williams Realty -SW' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.523724' ,`Longitude` = '-95.758453' ,`PhotoCount` = '31' ,`PostalCode` = '77469' ,`RoomCount` = '9' ,`ListPrice` = '275000.00' ,`Status` = 'Active' ,`StreetName` = 'Durango Ridge' ,`StreetNumber` = '6014' ,`StreetSuffix` = 'Court' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1904' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Location meets value! Welcome to 6014 Durango Ridge Ct in Richmond/Rosenberg. Newley updated 3 BR / 2 Bath single story at 1904 sqft. Freshly painted light and bright with tile throughout. Updated kitchen with brand new quartz countertops and brand new Stainless Steel Appliances overlooking an open floor plan. New Lighting package with recessed lighting. Exterior has been power washed and newly painted. Enjoy this quaint neighborhood with easy access to 59 and other retail and entertainment! Come and get it, it won\'t last long!' ,`Acres` = '0.1377' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'ROSE RANCH SEC 1, BLOCK 3, LOT 39' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'ARREDONDO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RANDLE HIGH SCHOOL' ,`SchoolMiddle` = 'WRIGHT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Rose Ranch Sec 1' ,`TaxAmount` = '5680' ,`TaxRate` = '2.9348' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668294607' WHERE `Matrix_Unique_ID` = '214670471' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-11T21:35:45.450' ,`MLSNumber` = '53078895' ,`ListAgentFullName` = 'Paul Compton' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.061024' ,`Longitude` = '-95.174505' ,`PhotoCount` = '31' ,`PostalCode` = '77345' ,`RoomCount` = '3' ,`ListPrice` = '365000.00' ,`Status` = 'Active' ,`StreetName` = 'Cedar Village' ,`StreetNumber` = '3102' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2725' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Located in the heart of Kingwood in the highly desirable neighborhood of Greentree, this incredibly unique and large one-story home is exactly what you’ve been looking for! There are so many updates that have been done to this home including a completely updated kitchen with gorgeous granite counters, updated kitchen cabinets, farmhouse sink, and a cooktop that was recently converted to gas. Just off the spacious primary suite you will find a dedicated office space and in the primary suite you will find new granite counters, large walk-in shower, soaker tub, and his and hers walk-in closets. Even the systems of the home have been updated with a newer HVAC system and water heater – all that’s left is for you to move in. No flooding ever and walking distance to award-winning Humble ISD schools this incredible opportunity is now ready for you!' ,`Acres` = '0.1873' ,`Area` = '32' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Kingwood East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 19 BLK 35 GREENTREE VILLAGE SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8160' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'GREENTREE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KINGWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'CREEKWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Greentree Village' ,`TaxAmount` = '6946' ,`TaxRate` = '2.5839' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1988' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668294607' WHERE `Matrix_Unique_ID` = '214675528' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-11T21:42:01.040' ,`MLSNumber` = '2419933' ,`ListAgentFullName` = 'Kevin King' ,`ListOfficeName` = 'RE/MAX ONE - Premier' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.892851' ,`Longitude` = '-94.805964' ,`PhotoCount` = '0' ,`PostalCode` = '77535' ,`RoomCount` = '2' ,`ListPrice` = '125000.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 4002' ,`StreetNumber` = '10' ,`StreetSuffix` = '' ,`City` = 'Dayton' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1320' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great opportunity to purchase this fixer upper. Home is being sold as is, where is with any and all faults.' ,`Acres` = '1.3891' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Dayton' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = '000172 J DORSETT, TRACT 44, ACRES 1.3891' ,`LotDesciption` = 'Other' ,`LotSize` = '60509' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '74 - Dayton' ,`SchoolElementary` = 'KIMMIE M. BROWN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DAYTON HIGH SCHOOL' ,`SchoolMiddle` = 'WOODROW WILSON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'J Dorsett' ,`TaxAmount` = '2066' ,`TaxRate` = '1.7625' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668294608' WHERE `Matrix_Unique_ID` = '214682403' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-11T21:52:07.830' ,`MLSNumber` = '53441443' ,`ListAgentFullName` = 'Diem Chu' ,`ListOfficeName` = 'ABSOLUTE Realty Group Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.711733' ,`Longitude` = '-95.584057' ,`PhotoCount` = '0' ,`PostalCode` = '77072' ,`RoomCount` = '6' ,`ListPrice` = '259000.00' ,`Status` = 'Active' ,`StreetName` = 'Logan Ridge' ,`StreetNumber` = '11753' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1569' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A cute 3 bedrooms, 2 bath, Perry home with recent update with new paint, new laminate floor in all rooms, near Hasting and Elsik high school, Hong Kong super market, Westpark Tollway and Beltway 8.\r\none of the owner is a real estate agent.' ,`Acres` = '0.0992' ,`Area` = '28' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alief' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 26 BLK 1 HIGH STAR PLACE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4320' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1850' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '2 - Alief' ,`SchoolElementary` = 'CHANCELLOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AISD DRAW' ,`SchoolMiddle` = 'ALIEF MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'High Star Place' ,`TaxAmount` = '3744' ,`TaxRate` = '2.4411' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668294608' WHERE `Matrix_Unique_ID` = '214682422' --> Updated record success