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-26T22:01:24.517' ,`MLSNumber` = '79684273' ,`ListAgentFullName` = 'Britney Barcus' ,`ListOfficeName` = 'Barcus Realty Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.812606' ,`Longitude` = '-95.446388' ,`PhotoCount` = '29' ,`PostalCode` = '77092' ,`RoomCount` = '9' ,`ListPrice` = '555000.00' ,`Status` = 'Active' ,`StreetName` = 'Brookwoods' ,`StreetNumber` = '3710' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3243' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great opportunity to custom design your dream home in the desirable Oak Forest area. Home has been gutted down to the studs so the options are limitless. This unique home is in a unrestricted area so it can be used as residential and/or commercial. The garage is converted to extra living space and ideal for offices spaces, game room, or as you choose. Home has great bones and situated on a huge ravine lot with mature trees and lots of privacy. Bridge in backyard leads to an extra secluded outdoor oasis. This is another wonderful green space to enjoy or build an addition to the home that fits your lifestyle - a gazebo, fitness/yoga studio, gallery, workshop, or storage. The opportunities are endless! Construction loan available; please inquire from listing agent. Previous design plans available. You are close to hiking/biking trails, restaurants, and a quick commute to Downtown. Enjoy the convenience of near city living with your own private backyard retreat!' ,`Acres` = '0.5969' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Oak Forest West Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 149 BLK 7 BROOK-WOODS ESTATES' ,`LotDesciption` = 'Cleared,Ravine,Subdivision Lot' ,`LotSize` = '26000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'STEVENS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'BLACK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Brook-Woods Estates' ,`TaxAmount` = '10434' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1958' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1669651507' WHERE `Matrix_Unique_ID` = '208566647' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-26T21:31:03.067' ,`MLSNumber` = '80181124' ,`ListAgentFullName` = 'Abimbade Jones' ,`ListOfficeName` = 'All About Texas Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.012086' ,`Longitude` = '-95.489088' ,`PhotoCount` = '37' ,`PostalCode` = '77068' ,`RoomCount` = '9' ,`ListPrice` = '315000.00' ,`Status` = 'Active' ,`StreetName` = 'Banty Falls' ,`StreetNumber` = '15703' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3185' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This one is a find! Corner lot, Cul-de-sac, Luxury CertainTeed roof with a lifetime transferable warranty. Never flooded and not in flood plain. No pipe burst during freeze. Highly desirable section of Olde Oaks. 5mins walk to Northgate Country Club and Golf Course. Beautiful high ceilings with lots of windows! Unique contemporary floor plan. Wet bar. Walk-in closet in all bedrooms. Faux wood blinds throughout. Large backyard with storage house. Inground sprinkler system. Three car garage! Don\'t wait. Submit an offer now!' ,`Acres` = '0.2229' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '1960/Cypress Creek North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 7 BLK 15 OLDE OAKS SEC 1' ,`LotDesciption` = 'Corner,Cul-De-Sac' ,`LotSize` = '9711' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'PAT REYNOLDS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTFIELD HIGH SCHOOL' ,`SchoolMiddle` = 'EDWIN M WELLS MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Photos/No Videos' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Olde Oaks Sec 01' ,`TaxAmount` = '5526' ,`TaxRate` = '2.3342' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1981' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669651507' WHERE `Matrix_Unique_ID` = '211642481' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-26T22:15:04.223' ,`MLSNumber` = '22840349' ,`ListAgentFullName` = 'David Flory' ,`ListOfficeName` = 'RE/MAX Universal' ,`SellingAgentFullName` = 'Nesahn Robinson' ,`SellingOfficeName` = 'Reach Realty Group, LLC' ,`Latitude` = '29.870143' ,`Longitude` = '-95.661562' ,`PhotoCount` = '35' ,`PostalCode` = '77084' ,`RoomCount` = '12' ,`ListPrice` = '325000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Spring' ,`StreetNumber` = '6406' ,`StreetSuffix` = 'Creek' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2568' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Located just minutes from Hwy 6 and 529, this gorgeous 2 story home is conveniently situated in the Stone Creek Community. 4 bedrooms, 2.5 bath, with Game Room and NO CARPET- Tile and Laminate Floors throughout! Formal 2 Story Entry with art niche, Formal Dining Room Opens to the Kitchen and has Decorative Trim. Chefs Kitchen with Granite Countertops, Tile backsplash, 5 burner Gas Range, Pantry and tons of Storage Space. Kitchen open to Living and Breakfast. Large Living Room with Gas Fireplace, Oversized Primary Bedroom Down with Attached Bath- Dual sinks, Vanity area, Walk in Closet, Separate tub and Rain Shower. Utility Room leads to the 2 garage. Spacious Game Room Up with Storage Closet. 3 good sized Bedrooms, Hollywood Bath, and Linen Closet Up. Outside patio space and generous Fenced back yard. New roof in 2020.' ,`Acres` = '0.1458' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 8 BLK 3 STONE CREEK SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6353' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '410' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'HOLMSLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LANGHAM CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'KAHLA MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Stone Creek' ,`TaxAmount` = '7015' ,`TaxRate` = '3.071' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1669651507' WHERE `Matrix_Unique_ID` = '211849209' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-26T21:17:30.097' ,`MLSNumber` = '50516886' ,`ListAgentFullName` = 'Janelle Williams' ,`ListOfficeName` = 'RE/MAX Cinco Ranch' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.708504' ,`Longitude` = '-95.870298' ,`PhotoCount` = '33' ,`PostalCode` = '77441' ,`RoomCount` = '5' ,`ListPrice` = '465000.00' ,`Status` = 'Active' ,`StreetName` = 'Rising Moon' ,`StreetNumber` = '28702' ,`StreetSuffix` = 'Lane' ,`City` = 'Fulshear' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '2' ,`SqFtTotal` = '2409' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WOW! NEW PRICE 11/26/22 - READY TO SELL!! YOU WONT FIND A BETTER DEAL THAN THIS!! This beautiful one story Taylor Morrison Granada home features everything you want and more! 2 Spacious Bedrooms plus 3rd Room Flex Space usable as an office/den/home gym....whatever fits your needs. Energy efficient to the max, including built in water filtering system, tankless water heater, 16 kw Generac GENERATOR, Energy Star thermostat, Low E double-paned windows. Enormous backyard with covered patio and no back neighbors. Washer/Dryer, Kitchen Fridge and all stainless appliances included!! Water Softener. Programmable sprinkler system, front lawn maintenance included in HOA dues. Most of the furniture in this home is available for purchase as well so this can be a furnished home from Day 1! Community amenities include The Club @ Bonterra plus walking trails, ponds, pools, pickleball, bocce ball and more!! This 55+ neighborhood is a sight to be seen!' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Taylor Morrison' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'BONTERRA AT CROSS CREEK RANCH SEC 6, BLOCK 1, LOT 8' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '14646' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2925' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'HUGGINS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Bonterra At Cross Creek' ,`TaxAmount` = '12602' ,`TaxRate` = '3.3362' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669651508' WHERE `Matrix_Unique_ID` = '212339663' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-26T21:26:30.230' ,`MLSNumber` = '16617123' ,`ListAgentFullName` = 'Karen Davis' ,`ListOfficeName` = 'KLD Premier Realty' ,`SellingAgentFullName` = 'Shelli Hinkson' ,`SellingOfficeName` = 'Keller Williams Premier RealtyKaty' ,`Latitude` = '29.683816' ,`Longitude` = '-95.929232' ,`PhotoCount` = '48' ,`PostalCode` = '77441' ,`RoomCount` = '11' ,`ListPrice` = '600000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Waterford Crest' ,`StreetNumber` = '32210' ,`StreetSuffix` = 'Lane' ,`City` = 'Fulshear' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4604' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'INCREDIBLE PRICE AND OPPORTUNITY TO LIVE IN WESTON LAKES. Stunning 2- Story on an oversized lot in the gated Golf Course Community of Weston Lakes. Courtyard leads to double door entrance. Inside is designer tile floors, granites, custom cabinetry, wrought iron. Remarkable floor plan with dramatic Foyer with coffered ceilings. Extraordinary Dining Room served by a Wine Bar. Huge Study. Dramatic Family Room with open beamed Cathedral Ceiling, stone Fireplace and a wall of windows. Gorgeous Kitchen with designer level granite, gas cooktop, custom cabinets and huge Island. Incredible Primary Bedroom and sumptuous Bath. Upstairs find a huge Gameroom, Media Room, extra Bonus Room, Balcony and private Bedroom with full Bath. Covered back Porch, gas grill, full house Generator and Water Softener. Weston Lakes offers 18-hole Golf Course, Country Club, Waterside Grill, 2 pools, 2 lighted tennis courts, 4 pickleball courts, Gym, Parks and Lakes. Zoned to exemplary schools and Low Taxes!' ,`Acres` = '0.3742' ,`Area` = '30' ,`BuilderName` = 'Keystone' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fulshear/South Brookshire/Simonton' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'WESTON LAKES SEC 19, BLOCK 1, LOT 24' ,`LotDesciption` = 'Cul-De-Sac,In Golf Course Community,Subdivision Lot' ,`LotSize` = '16298' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'MORGAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Weston Lakes' ,`TaxAmount` = '10196' ,`TaxRate` = '2.1698' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2010' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669651508' WHERE `Matrix_Unique_ID` = '213275708' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-26T21:32:49.923' ,`MLSNumber` = '816931' ,`ListAgentFullName` = 'Kristin Pomroy' ,`ListOfficeName` = 'UTR TEXAS, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.579518' ,`Longitude` = '-95.020390' ,`PhotoCount` = '10' ,`PostalCode` = '77586' ,`RoomCount` = '7' ,`ListPrice` = '404900.00' ,`Status` = 'Active' ,`StreetName` = 'Lake Mija' ,`StreetNumber` = '1418' ,`StreetSuffix` = 'Court' ,`City` = 'Seabrook' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2238' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Do not miss out on the opportunity to own a like-new home in Lake Mija Village. This 3-bedroom, 2-bathroom property features high ceilings, vinyl plank flooring, open floor plan, tandem garage that can fit 3 cars. Access to neighborhood lake at entrance of neighborhood a very short walk away. Grandiose solid wood front door with millwork. Long, formal foyer with picture/shelf niche. Tons of windows allowing natural light flood in throughout home. Tandem garage to add a third car or great for storage or workspace. Oversized covered back patio with 3 ceiling fans, recessed lights, hot tub hook up, gas hookup, electric, and sound hookups. Security wired and sound hookups in family area. Kitchen equipped with granite countertops, brick backsplash, tons of drawer, cabinet and counter space, two bars with two different heights. Tons of storage throughout home. Perfect place to retreat to get away from it all. Get here before it\'s gone.' ,`Acres` = '0.2' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Clear Lake Area' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 7 BLK 2 LAKE MIJA VILLAGE' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '8711' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'BAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'SEABROOK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lake Mija Village' ,`TaxAmount` = '8442' ,`TaxRate` = '2.2905' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669651508' WHERE `Matrix_Unique_ID` = '213330639' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-26T21:15:40.837' ,`MLSNumber` = '56610254' ,`ListAgentFullName` = 'Elizabeth Wickes' ,`ListOfficeName` = 'Bray Real Estate Group LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.722636' ,`Longitude` = '-95.633153' ,`PhotoCount` = '28' ,`PostalCode` = '77082' ,`RoomCount` = '3' ,`ListPrice` = '255000.00' ,`Status` = 'Active' ,`StreetName` = 'Naomi Hollow' ,`StreetNumber` = '13826' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1567' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '***Now for Sale or Rent***Great opportunity to own in Westhollow Village, this neighborhood is minutes from the energy corridor and the Westpark tollway. The beautiful one-story home is freshly painted inside and out. Upgraded attic insulation, Natural wood flooring, and tile in bathrooms. This home features 3 bedrooms and 2 bathrooms that have been updated with a 2 car garage. An open floor plan that is great for entertaining! Granite countertops in the kitchen and under cabinet lighting, with a gas-started wood-burning fireplace to keep you nice and toasty in the winter. Did I mention access to an exclusive walking trail?' ,`Acres` = '0.1085' ,`Area` = '31' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alief' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 108 BLK 5 (ORIG RES L BK 7) WESTHOLLOW VILLAGE' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '4725' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '2 - Alief' ,`SchoolElementary` = 'HEFLIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AISD DRAW' ,`SchoolMiddle` = 'O\'DONNELL MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Westhollow Village' ,`TaxAmount` = '4597' ,`TaxRate` = '2.4411' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '1996' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1669651508' WHERE `Matrix_Unique_ID` = '213383112' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-26T21:07:56.987' ,`MLSNumber` = '6475624' ,`ListAgentFullName` = 'Ivan Ruiz' ,`ListOfficeName` = 'Keller Williams SoutheastTexas' ,`SellingAgentFullName` = 'Theresa Bradford' ,`SellingOfficeName` = 'Keller Williams Realty-FM' ,`Latitude` = '30.089120' ,`Longitude` = '-94.175115' ,`PhotoCount` = '32' ,`PostalCode` = '77706' ,`RoomCount` = '7' ,`ListPrice` = '205000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Coronado' ,`StreetNumber` = '1270' ,`StreetSuffix` = 'Circle' ,`City` = 'Beaumont' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1476' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Cul-de-sac Living in the West End of Beaumont. Never Flooded! This cute little charmer will sweep you off your feet. The home had dining room turned into a functional room or office space ,Offers a large den with brick wall feature, eat in kitchen, with plenty of counter space & tile floors. The bedrooms are all spacious , clean carpets, and master bathroom has a nice stand alone shower & tasteful vanity space. The home is located in a great location with little traffic. The backyard is oversized and has room for a pool, play scape and more, a new storage room was installed recently. The covered patio allows for great evening gatherings and all year round out door fun. \r\nCome take a tour and discover that this property truly feels like home!' ,`Acres` = '0.2096' ,`Area` = '51' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'SHERATON WOODS L17 B4' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '9130' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '143 - Beaumont' ,`SchoolElementary` = 'CURTIS ELEMENTARY SCHOOL (BEAUMONT)' ,`SchoolHigh` = 'WEST BROOK HIGH SCHOOL' ,`SchoolMiddle` = 'MARSHALL MIDDLE SCHOOL (BEAUMONT)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sheraton Woods' ,`TaxAmount` = '4107' ,`TaxRate` = '2.645' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669651509' WHERE `Matrix_Unique_ID` = '213562133' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-26T21:14:03.837' ,`MLSNumber` = '18421042' ,`ListAgentFullName` = 'Cheryl Checkles' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.821026' ,`Longitude` = '-95.388434' ,`PhotoCount` = '26' ,`PostalCode` = '77022' ,`RoomCount` = '7' ,`ListPrice` = '305000.00' ,`Status` = 'Active' ,`StreetName` = '38th' ,`StreetNumber` = '825' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1653' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come tour this newer home in Independence Heights which is only minutes to Loop 610, I-45 and Downtown.\r\nThis home has engineered wood downstairs and new carpet just installed (October 2022) entire second floor. The kitchens feature stainless steel appliances, a pantry and gas range. The primary bathroom has dual vanities, jetted tub, large walk in shower and a HUGE primary closet located off the primary bathroom. Home is equip with a security system. The family will love the backyard and deck. Close to restaurants, shopping and all the Heights has to offer! Whole Foods 1.3 miles away. Home has NEVER FLOODED. Please take a look at the virtual tour link to see the video!' ,`Acres` = '0.0918' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 19 BLK 70 INDEPENDENCE HEIGHTS PARK' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BURRUS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WASHINGTON HIGH SCHOOL' ,`SchoolMiddle` = 'WILLIAMS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Independence Heights Park' ,`TaxAmount` = '4651' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669651509' WHERE `Matrix_Unique_ID` = '213595604' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-26T22:07:31.260' ,`MLSNumber` = '94081393' ,`ListAgentFullName` = 'Suzanne Mason' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.122046' ,`Longitude` = '-95.620226' ,`PhotoCount` = '31' ,`PostalCode` = '77375' ,`RoomCount` = '10' ,`ListPrice` = '549900.00' ,`Status` = 'Active' ,`StreetName` = 'Lost Creek' ,`StreetNumber` = '13202' ,`StreetSuffix` = 'Road' ,`City` = 'Tomball' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2568' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WELCOME HOME to this charming TRADITIONAL STYLE GEM so close to the heart of Tomball! This home has lots of traditional and vintage style that the most savvy buyers seek! Pride of ownership shows through on this family home that has been very well maintained (check update list in attachments). This property is move-in ready and the perfect family home within the desirable HUNTERWOOD Subdivision as well as located right in the heart of the much sought after TOMBALL ISD! Rest assured there is plenty of \"flex\" space here for all your family needs with ROOM TO GROW!. Beautiful natural sunlight pours in from multiple double French doors! Stunning corner lot, circle drive with separate side entrance to boot and mature trees, all lead to a spectacular nearly one acre yard that will lend nicely to the green thumb of the family! No flooding here! Call for more details or any questions. I am available, make your pre-appointment today!' ,`Acres` = '0.9298' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tomball' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1 BLK 2 HUNTERWOOD SEC 1' ,`LotDesciption` = 'Corner,Subdivision Lot,Wooded' ,`LotSize` = '40502' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'TOMBALL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'TOMBALL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Hunterwood Sec 01' ,`TaxAmount` = '7746' ,`TaxRate` = '2.3717' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1993' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669651509' WHERE `Matrix_Unique_ID` = '213832834' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-26T22:12:45.780' ,`MLSNumber` = '43646842' ,`ListAgentFullName` = 'Misty Inman' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = 'Paulina Elizalde' ,`SellingOfficeName` = 'RE/MAX Real Estate Assoc.' ,`Latitude` = '29.502460' ,`Longitude` = '-95.104541' ,`PhotoCount` = '31' ,`PostalCode` = '77573' ,`RoomCount` = '9' ,`ListPrice` = '265000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Shadow' ,`StreetNumber` = '1007' ,`StreetSuffix` = 'Circle' ,`City` = 'League City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2069' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Spacious 4/2/2 with an open floor plan with a living room, den and formal dining. Upgrades include vent hood, glass cooktop, fresh paint inside and out, granite counters in kitchen and quartz in the bathrooms and new HVAC system. Kitchen has a double oven. You\'ll also love the built in cabinets and shelving in the living room. Tile flooring throughout. No carpet! Convenient to the Freeway, restaurants and shopping. No MUD or HOA!' ,`Acres` = '0.1865' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 3 PAGE 9 LOT 29 BLK 1 PECAN FOREST' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8125' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'RALPH PARR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'VICTORYLAKES INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Pecan Forest 1' ,`TaxAmount` = '5392' ,`TaxRate` = '2.0697' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1971' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669651509' WHERE `Matrix_Unique_ID` = '213982054' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-26T21:20:02.487' ,`MLSNumber` = '22004245' ,`ListAgentFullName` = 'Travis Wade' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = 'Darnell Cleary' ,`SellingOfficeName` = 'Keller Williams Realty -SW' ,`Latitude` = '29.631989' ,`Longitude` = '-95.347676' ,`PhotoCount` = '25' ,`PostalCode` = '77048' ,`RoomCount` = '10' ,`ListPrice` = '235000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Bungalow' ,`StreetNumber` = '5123' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1655' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This is a completely remodeled house completed in February or 2022. New flooring, fans and light fixtures, appliances, paint, granite countertops, sinks and plumbing fixtures, back glass door, AC system, electrical panel and water heater. This house has a large corner lot on a quiet street. 5 miles from Hobby Airport. Come by and see it.' ,`Acres` = '0.1713' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Medical Center South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 18 BLK 35 CRESTMONT PARK SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7463' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'CODWELL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'THOMAS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Crestmont Park Sec 05' ,`TaxAmount` = '1546' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1968' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669651509' WHERE `Matrix_Unique_ID` = '214023025' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-26T21:20:15.263' ,`MLSNumber` = '90077586' ,`ListAgentFullName` = 'Angelina Keck' ,`ListOfficeName` = 'Angelina Keck Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.815095' ,`Longitude` = '-95.521360' ,`PhotoCount` = '48' ,`PostalCode` = '77080' ,`RoomCount` = '16' ,`ListPrice` = '1799999.00' ,`Status` = 'Active' ,`StreetName` = 'Bauer' ,`StreetNumber` = '2316' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '5' ,`BathsHalf` = '4' ,`BedsTotal` = '5' ,`SqFtTotal` = '6588' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Be prepared to be impressed. With 5 or 6 bedrooms, 5 full baths and 4 half baths, guest quarters with kitchen, parking for 11 cars inside the garage with 3 lifts, a media room, a home gym, and a walk-in safe-THIS HOME IS A LUXURY COMPOUND for the whole family. Custom cabinetry throughout, solid wood interior doors, and a custom fence around the whole property add to the elegance of this beautiful estate. Enjoy a tropical paradise in your own backyard with the large resort-style pool with a slide and hot tub and sunning ledge. Enjoy the backyard all year round with a large covered dining area and outdoor kitchen complete with separate air conditioning and heating for outdoors. Relax by the giant wood-burning fireplace. There’s plenty of room for entertaining and playing outdoors with artificial turf everywhere allowing the majestic oaks room to grow. A 70 KW Generac whole-home generator ensures you never worry about power outages again.' ,`Acres` = '0.5795' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '5' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'TRS 27 & 28 BLK 5 SPRING BRANCH ESTATES SEC 2' ,`LotDesciption` = 'Cleared,Subdivision Lot,Wooded' ,`LotSize` = '25244' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '20' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '11' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range,Grill' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'BUFFALO CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTHBROOK HIGH SCHOOL' ,`SchoolMiddle` = 'SPRING WOODS MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access,No Supra Keybox,Request Online Appointment' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Barndominium,Mediterranean,Other Style,Traditional' ,`Subdivision` = 'Spring Branch Estates Sec 02' ,`TaxAmount` = '24415' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1992' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669651510' WHERE `Matrix_Unique_ID` = '214045195' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-26T22:02:55.460' ,`MLSNumber` = '54844662' ,`ListAgentFullName` = 'Karen Miller' ,`ListOfficeName` = 'Green And Associates, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.927539' ,`Longitude` = '-95.077225' ,`PhotoCount` = '25' ,`PostalCode` = '77532' ,`RoomCount` = '5' ,`ListPrice` = '199000.00' ,`Status` = 'Active' ,`StreetName` = 'Marlin Spike' ,`StreetNumber` = '16858' ,`StreetSuffix` = 'Way' ,`City` = 'Crosby' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1398' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This three bedroom, two bath home has recently been remodeled with laminate floor in the common areas and carpet in the bedroom. Bathroom boast new fixtures and granite countertop as does the kitchen. Brand new dishwasher and recently replaced stove. This is a family friendly neighborhood with great ammonites such as walking trails, pool and playgrounds for the kids.' ,`Acres` = '0.1928' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Crosby Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 BLK 6 NEWPORT SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '55' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '12 - Crosby' ,`SchoolElementary` = 'NEWPORT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CROSBY HIGH SCHOOL' ,`SchoolMiddle` = 'CROSBY MIDDLE SCHOOL (CROSBY)' ,`ShowInstructions` = 'Accompany,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Newport Sec 03' ,`TaxAmount` = '3969' ,`TaxRate` = '2.7105' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669651510' WHERE `Matrix_Unique_ID` = '214052958' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-26T22:23:38.667' ,`MLSNumber` = '27807378' ,`ListAgentFullName` = 'Karyn Edwards' ,`ListOfficeName` = 'Crestway Properties, LLC' ,`SellingAgentFullName` = 'Carol Brown' ,`SellingOfficeName` = 'JLA Realty' ,`Latitude` = '29.636095' ,`Longitude` = '-95.133629' ,`PhotoCount` = '39' ,`PostalCode` = '77505' ,`RoomCount` = '4' ,`ListPrice` = '350000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Double Eagle' ,`StreetNumber` = '5010' ,`StreetSuffix` = 'Drive' ,`City` = 'Pasadena' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2600' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to this beautiful FOUR-bedroom 2.5 bath house. Step inside to an inviting floor plan with living room and dining room upon entry. Recently updated. The open kitchen/family room is perfect for entertaining. Huge primary bedroom and bathroom. Detached garage. Conveniently located just minutes from hospital, shopping and dining. Don\'t miss this one!' ,`Acres` = '0.1452' ,`Area` = '6' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pasadena' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 9 BLK 1 BAYWOOD OAKS VILLAGE SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6325' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '285' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '16 - Deer Park' ,`SchoolElementary` = 'FAIRMONT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DEER PARK HIGH SCHOOL' ,`SchoolMiddle` = 'FAIRMONT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Baywood Oaks Village Sec 05' ,`TaxAmount` = '6732' ,`TaxRate` = '2.6198' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1997' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669651510' WHERE `Matrix_Unique_ID` = '214078982' --> 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','214305918','1669651510','214305918','2022-11-26T21:41:03.680','40265950','George Merrill II','Berkshire Hathaway HomeServicePremier Properties','','','29.998575','-95.551552','14','77379','9','449000.00','Active','Stockport','9726','Drive','Spring','3','1','4','3832','Single-Family','Champions Forest home with over 3,800 square feet of living space. Nestled in one of the most highly sought after neighborhoods, this 4-bedroom beautiful home will not disappoint! Primary down, three bedrooms up and is full of tastefully placed family rooms for living and entertaining. It also has a huge game room above the garage for fun and enjoyment! Several updates have been made on the inside of this home to make you want to make it yours!','0.3251','13','','','','','Mud,Sellers Disclosure','1','Gaslog Fireplace','1','Champions Area','Central Electric','1','LT 19 BLK 8 017*C2915074-003-008-019 CHAMPION FOREST SEC 3','Corner','14160','Appraisal District','','600','0','','3','Double Oven','1','In Ground','','Electric Cooktop','','Composition','32 - Klein','BRILL ELEMENTARY SCHOOL','KLEIN HIGH SCHOOL','KLEB INTERMEDIATE SCHOOL','Appointment Required,Leave Business Card,Request Online Appointment,Supra Keybox,Vacant/Unoccupied','Appraisal','2','Colonial','Champion Forest Sec 03','8258','2.3465','Water District','1979','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-26T21:38:10.587' ,`MLSNumber` = '64693700' ,`ListAgentFullName` = 'Wanda Taylor' ,`ListOfficeName` = 'Taylor Real Estate Group, Inc.' ,`SellingAgentFullName` = 'Michael Weaster' ,`SellingOfficeName` = 'Graham & Company Realty Group' ,`Latitude` = '29.794419' ,`Longitude` = '-95.489000' ,`PhotoCount` = '31' ,`PostalCode` = '77055' ,`RoomCount` = '12' ,`ListPrice` = '1650000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Glenhilshire' ,`StreetNumber` = '1315' ,`StreetSuffix` = 'Drive' ,`City` = 'Hilshire Village' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '5116' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Spacious 5 Bedroom home in sought after Hilshire Village! Located on a quiet cul de sac! Circular driveway graces front of home. Soaring ceiling in living area. Flexible Living and Dining areas. Island kitchen with gas cooktop, double ovens, warming drawer. Serving bar and walk in pantry. Separate Wine room! First floor Owners Retreat with spacious bath and large walk in closet. Upstairs has large Game Room, 4 guest Bedrooms and 3 Baths. 3 car garage! Three zones of HVAC. Zoned to Valley Oaks Elementary, Spring Branch Middle, and Memorial High! So convenient to downtown, the Galleria, I-10 corridor and Memorial Park!' ,`Acres` = '0.3051' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Memorial Villages' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'LT 2 BLK 1 GLENHILSHIRE AMENDED' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '13289' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'VALLEY OAKS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'SPRING BRANCH MIDDLE SCHOOL (SPRING BRANCH)' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Hilshire Village' ,`TaxAmount` = '36650' ,`TaxRate` = '2.4805' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669651510' WHERE `Matrix_Unique_ID` = '214533448' --> 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','214540936','1669651511','214540936','2022-11-26T21:09:13.360','88751647','Christi Hollis','J. Lindsey Properties','','','30.008926','-95.497599','49','77068','11','395000.00','Active','Hollytree','15819','Drive','Houston','2','1','4','2685','Single-Family','Great opportunity to have one of the largest lots in Oak Creek Village with 1.25 acres at 54,761 sq. ft! Contemporary home boasts of plenty of natural light, trees, side lot, ample parking with circle driveway and long drive with three car garage located at the end of a cul-de-sac. Stunning two-story stone fireplace with high ceilings and open concept in living room offers a wow factor. This home has great bones and could easily be your new dream home with some interior cosmetic updates. Large primary bedroom and bathroom on the first floor with three bedrooms upstairs with a Jack and Jill bathroom. The exterior of the home was updated in 2019 with new Hardie fiber cement siding, new roofing, new insulation, and new dual pane insulated energy efficient windows. This house has a lot to offer with great views of nature with the side lot providing extra space, peace, and serenity.','1.2571','13','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Freestanding,Gas Connections,Gaslog Fireplace','1','1960/Cypress Creek North','Central Electric','1','LTS 36 37 & TRS 38B & 46 BLK 26 OAK CREEK VILLAGE SEC 4','Cul-De-Sac,Subdivision Lot,Wooded','54761','Appraisal District','','320','0','','3','Convection Oven,Double Oven','0','','','Electric Cooktop','','Composition','48 - Spring','PAT REYNOLDS ELEMENTARY SCHOOL','WESTFIELD HIGH SCHOOL','EDWIN M WELLS MIDDLE SCHOOL','Appointment Required,Lockbox Front','Appraisal District','2','Contemporary/Modern','Oak Creek Village Sec 04','6232','2.4592','Public Sewer,Public Water,Water District','1976','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','214542489','1669651511','214542489','2022-11-26T22:30:22.243','5958437','Edgar Rodriguez','Spark Real Estate Partners','','','29.876228','-95.469888','13','77088','9','425000.00','Active','Moss Glenn','5611','Lane','Houston','2','1','4','2485','Single-Family','New Home Construction. Approximate Completion Date March 2023. Stunning Vaulted porch entrance. Split floor plan with open concept kitchen with large quarts countertop island, living area with mock electric fireplace and dining area with front yard view. 11 foot ceilings in Kitchen/Living/Dining and Primary Bedroom. Deluxe Primary bath with separate shower and soaking tub. Black casement windows. Primary Bedroom\'s walk in closet has a pocket door that leads to utility room and access to mud room and garage entrance. The Rear door leads to the covered Loggia and spacious backyard. Greater Inwood is in the heart of Beltway 8 (North) 610 N. Loop (South) 290 Fwy (West) I 45 North (East). 15 miles from Downtown Houston-Minute Maid Paid, 9.5 miles from Willowbrook Mall area, 12 miles to Galleria.','0.2112','11','Canopy Home Builders','','Electric Dryer Connections,Gas Dryer Connections','','No Disclosures','1','Mock Fireplace','1','Northwest Houston','Central Gas','1','LT 16 BLK 5 INWOOD FOREST SEC 15','Subdivision Lot','9200','Appraisal District','','500','1','To Be Built/Under Construction','2','Freestanding Oven,Gas Oven','0','','','Gas Range','','Composition','1 - Aldine','CARAWAY ELEMENTARY SCHOOL (ALDINE)','EISENHOWER HIGH SCHOOL','HOFFMAN MIDDLE SCHOOL','Temporarily No Showings','Builder','1','Traditional','Inwood Forest','4919','2.5119','Public Sewer,Public Water','2023','Builder'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-26T22:13:59.627' ,`MLSNumber` = '91363245' ,`ListAgentFullName` = 'Cate Gao' ,`ListOfficeName` = 'Southwest Realty Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.045516' ,`Longitude` = '-95.579125' ,`PhotoCount` = '47' ,`PostalCode` = '77379' ,`RoomCount` = '6' ,`ListPrice` = '449000.00' ,`Status` = 'Active' ,`StreetName` = 'Wealden Forest' ,`StreetNumber` = '1302' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3293' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Elegant and gorgeous two-story home with 4 bed/3.5 bath located in the highly sought-after Gleannloch Farms subdivision. This house features many upgrades made in 2019 with laminate floor downstairs, engineered wood floor upstairs and one extra room which is perfect for the secondary office or media room with a beautiful barn door. Spacious office with French doors and a formal dining room welcomes you. High ceiling family room with a wall of windows brightens the home. Large master suite with an upgraded bathroom and closet makes you feel cozy and relaxed. Garage with 3 car spaces and an electric car charger, surge protectors for newer A/C\'s and shelving storage are very practical. Short distance to community pools, golf course, playground and picnic area, recreation center, gym, great schools, and groceries are so convenient and enjoyable! Schedule showing today!' ,`Acres` = '0.1791' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein/Tomball' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 8 BLK 3 GLEANNLOCH FARMS SEC 17' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'HASSLER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN CAIN HIGH SCHOOL' ,`SchoolMiddle` = 'DOERRE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Gleannloch Farms Sec 17' ,`TaxAmount` = '9266' ,`TaxRate` = '2.6115' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669651511' WHERE `Matrix_Unique_ID` = '214543756' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-26T21:40:46.427' ,`MLSNumber` = '91129101' ,`ListAgentFullName` = 'Beth Ferester' ,`ListOfficeName` = 'CORCORAN FERESTER REALTY' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.176820' ,`Longitude` = '-95.579062' ,`PhotoCount` = '35' ,`PostalCode` = '77382' ,`RoomCount` = '10' ,`ListPrice` = '460000.00' ,`Status` = 'Active' ,`StreetName` = 'Archwyck' ,`StreetNumber` = '118' ,`StreetSuffix` = 'Circle' ,`City` = 'The Woodlands' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2269' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Here is a hard-to-find one story all brick home in The Woodlands village of Sterling Ridge. The current owners have done so many updates to the home including a remodeled kitchen with a large butcher block Mahogany island, upgraded Samsung appliances, quartz counters with marble tile backsplash, and lots of cabinets. The home has hickory floors throughout, a lovely primary bath updated with a large shower and soaking tub. All this, plus a covered patio and nice yard, large enough for a pool.' ,`Acres` = '0.176' ,`Area` = '15' ,`BuilderName` = 'Village Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'S969942 - WDLNDS VIL STERLING RIDGE 42, BLOCK 1, LOT 41' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '7667' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'TOUGH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'THE WOODLANDS HIGH SCHOOL' ,`SchoolMiddle` = 'MCCULLOUGH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Wdlnds Village Sterling Ridge 42' ,`TaxAmount` = '7108' ,`TaxRate` = '2.1816' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669651511' WHERE `Matrix_Unique_ID` = '214735714' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-26T22:59:52.823' ,`MLSNumber` = '18903640' ,`ListAgentFullName` = 'Helen Nguyen' ,`ListOfficeName` = 'LV Realty & Services' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.540707' ,`Longitude` = '-95.737181' ,`PhotoCount` = '27' ,`PostalCode` = '77469' ,`RoomCount` = '7' ,`ListPrice` = '345000.00' ,`Status` = 'Active' ,`StreetName` = 'Summer Creek' ,`StreetNumber` = '219' ,`StreetSuffix` = 'Lane' ,`City` = 'Rosenberg' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2173' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Lovely Single story 4/2/2 now available in Summer Lakes. Formal Dining and Study (Could be used as 4th bedroom) with French door off the large entryway. Elegant kitchen that opens to family room. This home also features lots of windows with natural light from all angles. Covered Patio and large back yard provide full of out door activities. Fresh interior paint. Easy access to 59 S & Grand Parkway. Grade A Schools & Plethora of Amenities nearby. Ready to move in incoming Christmas. Come take a look!' ,`Acres` = '0.1685' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SUMMER LAKES SEC 2, BLOCK 2, LOT 29' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7339' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'WILLIAMS ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'RANDLE HIGH SCHOOL' ,`SchoolMiddle` = 'WRIGHT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Summer Lakes Sec 2' ,`TaxAmount` = '6525' ,`TaxRate` = '2.8448' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669651511' WHERE `Matrix_Unique_ID` = '214815757' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-26T22:26:05.083' ,`MLSNumber` = '90382143' ,`ListAgentFullName` = 'Judy Anderson' ,`ListOfficeName` = 'Texas United Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.306675' ,`Longitude` = '-95.573602' ,`PhotoCount` = '42' ,`PostalCode` = '77316' ,`RoomCount` = '9' ,`ListPrice` = '929900.00' ,`Status` = 'Active' ,`StreetName` = 'Rolling Oak DR' ,`StreetNumber` = '6467' ,`StreetSuffix` = 'Drive' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '5' ,`BedsTotal` = '4' ,`SqFtTotal` = '2906' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Equestrian Estate nestled in 5.882 acres of park-like setting with privacy gate/key pad entrance!! Home features:4 bedrooms, 2 1/2 baths, upstairs game room w/oak wainscoting & custom cabinets, kitchen w/tile floor, granite counters, walk-in pantry, double oven, island & breakfast bar, solar panels for electricity savings, tankless water heaters, dual zone A/C & furnace, large front & back porches. Property boasts over-sized 2 car garage w/custom cabinets, large toy barn/shop garage w/ engineered trusses (no poles), RV porte-cochere w/elec & water, custom 4-stall metal horse barn w/storage, climate-controlled tack room &\r\nautomatic waters/flow meters, & separate hay bldg. Majority of property is fenced with heavy-duty 3-rail vinyl cross fenced paddock area. Invisible Fence dog area and \"Doorman\" dog door. Easy access 2nd entrance for larger vehicles/trailers on Fisher Lake Court. Minutes away from shopping , Woodforest golf course &Woodland Express P&R to Downtown Houston.' ,`Acres` = '5.882' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Electric,Solar Assisted' ,`HOAMandatory` = '1' ,`Legal` = 'S728109 MONTGOMERY TRACE 09, BLOCK 3, LOT 16, 17, 18, 19,20' ,`LotDesciption` = 'Corner' ,`LotSize` = '256220' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2000' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'STEWART ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Call Occupant,Controlled Access,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Montgomery Trace' ,`TaxAmount` = '13095' ,`TaxRate` = '1.8488' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669651512' WHERE `Matrix_Unique_ID` = '214922555' --> 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','215070601','1669651512','215070601','2022-11-26T21:29:47.080','92030662','Katie Wells','Del Monte Realty','','','29.690126','-95.470598','20','77401','5','525000.00','Active','Mimosa','5127','Drive','Bellaire','1','1','3','1518','Single-Family','Beautifully maintained original Bellaire home. Only two owners - this property is perfect to live in now and build later! Ideally situated on the middle of the block of a neighborhood street, this gorgeous lot has mature trees and backs to a city easement. Ultimate privacy with no backyard neighbors! Zoned to incredible schools and within close proximity to some of the best restaurants, entertaining and shopping in the city!','0.1716','17','','','Electric Dryer Connections,Washer Connections','','Exclusions','1','','1','Bellaire Area','Central Gas','0','LT 6 BLK 2 BRAEBURN GARDENS SEC 2','Subdivision Lot','7475','Appraisal District','','','0','','','Electric Oven','0','','','Gas Range','','Composition','27 - Houston','LOVETT ELEMENTARY SCHOOL','BELLAIRE HIGH SCHOOL','PERSHING MIDDLE SCHOOL','Appointment Required,Controlled Access,Lockbox Front','Appraisal District','1','Traditional','Braeburn Gardens','8581','2.2271','Public Sewer,Public Water','1952','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','215105675','1669651512','215105675','2022-11-26T21:58:23.640','25530986','Maria Bonilla','Walzel Properties','','','29.831306','-95.315038','0','77016','5','224597.00','Active','Peachtree','7814','Street','Houston','2','0','3','1350','Single-Family','Over size lot with plenty of room for entertaining. This house offers lots of natural light with an open concept and upgraded kitchen countertop and flooring \r\nschedule your showing today.','0.2755','2','Europa Homes','','Electric Dryer Connections,Washer Connections','','No Disclosures','1','','','Northside','Central Electric','0','LT 1186 BLK 10 TRINITY GARDENS SEC 3','Subdivision Lot','12000','Appraisal District','','','1','To Be Built/Under Construction','0','Freestanding Oven','0','','','Freestanding Range','','Composition','27 - Houston','COOK ELEMENTARY SCHOOL (HOUSTON)','KASHMERE HIGH SCHOOL','KEY MIDDLE SCHOOL','Appointment Required','Builder','1','Traditional','Trinity Gardens Sec 03','','','Public Sewer,Public Water','2023','Builder'); --> New record created successfully