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-10-18T22:48:53.863' ,`MLSNumber` = '64538046' ,`ListAgentFullName` = 'Natalie Lerner' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.955118' ,`Longitude` = '-95.368306' ,`PhotoCount` = '37' ,`PostalCode` = '77541' ,`RoomCount` = '7' ,`ListPrice` = '179999.00' ,`Status` = 'Active' ,`StreetName` = 'Broad' ,`StreetNumber` = '1631' ,`StreetSuffix` = 'Street' ,`City` = 'Freeport' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1692' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This coastal city 3 bedroom/2 bath/2 car garage home sits atop a huge 14,000 square foot corner lot and has been largely renovated and well maintained! Fresh paint, hardi-plank paneling, electrical, foundation, landscaping, bathrooms, countertops, floors, and a roof have all been updated over the course of the last year! Four wall-sized windows greet visitors from the front of the home and invite sunlight throughout all shared living spaces. Close to popular fishing spots, nature, beaches, schools, highway access and more! Schedule a showing today!' ,`Acres` = '0.3214' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Freeport' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'FREEPORT, BLOCK 165, LOT 1' ,`LotDesciption` = 'Corner' ,`LotSize` = '14000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Built Up' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'VELASCO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRAZOSPORT HIGH SCHOOL' ,`SchoolMiddle` = 'FREEPORT INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Left Side,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Freeport' ,`TaxAmount` = '2214' ,`TaxRate` = '2.5981' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1942' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666203144' WHERE `Matrix_Unique_ID` = '209462869' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-18T22:58:40.560' ,`MLSNumber` = '96752474' ,`ListAgentFullName` = 'Dakar Gibbs' ,`ListOfficeName` = 'Century 21 ExclusiveProperties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.849981' ,`Longitude` = '-95.418344' ,`PhotoCount` = '20' ,`PostalCode` = '77091' ,`RoomCount` = '7' ,`ListPrice` = '522944.00' ,`Status` = 'Active' ,`StreetName` = 'Paul Quinn' ,`StreetNumber` = '807' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2264' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Paul Quinn Place features 4 individually gated single family contemporary homes with remote gate access and guest parking. 807 Paul Quinn features the 2,264SF Oleander plan with 3 BR, 3.5 BTH, game room and massive 3rd floor patio set up for outdoor kitchen. Front elevation features 21” of beautiful stone and 4x8 hardie! Porcelain, quartz and glass in bathrooms! Soft close cabinets! 10’ ceilings on 1st and 2nd floors! 9’ ceiling on 3rd floor! Large bedrooms/closets! Tall ceilings! Custom doors! Plenty of natural light! Custom glass balcony rails! Smart wired including garage! Lots of storage space! Great finishes! Plenty of amenities within 3 miles or less (Memorial Hermann Greater Heights, Starbucks, BofA, Chase, BBVA, Home Depot, Lowe’s, HEB, Kroger, Berryhill, Five Guys, Walking Stick, Oak Forest Public Library, I-45, and 610) No HOA dues! Centrally located 8 miles from downtown! Ask about appliance package if you close by 12/09/22. Custom Urban Living! Schedule showing today!' ,`Acres` = '0' ,`Area` = '9' ,`BuilderName` = '44 Builders LLC' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 2 BLK 1 PAUL QUINN PLACE' ,`LotDesciption` = 'Cleared,Corner' ,`LotSize` = '1991' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HIGHLAND HEIGHTS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WASHINGTON HIGH SCHOOL' ,`SchoolMiddle` = 'WILLIAMS MIDDLE SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'HIGHLAND HEIGHTS ANNEX' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666203144' WHERE `Matrix_Unique_ID` = '209533973' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-18T22:47:29.453' ,`MLSNumber` = '60956571' ,`ListAgentFullName` = 'Brooke Mason' ,`ListOfficeName` = 'Cross-Town Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.631944' ,`Longitude` = '-97.007364' ,`PhotoCount` = '16' ,`PostalCode` = '76567' ,`RoomCount` = '4' ,`ListPrice` = '121900.00' ,`Status` = 'Active' ,`StreetName` = 'Holly' ,`StreetNumber` = '441' ,`StreetSuffix` = 'Drive' ,`City` = 'Rockdale' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1621' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Don\'t miss this 3/1 property nestled away in a quite neighborhood in Rockdale. This property also has an extra room that can be set up to meet the buyer\'s needs. Carport, metal roof and spacious lot size are more not to miss features in Rockdale!' ,`Acres` = '0.2583' ,`Area` = '71' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Propane' ,`HOAMandatory` = '0' ,`Legal` = 'S16800 PRAESEL I BLK 11 LOT 2' ,`LotDesciption` = 'Other' ,`LotSize` = '11252' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '126 - Rockdale' ,`SchoolElementary` = 'ROCKDALE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ROCKDALE HIGH SCHOOL' ,`SchoolMiddle` = 'ROCKDALE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Back,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Praesel I' ,`TaxAmount` = '1898' ,`TaxRate` = '2.0522' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '0' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666203145' WHERE `Matrix_Unique_ID` = '210607425' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-18T23:01:15.030' ,`MLSNumber` = '12017923' ,`ListAgentFullName` = 'Jen Tran' ,`ListOfficeName` = 'Keller Williams Realty - Memorial' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.775848' ,`Longitude` = '-95.482817' ,`PhotoCount` = '47' ,`PostalCode` = '77024' ,`RoomCount` = '9' ,`ListPrice` = '899000.00' ,`Status` = 'Active' ,`StreetName` = 'Chimney Rock' ,`StreetNumber` = '218' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '3114' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Nestled amongst the trees of Memorial lies this amazing 3 bed/4 bath Midcentury home. Come fall in love with the unique style of the home with its elegant marbled entry. Entertain your guests in the large, front drawing room & then move onto dinner in the formal dining room with its soaring, vaulted ceilings. The upgraded kitchen overlooks the breakfast area & family room. Along the other side of the kitchen, you can access the powder room with shower, laundry facilities & garage. Relax & enjoy 1 of the 2 fireplaces & the fabulous views of the backyard from the cozy family room. Just down the hallway, you will find 3 bedrooms - each with their own bathroom. An extra room can be used as a small office or craft room. This beautiful home sits on almost half an acre with frontage on both Chimney Rock & Westminster. The huge backyard has plenty of space for a pool. Amazing location and zoned to highly sought after Spring Branch ISD and Memorial HS. Never flooded! See it today!' ,`Acres` = '0.4659' ,`Area` = '23' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Memorial Close In' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 72 BLK 4 HUNTLEIGH' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '20295' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'HUNTERS CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'SPRING BRANCH MIDDLE SCHOOL (SPRING BRANCH)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Huntleigh' ,`TaxAmount` = '22156' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1953' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666203145' WHERE `Matrix_Unique_ID` = '210652536' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-18T23:02:59.657' ,`MLSNumber` = '18037077' ,`ListAgentFullName` = 'Zheng Zhuang' ,`ListOfficeName` = 'KingFay Inc' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.812765' ,`Longitude` = '-95.709197' ,`PhotoCount` = '24' ,`PostalCode` = '77084' ,`RoomCount` = '4' ,`ListPrice` = '299900.00' ,`Status` = 'Active' ,`StreetName` = 'Maywood Falls' ,`StreetNumber` = '19423' ,`StreetSuffix` = 'Circle' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2370' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'House Never Flooded! 2022 May New Roof, New Water Heater, New Garage Door, New Toliet, and New Paint, 2016 A/C. Beautiful 2-story home with 4 bedrooms, 3 full baths featuring a bedroom on the first floor, not the Master. Bright open floor plan with lots of windows, neutral colors, high ceilings, and ceiling fans with a gas log fireplace in the living area. Large roomy kitchen with tile backsplash, Corian countertops, built-in microwave, gas stove, and tile floor. Large Master with large walk-in closet featuring built-ins. The Master bath has a stand-up shower with a garden tub and his and hers vanities. The home has a fenced-in back yard with patio/deck, recently shampooed carpets throughout, repairs done to fence and wood steps, refinished exterior door, power washed driveway, walkway, patio, back area exterior of the house, This home is located near a park and area shopping. Schedule your appointment today! The buyer has completely fallen through the loan.' ,`Acres` = '0.1085' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 7 BLK 5 LAKE RIDGE SEC 1' ,`LotDesciption` = 'Cleared' ,`LotSize` = '4725' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '481' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '60' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'RHOADS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAYDE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MAYDE CREEK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Lake Ridge Sec 01' ,`TaxAmount` = '5045' ,`TaxRate` = '2.487' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666203145' WHERE `Matrix_Unique_ID` = '210877108' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-18T23:46:34.500' ,`MLSNumber` = '84746471' ,`ListAgentFullName` = 'Erete Ebong' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.575645' ,`Longitude` = '-95.686447' ,`PhotoCount` = '7' ,`PostalCode` = '77479' ,`RoomCount` = '6' ,`ListPrice` = '400000.00' ,`Status` = 'Active' ,`StreetName` = 'Sparrow Branch' ,`StreetNumber` = '2402' ,`StreetSuffix` = 'Court' ,`City` = 'Sugar Land' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2724' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'INVESTORS SPECIAL. BRING ALL OFFERS!!! MOTIVATED SELLER. \r\n\r\nTHIS FOUR BEDROOM, TWO AND HALF BATHROOM HAS IT ALL. HUGE BEDROOMS, AND BACK YARD.' ,`Acres` = '0.1759' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Sugar Land West' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'RIVERPARK SEC 6, BLOCK 1, LOT 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7664' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'HUTCHISON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR CONSOLIDATED HIGH SCHOOL' ,`SchoolMiddle` = 'WESSENDORF/LAMAR JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Riverpark Sec 6' ,`TaxAmount` = '6785' ,`TaxRate` = '2.6977' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666203145' WHERE `Matrix_Unique_ID` = '210974780' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-18T23:47:20.207' ,`MLSNumber` = '29752620' ,`ListAgentFullName` = 'Heather Groom' ,`ListOfficeName` = 'Doug Erdy Group' ,`SellingAgentFullName` = 'Trinh Tran' ,`SellingOfficeName` = 'Lone Star Realty' ,`Latitude` = '29.965653' ,`Longitude` = '-95.157145' ,`PhotoCount` = '47' ,`PostalCode` = '77044' ,`RoomCount` = '15' ,`ListPrice` = '539999.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Bend Rock' ,`StreetNumber` = '14006' ,`StreetSuffix` = 'Way' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4021' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'STOP! LOOK NO FURTHER! Fresh paint, new flooring, recently updated October 2022!Waters Edge is a gated community sitting on Lake Houston. Beautiful brick and stone home with all the amenities in one place! 3 car oversized garage, 4 to 5 bed, 3 1/2 bath, game room and a flex room, with and office! Venture into this breathtaking back yard that is in 3 sections, it starts with a huge, covered patio, an outdoor kitchen, swimming pool, built in fire pit seating and misters along the back of the home to make your time here even more enjoyable. Left of the pool is a gated garden area with a Peach tree accompanied by Pineapple Guava, Blueberry, Blackberry Brambles. Right of the pool and sitting area behind the Pergola is another gated area with mature Fig, Pecan and Key Lime trees. Backyard is fully fenced in for your furry friends.' ,`Acres` = '0.2979' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Summerwood/Lakeshore' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 9 BLK 2 WATERS EDGE SEC 3' ,`LotDesciption` = 'Cleared,Water View' ,`LotSize` = '12978' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1330' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'LAKESHORE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'WEST LAKE MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Waters Edge Sec 03' ,`TaxAmount` = '12057' ,`TaxRate` = '3.1539' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1666203145' WHERE `Matrix_Unique_ID` = '210998960' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-18T23:56:38.743' ,`MLSNumber` = '29535266' ,`ListAgentFullName` = 'Maria Alanis' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.454120' ,`Longitude` = '-95.840926' ,`PhotoCount` = '43' ,`PostalCode` = '77461' ,`RoomCount` = '5' ,`ListPrice` = '410000.00' ,`Status` = 'Active' ,`StreetName` = 'Paloma' ,`StreetNumber` = '5903' ,`StreetSuffix` = 'Lane' ,`City` = 'Needville' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2048' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '1 hour notice to show propety! Lovely country home in the country, near the city. Features lovely spacious country kitchen, spacious master bedroom with spacious bathroom with Jacuzzi, split bedroom plan with spacious hallway for remaining bedrooms, laundry area, office area, spacious living area. This property is a little over 2 acres, includes a large detached steel building as garage. 2 recent air conditioning units, 4 ton, 31/2 ton, spacious home. New windows in master bedroom, 4 new windows in back side of house. aerobic septic system. Come see this lovely home in the country!! You won\'t regret it. Lots of trees, no back neighbors, corner lot. Low taxes, many,many trees in backyard and pond when plenty of rain. Spacious lot with alot of room for parking, bring your trucks, trailers, country living very near the city of Rosenberg, Richmond, near freeway 59. Lovely home and property overall!!!' ,`Acres` = '2.11' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = '0241 H AND TC RY, BLOCK 3, ACRES 1.124, LOT 40 CHAPARRAL ACR' ,`LotDesciption` = 'Corner' ,`LotSize` = '91476' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '38 - Needville' ,`SchoolElementary` = 'NEEDVILLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NEEDVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'NEEDVILLE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'H & Tc Ry' ,`TaxAmount` = '3239' ,`TaxRate` = '1.8957' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1666203146' WHERE `Matrix_Unique_ID` = '211075080' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-18T22:51:58.053' ,`MLSNumber` = '86065870' ,`ListAgentFullName` = 'Christina Harris' ,`ListOfficeName` = 'Styled Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.975291' ,`Longitude` = '-95.690000' ,`PhotoCount` = '29' ,`PostalCode` = '77429' ,`RoomCount` = '12' ,`ListPrice` = '875000.00' ,`Status` = 'Active' ,`StreetName` = 'Swansbury' ,`StreetNumber` = '17311' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2386' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Enjoy country living in the heart of Cypress, TX! This immaculate property has it all, a gorgeous pool, 6 horse stalls and a spacious metal barn with concrete flooring all nestled on 2.49 UNRESTRICTED acres! This 4 bed, 3 bath home has fresh interior paint all throughout with an open living room flourished with custom plastering shelving surrounding the stone wood burning fireplace and fresh carpeting within. Brand new air conditioning unit recently installed, 3 year old roof and manicured landscaping all around the perimeter. Just minutes away from 290 & less than 10 minutes from the 290 outlet mall. It doesn\'t get much better than this. Did I mention I have NO RESTRICTIONS! Come see me before I\'m gone!' ,`Acres` = '2.499' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Propane' ,`HOAMandatory` = '0' ,`Legal` = 'TR 37A W PT LT 37 CYPRESS VILLAGE U/R' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '108856' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'A ROBISON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS WOODS HIGH SCHOOL' ,`SchoolMiddle` = 'SPILLANE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Left Side' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cypress Village U/R' ,`TaxAmount` = '7318' ,`TaxRate` = '2.091' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1976' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666203146' WHERE `Matrix_Unique_ID` = '211115299' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-18T23:37:41.173' ,`MLSNumber` = '6601049' ,`ListAgentFullName` = 'Glenda Jackson' ,`ListOfficeName` = 'Jackson Enterprises' ,`SellingAgentFullName` = 'Fanny Castro' ,`SellingOfficeName` = 'Keller Williams HoustonCentral' ,`Latitude` = '29.674763' ,`Longitude` = '-95.306954' ,`PhotoCount` = '14' ,`PostalCode` = '77087' ,`RoomCount` = '7' ,`ListPrice` = '183500.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Cherrydale' ,`StreetNumber` = '6823' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1630' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hobby Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'Andover Place' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7552' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'GREGG ELEMENTARY SCHOOL' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'HARTMAN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Andover Place' ,`TaxAmount` = '2617' ,`TaxRate` = '2.33' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1957' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666203146' WHERE `Matrix_Unique_ID` = '211395491' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-18T23:07:27.270' ,`MLSNumber` = '93642124' ,`ListAgentFullName` = 'Travis Humphreys' ,`ListOfficeName` = 'Executive Texas Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.286436' ,`Longitude` = '-95.172246' ,`PhotoCount` = '24' ,`PostalCode` = '77328' ,`RoomCount` = '3' ,`ListPrice` = '216500.00' ,`Status` = 'Active' ,`StreetName` = 'Ivy' ,`StreetNumber` = '25131' ,`StreetSuffix` = 'Lane' ,`City` = 'Cleveland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1416' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'REDUCEDDDDD!!! Welcome to this sweet home on a large but manageable lot! Country vibes with easy access and commute to Houston and in a growing area!' ,`Acres` = '0.2204' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'NORTH WOODS 01, LOT 11' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '9600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '24' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '47 - Splendora' ,`SchoolElementary` = 'GREENLEAF ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPLENDORA HIGH SCHOOL' ,`SchoolMiddle` = 'SPLENDORA JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'North Woods 01' ,`TaxAmount` = '3730' ,`TaxRate` = '2.0783' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2009' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666203146' WHERE `Matrix_Unique_ID` = '211404354' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-18T22:57:44.587' ,`MLSNumber` = '74572350' ,`ListAgentFullName` = 'Dakar Gibbs' ,`ListOfficeName` = 'Century 21 ExclusiveProperties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.849981' ,`Longitude` = '-95.418344' ,`PhotoCount` = '23' ,`PostalCode` = '77091' ,`RoomCount` = '7' ,`ListPrice` = '522944.00' ,`Status` = 'Active' ,`StreetName` = 'Paul Quinn' ,`StreetNumber` = '809' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2264' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Paul Quinn Place features 4 individually gated single family contemporary homes with remote gate access and guest parking. 807 Paul Quinn features the 2,264SF Oleander plan with 3 BR, 3.5 BTH, game room and massive 3rd floor patio set up for outdoor kitchen. Front elevation features 21” of beautiful stone and 4x8 hardie! Porcelain, quartz and glass in bathrooms! Soft close cabinets! 10’ ceilings on 1st and 2nd floors! 9’ ceiling on 3rd floor! Large bedrooms/closets! Tall ceilings! Custom doors! Plenty of natural light! Custom glass balcony rails! Smart wired including garage! Lots of storage space! Great finishes! Plenty of amenities within 3 miles or less (Memorial Hermann Greater Heights, Starbucks, BofA, Chase, BBVA, Home Depot, Lowe’s, HEB, Kroger, Berryhill, Five Guys, Walking Stick, Oak Forest Public Library, I-45, and 610) No HOA dues! Centrally located 8 miles from downtown! Ask about appliance package if you close by 12/09/22. Custom Urban Living! Schedule showing today!' ,`Acres` = '0' ,`Area` = '9' ,`BuilderName` = '44 Builders LLC' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 3 BLK 1 PAUL QUINN PLACE' ,`LotDesciption` = 'Cleared,Corner' ,`LotSize` = '1946' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HIGHLAND HEIGHTS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WASHINGTON HIGH SCHOOL' ,`SchoolMiddle` = 'WILLIAMS MIDDLE SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'HIGHLAND HEIGHTS ANNEX' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666203146' WHERE `Matrix_Unique_ID` = '211412509' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-18T23:51:00.070' ,`MLSNumber` = '65854452' ,`ListAgentFullName` = 'Cameron Namazi' ,`ListOfficeName` = 'Summit Realty' ,`SellingAgentFullName` = 'Christine Kwan' ,`SellingOfficeName` = 'Premier Realty & Associates' ,`Latitude` = '29.577150' ,`Longitude` = '-95.759529' ,`PhotoCount` = '16' ,`PostalCode` = '77469' ,`RoomCount` = '3' ,`ListPrice` = '53900.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Burnet' ,`StreetNumber` = '406' ,`StreetSuffix` = 'Street' ,`City` = 'Richmond' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '768' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'INVESTORS DREAM / HANDYMAN SPECIAL. House needs TLC. Selling for lot value. The home is centrally located in the Richmond area mins away from downtown, near museums, local winery, Parks, the Brazos River, and the Oakbend Medical Center. Easy access to Southwest and 90 Fwy.' ,`Acres` = '0.0723' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = 'RICHMOND , BLOCK 10, LOT 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '3150' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'LONG ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'LAMAR CONSOLIDATED HIGH SCHOOL' ,`SchoolMiddle` = 'WESSENDORF/LAMAR JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Richmond' ,`TaxAmount` = '814' ,`TaxRate` = '2.3748' ,`WaterSewer` = 'No Sewer,No Water' ,`YearBuilt` = '1941' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666203146' WHERE `Matrix_Unique_ID` = '211771886' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-18T23:09:53.833' ,`MLSNumber` = '90357295' ,`ListAgentFullName` = 'Elizabeth Watkins' ,`ListOfficeName` = 'The Watkins Group Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.875511' ,`Longitude` = '-95.467700' ,`PhotoCount` = '43' ,`PostalCode` = '77088' ,`RoomCount` = '6' ,`ListPrice` = '235000.00' ,`Status` = 'Active' ,`StreetName` = 'Bent Bough' ,`StreetNumber` = '5419' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2895' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This spacious home is located on a tree lined cul de sac in Inwood Forest. Very lovely home is just waiting for your updates. A traditional one story with a separate level fourth bedroom and en suite bath with a private stairway entrance off den. Extra large lot, which backs onto green space. Minutes from downtown Houston, IAH Airport, Minute Maid, NRG, Toyota and other stadiums. Seller does not have survey, buyer to purchase if needed. Home is not in flood zone. *Only offers submitted on TREC 1-4 Residential Contract will be responded to.' ,`Acres` = '0.2094' ,`Area` = '11' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 3 BLK 3 INWOOD FOREST SEC 5' ,`LotDesciption` = 'Greenbelt,Other,Subdivision Lot' ,`LotSize` = '9120' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '315' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'CARAWAY ELEMENTARY SCHOOL (ALDINE)' ,`SchoolHigh` = 'EISENHOWER HIGH SCHOOL' ,`SchoolMiddle` = 'HOFFMAN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Left Side,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch,Split Level' ,`Subdivision` = 'Inwood Forest' ,`TaxAmount` = '4617' ,`TaxRate` = '2.5119' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1968' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666203147' WHERE `Matrix_Unique_ID` = '211973794' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-18T23:14:26.690' ,`MLSNumber` = '95118403' ,`ListAgentFullName` = 'Robbie Jansky' ,`ListOfficeName` = 'Keller Williams Realty -SW' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.810859' ,`Longitude` = '-95.702308' ,`PhotoCount` = '46' ,`PostalCode` = '77084' ,`RoomCount` = '10' ,`ListPrice` = '350000.00' ,`Status` = 'Active' ,`StreetName` = 'Youpon Hill' ,`StreetNumber` = '19026' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3617' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful CORNER lot home has OPEN CONCEPT floor plan great for ENTERTAINING. The kitchen has a modern feel that has stainless steel appliances, an island w/ plenty of cabinet & counter space that overlooks the family room. The family room has OVERSIZED WINDOWS and FIREPLACE making this space very inviting. The Owners Retreat is downstairs and cozy with soaking tub, separate shower and large walk-in closet. UPSTAIRS you will find the large game room and FOUR spacious bedrooms suitable for growing. The backyard has plenty of room for your pup or a playscape and has a storage shed for garden tools. This gem is CENTRALLY located and offers walk to school, neighborhood pool or walking/exercise trails from your front door! You\'ll want to see this home, schedule an appointment TODAY!' ,`Acres` = '0.1699' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 55 BLK 3 OAK RIDGE PLACE SEC 1' ,`LotDesciption` = 'Corner,Cul-De-Sac' ,`LotSize` = '7403' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '585' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'MAYDE CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAYDE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MAYDE CREEK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Oak Ridge Place' ,`TaxAmount` = '6831' ,`TaxRate` = '2.487' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666203147' WHERE `Matrix_Unique_ID` = '212012134' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-18T22:55:11.817' ,`MLSNumber` = '84087638' ,`ListAgentFullName` = 'Amanda Garayeva' ,`ListOfficeName` = 'Texas Management Partners LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.337643' ,`Longitude` = '-95.488495' ,`PhotoCount` = '30' ,`PostalCode` = '77304' ,`RoomCount` = '8' ,`ListPrice` = '339000.00' ,`Status` = 'Active' ,`StreetName` = 'Pagemill' ,`StreetNumber` = '1911' ,`StreetSuffix` = 'Lane' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2500' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Honey, Stop the car! What a cozy single story home on a quite dead end street in Graystone Hills, with no neighbors behind! Interior colors will go with most decor. Back fence replaced and epoxy garage flooring were improvements made last year. Upgraded hardwood flooring in 2017 in living room, study, dining room and hallway. The study directly off the living area can also be used as a 4th bedroom. The backyard brick patio is not permanent and can be removed, It provides a nice outdoor sitting area. Neighborhood has elementary school right around the corner in the subdivision. FRIDGE (8 months old)/WASHER/DRYER INCLUDED. \r\n\r\n\r\n*Disclaimer: Listing broker’s offer of compensation is made only to participants of the MLS where the listing is filed.' ,`Acres` = '0.1791' ,`Area` = '19' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S539303 - GRAYSTONE HILLS 03, BLOCK 1, LOT 42' ,`LotDesciption` = 'Other' ,`LotSize` = '7800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '825' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'GIESINGER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Graystone Hills 03' ,`TaxAmount` = '7421' ,`TaxRate` = '2.7763' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '2009' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666203147' WHERE `Matrix_Unique_ID` = '212236785' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-18T22:46:16.120' ,`MLSNumber` = '93355153' ,`ListAgentFullName` = 'Elizabeth Watkins' ,`ListOfficeName` = 'The Watkins Group Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.372859' ,`Longitude` = '-94.983484' ,`PhotoCount` = '27' ,`PostalCode` = '77568' ,`RoomCount` = '3' ,`ListPrice` = '215000.00' ,`Status` = 'Active' ,`StreetName` = 'Lake Park' ,`StreetNumber` = '2632' ,`StreetSuffix` = 'Drive' ,`City` = 'La Marque' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1633' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Looking for land, with a pool, in a cul de sac, away from the big city? You\'ve found it! 2632 Lake Park is an expansive 15,000 plus sf yard, with a pool ready for some cool weather dips! Home has 3 spacious bedrooms with two full bathrooms. Easy to navigate kitchen with updated stainless steel appliances, including a 6 burner gas stove and recently upgraded Shaker style cabinets. Refrigerator stays with the home. Updated quartz counters and tile floors throughout home. Enjoy the privacy of your pool with no back neighbors. Lots of shade trees to host that family or friends, swim and BBQ. Property is not located in a flood zone. This home truly offers the getaway you need to come home to.' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'La Marque' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 150 J D MOORE SUR LOT 18 LAKE PARK' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '15682' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '52 - Texas City' ,`SchoolElementary` = 'HAYLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA MARQUE HIGH SCHOOL (TEXAS CITY)' ,`SchoolMiddle` = 'LA MARQUE MIDDLE SCHOOL (TEXAS CITY)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Rosewood' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '1975' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666203147' WHERE `Matrix_Unique_ID` = '212306454' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-18T22:45:05.030' ,`MLSNumber` = '98999470' ,`ListAgentFullName` = 'Jade Ngoc Truong' ,`ListOfficeName` = 'V-Pro Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.990856' ,`Longitude` = '-95.718211' ,`PhotoCount` = '25' ,`PostalCode` = '77429' ,`RoomCount` = '7' ,`ListPrice` = '389950.00' ,`Status` = 'Active' ,`StreetName` = 'Appian Oak' ,`StreetNumber` = '14819' ,`StreetSuffix` = 'Street' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2515' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Nice Briarwood Homes in lakes community with stone elevation. Its location is on first street from Louetta. Some steps walking to subdivision swimming pool and. playground for children. High ceiling. Open floor plan. Split plan for bedrooms. Granite counter top, under mount deep sink, walk-in pantry. Garden bathtub and separate shower plus 2 sinks in primary bathroom. Walk-in closets in bedrooms. Formal dining & formal living. Extra half bathroom for guests. Minutes to Houston Premier Outlet, Cypress Town Center, freeway 290 and Grand Parkway 99. Excellent Cy-Fair ISD Schools. NO FLOODED.' ,`Acres` = '0.1658' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 20 BLK 1 VILLAGES OF CYPRESS LAKES SEC 8' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '7223' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '910' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'KEITH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS WOODS HIGH SCHOOL' ,`SchoolMiddle` = 'GOODSON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Maple Rdg Place Sec 6' ,`TaxAmount` = '7622' ,`TaxRate` = '3.061' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666203147' WHERE `Matrix_Unique_ID` = '212373527' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-18T22:58:30.310' ,`MLSNumber` = '11513594' ,`ListAgentFullName` = 'Debra Shelly' ,`ListOfficeName` = 'Westchase Realty Services' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.875871' ,`Longitude` = '-95.137442' ,`PhotoCount` = '44' ,`PostalCode` = '77044' ,`RoomCount` = '11' ,`ListPrice` = '328000.00' ,`Status` = 'Active' ,`StreetName` = 'Fall Fern' ,`StreetNumber` = '10939' ,`StreetSuffix` = 'Circle' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3220' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Space, space, space! Plus, Mrs. Neat-Clean lives here! This wonderful home has it all. Front porch for morning java. Walk into the foyer & find the large dining room to the right. Kitchen overlooks the oversized family room and has a view to the beautiful, extended, custom, covered patio with ceiling fans, gas grill, and storage shed. Kitchen has a large pantry, plenty of counter space and cabinets. Oversized private master suite includes large walk-in closet, his & her sinks, garden tub, glass shower and separate enclosed toilet area. Upstairs, 3 large bedrooms with good sized closets. Bathroom upstairs is very spacious and has a door between shower and sink area. Walk-in utility room is great for all your dirty clothes bins and ironing/folding table. Very spacious theatre room that opens up to the extra-large game room. The office has a double door and a closet, which can easily be converted to clothes closet & used as a 5th bedroom. Fully paid Solar Panels w/10 year roof warranty' ,`Acres` = '0.1085' ,`Area` = '2' ,`BuilderName` = 'Long Lake Ltd' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 12 BLK 2 SHELDON RIDGE SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4725' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '345' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '46 - Sheldon' ,`SchoolElementary` = 'SHELDON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CE KING HIGH SCHOOL' ,`SchoolMiddle` = 'MICHAEL R. NULL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sheldon Rdg Sec 4' ,`TaxAmount` = '9165' ,`TaxRate` = '3.6393' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666203148' WHERE `Matrix_Unique_ID` = '212374118' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-18T23:42:43.250' ,`MLSNumber` = '31852689' ,`ListAgentFullName` = 'David Barnett' ,`ListOfficeName` = 'Keller Williams Realty -SW' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.561204' ,`Longitude` = '-95.584477' ,`PhotoCount` = '48' ,`PostalCode` = '77479' ,`RoomCount` = '12' ,`ListPrice` = '775000.00' ,`Status` = 'Active' ,`StreetName` = 'Sterling Manor' ,`StreetNumber` = '5207' ,`StreetSuffix` = 'Lane' ,`City` = 'Sugar Land' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '4323' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Luxurious Home located in the Heart Of Master Planned Subdivision of Riverstone! Beautiful Stucco, Brick and Stone exterior speaks nothing but Gorgeousness. Front Doors Leads To drastic entry with Soaring Ceilings And Curved Staircase. Elegant Dining; Office can also be a Formal Living. Spacious Primary Bedroom is large enough to set up an additional office space or nursery. Primary Bath with double vanities and check out the Walk-in Closet for all you Designer Lovers! Secondary bedroom down is perfect as the In-Law Suites or guest suites. Family Room With Tons Of Windows For Natural Light. Kitchen with Custom Cabinetry, Quartz Counter Tops And High End Appliances. Upstiars feature two additional Bedrooms, Gameroom and Media Room. All rooms are of great sizes! Backyard oasis with covered area is Perfect for entertaining. No back neighbor with plenty of privacy! Terrific Fort Bend Isd Schools, And Close To Shopping, Dining And Major Freeways. Schedule Your Appointment Today!' ,`Acres` = '0.2128' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'RIVERSTONE NORTH SEC 2, BLOCK 1, LOT 15' ,`LotDesciption` = 'Greenbelt,Subdivision Lot,Wooded' ,`LotSize` = '9268' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'SETTLERS WAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ELKINS HIGH SCHOOL' ,`SchoolMiddle` = 'FIRST COLONY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Mediterranean' ,`Subdivision` = 'Riverstone North Sec 2' ,`TaxAmount` = '13264' ,`TaxRate` = '2.4529' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666203148' WHERE `Matrix_Unique_ID` = '212418175' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-18T22:37:00.780' ,`MLSNumber` = '55471584' ,`ListAgentFullName` = 'Cheryl Oldweiler' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.056247' ,`Longitude` = '-95.463890' ,`PhotoCount` = '46' ,`PostalCode` = '77388' ,`RoomCount` = '13' ,`ListPrice` = '369500.00' ,`Status` = 'Active' ,`StreetName` = 'Castlegreen' ,`StreetNumber` = '20011' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2684' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this stunning, meticulously upgraded home in excellent location. Step in & you can feel that the sellers put their ‘heart and soul’ into every detail of this inviting home. Make sure you check out the upgrades list—there are too many to list. Chef’s kitchen features stainless steel appliances, beautiful granite counters, stacked stone backsplash & breakfast bar. Terrific open floor plan & downstairs Owner’s Retreat (which boasts garden tub, freestanding shower, 2 sinks & impressive walk-in closet). Enjoy premium travertine floors throughout 1st level & engineered wood floor on most of 2nd level. Fresh beautiful paint on 1st level (including garage) (9/22), generous amount of storage. In past 4 years major systems replacements include: roof, A/C & water heater. Lush landscaping & amazing up-lighting greet you when you return home in the evening. Don’t miss the opportunity to call this place home. Easy access to I-45, Grand Pkwy, & Hardy Toll. Convenient to dining & shopping' ,`Acres` = '0.1465' ,`Area` = '13' ,`BuilderName` = 'Pulte' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 3 BLK 5 LOUETTA LAKES SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6382' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '488' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'LEMM ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN COLLINS HIGH SCHOOL' ,`SchoolMiddle` = 'STRACK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Louetta Lakes Sec 03' ,`TaxAmount` = '6611' ,`TaxRate` = '2.769' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666203148' WHERE `Matrix_Unique_ID` = '212489473' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-18T22:03:30.337' ,`MLSNumber` = '24452211' ,`ListAgentFullName` = 'Victor Ovando' ,`ListOfficeName` = 'Sprout Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.810037' ,`Longitude` = '-95.491882' ,`PhotoCount` = '11' ,`PostalCode` = '77055' ,`RoomCount` = '7' ,`ListPrice` = '330000.00' ,`Status` = 'Active' ,`StreetName` = 'Ridgeview' ,`StreetNumber` = '8046' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1462' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming 3BR/2BA, single family home in the Ridgecrest neighborhood of Spring Branch. Tons of potential! Bring in your creativity or build new on this spacious lot. Never flooded and no HOA. Minutes to Memorial City, amenities and near the 610, 290 and I-10.' ,`Acres` = '0.1961' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 16 BLK 1 RIDGECREST SEC 5' ,`LotDesciption` = 'Cleared' ,`LotSize` = '8540' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'RIDGECREST ELEMENTARY SCHOOL (SPRING BRANCH)' ,`SchoolHigh` = 'NORTHBROOK HIGH SCHOOL' ,`SchoolMiddle` = 'LANDRUM MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Ridgecrest Sec 05' ,`TaxAmount` = '6139' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1953' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666203148' WHERE `Matrix_Unique_ID` = '212506877' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-18T22:33:52.147' ,`MLSNumber` = '32476065' ,`ListAgentFullName` = 'Rhonda Flanagan' ,`ListOfficeName` = 'Connect Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.081872' ,`Longitude` = '-94.175655' ,`PhotoCount` = '16' ,`PostalCode` = '77706' ,`RoomCount` = '4' ,`ListPrice` = '285000.00' ,`Status` = 'Active' ,`StreetName` = 'Chatwood' ,`StreetNumber` = '845' ,`StreetSuffix` = 'Drive' ,`City` = 'Beaumont' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2052' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'OPEN HOUSE ~ OCTOBER 23 ~ 1-4 PM \r\nTHIS IS THE HOME FOR YOU! Beautiful home well maintained inside and out. Four spacious-sized bedrooms, primary bath has large sunken tile shower, hall bath has granite tops with double sinks, shower/tub combo. Home has a formal dining room, kitchen features granite countertops, cooktop and a built-in oven, open to the breakfast room which is open to the living area that features a bricked fireplace. Low maintenance backyard oasis with pool, gazebo, and plenty of seating, pick your seat to gaze at the stars at night. Plenty of space to have family and friends over to enjoy an outdoor cookout. A MUST-SEE! Schedule an appointment, come fall in love and make an offer.' ,`Acres` = '0.2382' ,`Area` = '51' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'DOWLEN WEST UNIT 4 L3 B8' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10375' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`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,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Dowlen West' ,`TaxAmount` = '5559' ,`TaxRate` = '2.645' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1971' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666203148' WHERE `Matrix_Unique_ID` = '212633881' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-18T22:32:08.270' ,`MLSNumber` = '66857032' ,`ListAgentFullName` = 'H J Hutch Lango' ,`ListOfficeName` = 'Keller Williams Premier RealtyKaty' ,`SellingAgentFullName` = 'Judy Hans' ,`SellingOfficeName` = 'Greater Houston REP, Inc.' ,`Latitude` = '29.814169' ,`Longitude` = '-95.790277' ,`PhotoCount` = '23' ,`PostalCode` = '77493' ,`RoomCount` = '12' ,`ListPrice` = '389000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Cane Fields' ,`StreetNumber` = '24022' ,`StreetSuffix` = 'Road' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2638' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Situated on a quiet cul-de-sac road, this beautiful home is ready for your immediate move-in. Open floor plan, a chef’s kitchen with a large quartz-topped island with plenty of food preparation space and still more room for casual dining at the breakfast bar. The large primary bedroom can hold a king size bed with extra room for a casual sitting area to get away from it all. One secondary bedroom includes its own private full bath. Another bedroom has a modified closet to add cabinets and countertops with extra electrical outlets for small appliances perfect for making it into a casual semi-kitchen for aging parents or guests. The home has been well loved and cared for. For the “budding” green thumb in the family one side yard includes a run of raised planter beds along the fence-perfect for growing your own vegetables and herbs. In easy walking distance of local park with hike/bike trails. Come check out this fabulous one of a kind find in the neighborhood and make it yours today!' ,`Acres` = '0.1723' ,`Area` = '25' ,`BuilderName` = 'KB Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 1 KATY OAKS SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7505' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '625' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'WINBORN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Right Side,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Katy Oaks' ,`TaxAmount` = '6843' ,`TaxRate` = '2.6083' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666203149' WHERE `Matrix_Unique_ID` = '212729409' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-18T23:49:17.097' ,`MLSNumber` = '84973383' ,`ListAgentFullName` = 'John Obregon' ,`ListOfficeName` = 'Offerpad Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.281508' ,`Longitude` = '-95.487981' ,`PhotoCount` = '34' ,`PostalCode` = '77304' ,`RoomCount` = '9' ,`ListPrice` = '319900.00' ,`Status` = 'Active' ,`StreetName` = 'Oak Rise' ,`StreetNumber` = '2203' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2480' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 2203 Oak Rise Dr. in Conroe TX. This 2 story 4 bedroom, 3.5 baths 2-car garage home located on a is a family’s dream come true! This open floor plan home is perfect for those who love to entertain. The spacious island kitchen open\'s to the Family room and dining room. The second level provides the homeowner with a flex room that could be used as a game room, media room, and more. Enjoy the evening out back under the covered patio. The community is the perfect combination of small-town charm and easy access to big-city conveniences. Enjoy the great outdoors at Lake Conroe. Houston and The Woodlands are only a short commute away. Great restaurants, and local and big box retail offerings are all close by. Welcome home!' ,`Acres` = '0.1578' ,`Area` = '19' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S966100 - WOODHAVEN FOREST 01, BLOCK 4, LOT 13' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '6873' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '363' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'GORDON-REED ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodhaven Forest 01' ,`TaxAmount` = '5242' ,`TaxRate` = '2.1863' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666203149' WHERE `Matrix_Unique_ID` = '212768741' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-18T23:02:16.117' ,`MLSNumber` = '44055616' ,`ListAgentFullName` = 'Mydasha Verrett' ,`ListOfficeName` = 'Jane Byrd Properties INTL.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.235605' ,`Longitude` = '-95.146942' ,`PhotoCount` = '31' ,`PostalCode` = '77372' ,`RoomCount` = '7' ,`ListPrice` = '257500.00' ,`Status` = 'Active' ,`StreetName` = 'Lazy S' ,`StreetNumber` = '26855' ,`StreetSuffix` = 'Street' ,`City` = 'Splendora' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2240' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WANTING TO GET AWAY FROM THE HUSTLE AND BUSTLE OF THE CITY? Sometimes you just want to enjoy a nice glass of iced tea on your front porch. Well this home has a beautiful front porch that can give you that and more. It\'s uniquely designed! It has an open concept and a nice living area which is perfect for entertaining friends/family. This home offers a spacious primary bedroom with spa tub, and walk in closets. It\'s ready for your finishing touches to it. There\'s an en-suite that has its own bathroom and walk in closet. There\'s custom trimming throughout the house. Sits on an oversized lot that extends beyond the fence in which is ideal for outside activities. There\'s a second potential rental house just in the back of the property that has been set up for a 2-bed, 1-bath. It has it\'s own electricity, on-demand hot water heater, sceptic, and private road access. AND GET THIS.. There is an \"Entertainment Shed\" that\'s a must see! Minutes away from the new HWY 99 and shopping areas!' ,`Acres` = '0.6061' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Window Unit' ,`HOAMandatory` = '0' ,`Legal` = 'S585004-Holiday Oaks 04, BLOCK 11, Lot 9,10, ACRES 0.6' ,`LotDesciption` = 'Cleared,Subdivision Lot,Wooded' ,`LotSize` = '26400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '47 - Splendora' ,`SchoolElementary` = 'PEACH CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPLENDORA HIGH SCHOOL' ,`SchoolMiddle` = 'SPLENDORA JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional,Victorian' ,`Subdivision` = 'Holiday Oaks 04' ,`TaxAmount` = '713' ,`TaxRate` = '2.0783' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666203149' WHERE `Matrix_Unique_ID` = '212836734' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-18T23:53:47.287' ,`MLSNumber` = '4510809' ,`ListAgentFullName` = 'Sandy Reagan' ,`ListOfficeName` = 'Reagan Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.147811' ,`Longitude` = '-95.679858' ,`PhotoCount` = '28' ,`PostalCode` = '77362' ,`RoomCount` = '9' ,`ListPrice` = '559500.00' ,`Status` = 'Active' ,`StreetName` = 'Warrender Creek' ,`StreetNumber` = '609' ,`StreetSuffix` = 'Way' ,`City` = 'Pinehurst' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3063' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful home with 4 bedrooms/3.5 baths/3 car garage on almost a quarter acre lot in Woodtrace Subdivision in Tomball ISD! Located on a quiet street with no thru traffic! Many upgrades include open floorplan, decorative high ceilings, formal dining room, private study with french doors, custom blinds throughout, spectacular floor-to-ceiling corner gas fireplace, Private Primary suite with soaker tub, separate shower is 42\"X 66\". Spacious primary walk-thru 12\' x 13\' closet has convenient access to the utility room. Large open kitchen with breakfast nook, breakfast bar, 42\" custom cabinets, stainless appliances, gas cooktop, large pantry, granite counters, double oven, herringbone backsplash and open to family room. Bedroom #4 Upstairs game room/private suite/2nd primary is 15\' x 13\' with private bath and walk in closet.' ,`Acres` = '0.2089' ,`Area` = '15' ,`BuilderName` = 'Village Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tomball' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'S959412 - WOODTRACE 12, BLOCK 1, LOT 10' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '9098' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'DECKER PRAIRIE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'TOMBALL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Mediterranean' ,`Subdivision` = 'Woodtrace 12' ,`TaxAmount` = '1946' ,`TaxRate` = '3.2015' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666203149' WHERE `Matrix_Unique_ID` = '212837794' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-18T22:52:39.547' ,`MLSNumber` = '40633043' ,`ListAgentFullName` = 'Mary Kay Chaykoski' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.105335' ,`Longitude` = '-95.535440' ,`PhotoCount` = '30' ,`PostalCode` = '77389' ,`RoomCount` = '8' ,`ListPrice` = '435000.00' ,`Status` = 'Active' ,`StreetName` = 'Melody Mist' ,`StreetNumber` = '7414' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3516' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**Must See** Gorgeous stone and stucco home situated in the gated community of Preserves at North Hampton! A former Ryland model home with loads of upgrades. Tons of windows and soaring ceilings upon entry that will take your breath away. The kitchen is perfect for family gatherings and entertaining. Plenty of counter space with large island and separate breakfast bar. Open to the family room with cathedral ceilings. Large open dining area. Huge primary bedroom with bay window overlooking the back yard. Upstairs game room overlooking the family room. 3 secondary bedrooms upstairs with Hollywood bathroom. 3 car tandem garage. You do not want to miss this one!' ,`Acres` = '0.1515' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 16 BLK 3 PRESERVE AT NORTHAMPTON SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'NORTHAMPTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN OAK HIGH SCHOOL' ,`SchoolMiddle` = 'HILDEBRANDT INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Preserve/Northampton' ,`TaxAmount` = '9115' ,`TaxRate` = '2.834' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666203149' WHERE `Matrix_Unique_ID` = '212878033' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-18T23:11:19.040' ,`MLSNumber` = '72750103' ,`ListAgentFullName` = 'Maria Espitia' ,`ListOfficeName` = 'Ross & Marshall Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.994044' ,`Longitude` = '-95.730700' ,`PhotoCount` = '25' ,`PostalCode` = '77433' ,`RoomCount` = '9' ,`ListPrice` = '346000.00' ,`Status` = 'Active' ,`StreetName` = 'Vinegrove Falls' ,`StreetNumber` = '14930' ,`StreetSuffix` = 'Court' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '2636' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful 5-bedroom home in Cypress has everything you need under one roof! Built in 2014 this home sits on a rare, oversized, cul-de-sac lot of 8,643 sq ft. The huge covered back patio with ceiling fans is the perfect spot to enjoy family gatherings. This lot can easily fit a pool and still have plenty of green space to enjoy! As you walk into a large living area, you\'ll notice the kitchen with an adjoining nook and dining room. There\'s one bedroom down that can also be used as an office with a half bath. Upstairs you will find the generous sized primary bedroom with an ensuite bathroom and large walk-in closet. 3 additional bedrooms, another full bathroom, game room and large utility room are also located upstairs. \r\nLOCATION, LOCATION, LOCATION!!! Villages of Cypress Lakes offers great amenities such as a community pool, parks, trail, kids splash pad and playground. Houston Premium Outlets, Costco, medical facilities, grocery stores and much more are only minutes away!' ,`Acres` = '0.1984' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 25 BLK 3 VILLAGES OF CYPRESS LAKES SEC 28' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '8643' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '614' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'AULT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRIDGELAND HIGH SCHOOL' ,`SchoolMiddle` = 'SALYARDS MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Villages/Cypress Lakes Sec 28' ,`TaxAmount` = '7893' ,`TaxRate` = '3.061' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666203150' WHERE `Matrix_Unique_ID` = '212979159' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-18T22:28:31.900' ,`MLSNumber` = '15248989' ,`ListAgentFullName` = 'Alicia Preston' ,`ListOfficeName` = 'Fathom Realty' ,`SellingAgentFullName` = 'Michael Angeletti' ,`SellingOfficeName` = 'Bruno Fine Properties, Inc' ,`Latitude` = '30.130870' ,`Longitude` = '-95.377512' ,`PhotoCount` = '29' ,`PostalCode` = '77386' ,`RoomCount` = '3' ,`ListPrice` = '249000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Pedernales River' ,`StreetNumber` = '4012' ,`StreetSuffix` = 'Lane' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1312' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully remodeled home in Creekside Village sitting on an oversized corner lot on a cul-de-sac! Home features vaulted ceiling in the large family room that is open to kitchen and breakfast room. This immaculate home has over $16,000 in updates! Freshly painted, granite countertops, beautiful wood flooring, new Stainless steel appliances including stove, microwave and dishwasher. Create memories while gathered around the backyard fire pit with your family and friends. Low taxes, CISD, easy access to 99 the Grand Parkway. This is a home you’ll be proud to call your own!' ,`Acres` = '0.166' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S352705 - CREEKSIDE VILLAGE 05, BLOCK 1, LOT 56' ,`LotDesciption` = 'Corner,Cul-De-Sac,Subdivision Lot' ,`LotSize` = '7230' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'BRADLEY ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'GRAND OAKS HIGH SCHOOL' ,`SchoolMiddle` = 'YORK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Creekside Village' ,`TaxAmount` = '3233' ,`TaxRate` = '1.8487' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2009' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1666203150' WHERE `Matrix_Unique_ID` = '213004145' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-18T22:29:31.630' ,`MLSNumber` = '35267984' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Turner Mangum,LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.435770' ,`Longitude` = '-95.441130' ,`PhotoCount` = '23' ,`PostalCode` = '77583' ,`RoomCount` = '4' ,`ListPrice` = '311990.00' ,`Status` = 'Active' ,`StreetName` = 'Cascade' ,`StreetNumber` = '10647' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosharon' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1680' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Easton floorplan.' ,`Acres` = '0.179' ,`Area` = '5' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '16/4/6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sierra Vista' ,`TaxAmount` = '' ,`TaxRate` = '3.66' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666203150' WHERE `Matrix_Unique_ID` = '213055790' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-18T22:40:00.397' ,`MLSNumber` = '92200130' ,`ListAgentFullName` = 'Gloria Chiu' ,`ListOfficeName` = 'The Real Estate Experts' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.546611' ,`Longitude` = '-95.489882' ,`PhotoCount` = '35' ,`PostalCode` = '77545' ,`RoomCount` = '11' ,`ListPrice` = '320000.00' ,`Status` = 'Active' ,`StreetName` = 'Egret Chase' ,`StreetNumber` = '2514' ,`StreetSuffix` = 'Court' ,`City` = 'Fresno' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2672' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful home located on a corner lot on a cul-de-sac. Home features both formals, den, and game room. All bedrooms upstairs. \r\nNew laminate flooring from entry into formal living room, formal dining room and the family room.\r\nFresh paint. New carpets in upstairs.\r\nKitchen is upgraded with beautiful quartz countertops, New gas range, new dishwasher and new microwave oven.\r\nNew driveway.\r\nEasy access to Hwy 6 and Fort Bend Tollway. Convenient to schools, shopping, banking, and more.' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Winfield Lakes Sec 8, BLOCK 4, Lot 22' ,`LotDesciption` = 'Corner,Cul-De-Sac,Subdivision Lot' ,`LotSize` = '6874' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '575' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'PARKS ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'HIGHTOWER HIGH SCHOOL' ,`SchoolMiddle` = 'LAKE OLYMPIA MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'WINFIELD LAKES SEC 8' ,`TaxAmount` = '6344' ,`TaxRate` = '3.0229' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666203150' WHERE `Matrix_Unique_ID` = '213078854' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-18T22:29:51.053' ,`MLSNumber` = '77219830' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Turner Mangum,LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.435770' ,`Longitude` = '-95.441130' ,`PhotoCount` = '16' ,`PostalCode` = '77583' ,`RoomCount` = '4' ,`ListPrice` = '322990.00' ,`Status` = 'Active' ,`StreetName` = 'Watershed' ,`StreetNumber` = '10610' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1810' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Texas Cali plan is a one-story home featuring 4 bedrooms, 2 baths, and 2 car garage. The long foyer with an entry coat closet leads to the open concept kitchen and breakfast area. The kitchen includes a breakfast bar with beautiful counter tops, stainless steel appliances, corner pantry and opens to the family room. The primary suite features a sloped ceiling and attractive primary bath with dual vanities, water closet and spacious walk-in closet. The standard rear covered patio is located off the breakfast area.' ,`Acres` = '0.179' ,`Area` = '5' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '3/5/4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sierra Vista' ,`TaxAmount` = '' ,`TaxRate` = '3.66' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666203150' WHERE `Matrix_Unique_ID` = '213120287' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-18T22:30:10.567' ,`MLSNumber` = '30297772' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Turner Mangum,LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.435770' ,`Longitude` = '-95.441130' ,`PhotoCount` = '31' ,`PostalCode` = '77583' ,`RoomCount` = '4' ,`ListPrice` = '336990.00' ,`Status` = 'Active' ,`StreetName` = 'Truckee River' ,`StreetNumber` = '1207' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2031' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Kingston plan is a one-story home featuring 4 bedrooms, 2 baths, and 2 car garage. The entry opens to the guest bedrooms, bath with linen closet. Center kitchen includes oversized breakfast bar with beautiful counter tops and stainless steel appliances. Open concept floorplan boasts large combined family room and dining area. The primary suite features a sloped ceiling and attractive primary bath with dual vanities, water closet and walk-in closet. The standard rear covered patio is located off the family room' ,`Acres` = '0.179' ,`Area` = '5' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '33/3/4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sierra Vista' ,`TaxAmount` = '' ,`TaxRate` = '3.66' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666203151' WHERE `Matrix_Unique_ID` = '213120494' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-18T22:29:15.390' ,`MLSNumber` = '83720396' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Turner Mangum,LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.435770' ,`Longitude` = '-95.441130' ,`PhotoCount` = '24' ,`PostalCode` = '77583' ,`RoomCount` = '3' ,`ListPrice` = '382990.00' ,`Status` = 'Active' ,`StreetName` = 'Cascade Creek' ,`StreetNumber` = '10655' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1831' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Harris Floorplan.' ,`Acres` = '0.179' ,`Area` = '5' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '43-4-4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sierra Vista' ,`TaxAmount` = '' ,`TaxRate` = '3.66' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666203151' WHERE `Matrix_Unique_ID` = '213121406' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-18T23:21:10.460' ,`MLSNumber` = '27832219' ,`ListAgentFullName` = 'Gloria Casanova' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.121247' ,`Longitude` = '-95.390025' ,`PhotoCount` = '45' ,`PostalCode` = '77386' ,`RoomCount` = '5' ,`ListPrice` = '382500.00' ,`Status` = 'Active' ,`StreetName` = 'Legends Hill' ,`StreetNumber` = '29611' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3804' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home to this stunning 2 story located in Legends Run Subdivision that\'s ready for immediate move-in. This stunning 5-bedroom home offers and amazing floorplan with a large kitchen and lots of cabinet space with granite countertops and opens up to the family room for whole family entertainment. The formal living and dining room area has tons of natural light for those family dinner parties. The spacious family bedroom is the perfect retreat for relaxing after a day of work. The 4 bedrooms and 2 full baths upstairs along with the game room offers lots of space for everyone in the family. Home has a fantastic outdoor living space with covered patio. Home has never been flooded. Easy access from and to HWY 99 and minutes from local dining and shopping. Hurry this home will not last long... it\'s the perfect home that will provide many years of fun and memories.' ,`Acres` = '0.2024' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S688202 - LEGENDS RUN 02, BLOCK 3, LOT 13' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '8815' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '490' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'BRADLEY ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'GRAND OAKS HIGH SCHOOL' ,`SchoolMiddle` = 'YORK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Legends Run 02' ,`TaxAmount` = '7989' ,`TaxRate` = '2.8187' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666203151' WHERE `Matrix_Unique_ID` = '213197090' --> 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','213205081','1666203151','213205081','2022-10-18T23:30:26.187','39141927','Lisa Cloud','Blue Willow Properties','','','29.826583','-95.488194','23','77092','4','159000.00','Active','Thornwall','6527','Street','Houston','2','0','4','1380','Single-Family','4 Bedroom 2 bathroom situated on an oversized lot in Langwood.','0.2543','24','','','','','Sellers Disclosure','','','','Spring Branch','Central Gas','0','LT 4 BLK 13 LANGWOOD SEC 3','Subdivision Lot','11077','Appraisal District','','','0','','1','','0','','','','','Composition','27 - Houston','BENBROOK ELEMENTARY SCHOOL (HOUSTON)','SCARBOROUGH HIGH SCHOOL','CLIFTON MIDDLE SCHOOL (HOUSTON)','Appointment Required,Supra Keybox','Appraisal District','1','Traditional','Langwood Sec 03','3909','2.3307','Public Sewer,Public Water','1940','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-18T22:21:02.797' ,`MLSNumber` = '56148340' ,`ListAgentFullName` = 'Eriko Ishii' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.665815' ,`Longitude` = '-95.833254' ,`PhotoCount` = '34' ,`PostalCode` = '77406' ,`RoomCount` = '10' ,`ListPrice` = '465000.00' ,`Status` = 'Active' ,`StreetName` = 'Cloverbank' ,`StreetNumber` = '26423' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3120' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Immaculate condition open Floor plan -1.5 Story, 4 Beds, 3 Baths, 2 Car Garage in Cul-de-Sac! The gorgeous home w/60K upgrades offers; Spacious chef\'skitchen including large granite countertops and island, an abundance of cabinet spaces, Gas cook top, SS appliances, and a reverse osmosis water filtration system. The kitchen overlooks spacious living room covered patio. Large master suite w/ garden tub, separate shower, and walk-in closet. Huge bonus room upstairs is for entertaining. Upgraded beautiful tile flooring is throughout the house (except all bedrooms and stairs, game room) Energy Star 3.0, 16 SEER A/C. Built with the CalAtlantic Homes HouseWorks Energy Efficiency Package! Jr. Olympic-size pool, splash pool, and Pavilion area in the community. Walking distance to the elementary school. Lower property tax rate!! Easy access to 99 and Westpark Tollway.' ,`Acres` = '0.1765' ,`Area` = '37' ,`BuilderName` = 'CalAtlantic/Lennar' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'CREEKSIDE RANCH SEC 5, BLOCK 5, LOT 11' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '7688' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '820' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'BENTLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FOSTER HIGH SCHOOL' ,`SchoolMiddle` = 'WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Creekside Ranch Sec 5' ,`TaxAmount` = '6278' ,`TaxRate` = '2.704' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666203151' WHERE `Matrix_Unique_ID` = '213327141' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-18T22:58:14.383' ,`MLSNumber` = '31818439' ,`ListAgentFullName` = 'Jeffrey Welch' ,`ListOfficeName` = 'Welch Realty Inc' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.998090' ,`Longitude` = '-95.608132' ,`PhotoCount` = '47' ,`PostalCode` = '77429' ,`RoomCount` = '10' ,`ListPrice` = '355000.00' ,`Status` = 'Active' ,`StreetName` = 'Highland Hills' ,`StreetNumber` = '12815' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2922' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This amazing house in Lakewood Forest has 4 spacious bedrooms, 2 1/2 baths & a detached two-car garage sitting on a 10,000+ sq ft lot. In this home, you will find a foyer, den, dining room, huge family room with built-ins and a gas log fireplace, an updated kitchen with breakfast area overlooking the lovely backyard, a huge upstairs game room, a large master bedroom plus 3 additional spacious bedrooms all w/large walk-in closets, the secondary bathroom comes with double sinks & tub/shower combo. The very generous main bedroom includes walk-in closets and an updated bath with double vanities. The HVAC mini-splits are high efficiency (22 SEER) & have great filtration. There have only been two owners and each verified no pets have ever lived here plus the hard floors throughout the majority of the home can really help to minimize allergens & simplify cleaning. A wonderful large home in a beautiful neighborhood & award-winning Cypress-Fair School District. Make your appointment today!' ,`Acres` = '0.2388' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 9 BLK 23 LAKEWOOD FOREST SEC 10' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '655' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'HAMILTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakewood Forest' ,`TaxAmount` = '5958' ,`TaxRate` = '2.5217' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666203151' WHERE `Matrix_Unique_ID` = '213329617' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-18T23:26:40.630' ,`MLSNumber` = '73994677' ,`ListAgentFullName` = 'Emily Peng' ,`ListOfficeName` = 'Living Quarters LLC' ,`SellingAgentFullName` = 'Polly Guillory' ,`SellingOfficeName` = 'Jane Byrd Properties INTL.' ,`Latitude` = '30.036752' ,`Longitude` = '-95.345216' ,`PhotoCount` = '20' ,`PostalCode` = '77373' ,`RoomCount` = '5' ,`ListPrice` = '159900.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Diane' ,`StreetNumber` = '5421' ,`StreetSuffix` = 'Court' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1326' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Nice 3 bedrooms, 2 bath one story DUPLEX HOME (1/2 duplex) with fenced yard, at the end of a cul-de-sac street. No neighbor directly in the back. Vaulted ceiling in the living room, kitchen & dining areas. Wood burning fireplace. Isolated master suite with his and her closets. Double vanity sinks in both bathrooms. Recent updates include new paint, all new ceiling fans, window blinds, and new carpet in all bedrooms. New stove & vent hood. Convenient Spring locations with easy access to major highways & Bush airport. Close to schools and shopping.' ,`Acres` = '' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'TRS 34A & 35C BLK 5 POSTWOOD SEC 5' ,`LotDesciption` = 'Cleared,Cul-De-Sac' ,`LotSize` = '3611' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '285' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'ANDERSON ELEMENTARY SCHOOL (SPRING)' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'DUEITT MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Postwood Sec 05' ,`TaxAmount` = '2587' ,`TaxRate` = '2.5868' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1984' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666203152' WHERE `Matrix_Unique_ID` = '213331407' --> 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','213374765','1666203152','213374765','2022-10-18T22:23:17.500','40515750','Brittany Inns','Keller Williams Realty - Clear Lake/ NASA','','','29.567991','-95.117054','41','77062','6','385500.00','Active','Ramada','1915','Drive','Houston','2','0','3','1700','Single-Family','Welcome Home to paradise on the greenbelt! Not only do you get backyard access to the amazing greenbelt, enjoy a brand new floorplan, brand new finishes, and a home reconfigured and taken down to the studs for you! The kitchen is now open to the living room, the primary bedroom full of upgrades, brand new primary bathroom, and a massive closet sure to please. Come home to all new flooring throughout, new AC and ductwork, new electrical, high-end appliances, granite countertops throughout, foundation completed in 2020, new concrete back patio, new sliding glass doors, and fresh, neutral paint throughout. Don\'t miss your chance to own this truly well-thought-out, one-of-a-kind home! There is nothing like it on the market today! Never flooded!','0.2369','7','','','','','Sellers Disclosure','1','','','Clear Lake Area','Central Electric','1','LT 423 BLK 34 CLEAR LAKE CITY SEC 3','Subdivision Lot','10320','Appraisal District','','68','0','','2','','0','','','','','Composition','9 - Clear Creek','CLEAR LAKE CITY ELEMENTARY SCHOOL','CLEAR LAKE HIGH SCHOOL','SPACE CENTER INTERMEDIATE SCHOOL','Appointment Required,Supra Keybox','Appraisal District','1','Contemporary/Modern','Clear Lake City Sec 03','5533','2.5769','Public Sewer,Public Water','1962','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-18T22:14:08.637' ,`MLSNumber` = '75117581' ,`ListAgentFullName` = 'Kevin Johnson' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.009153' ,`Longitude` = '-95.632754' ,`PhotoCount` = '48' ,`PostalCode` = '77429' ,`RoomCount` = '8' ,`ListPrice` = '540000.00' ,`Status` = 'Active' ,`StreetName` = 'Pedernales' ,`StreetNumber` = '13730' ,`StreetSuffix` = 'Court' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3160' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Absolutely stunning home with an excellent layout! This 4 bedroom, 3.5 bath, 2 Office home features extensive upgrades throughout that include the front door, tile, gorgeous kitchen, lighting package, office doors, hardware, fireplace, carpet, and more. As you walk in you have the 1st \"office\" on the left that is being used as a play room downstairs. Down the hall is the second office that is also very large. Then you enter the exceptional living room with high vaulted ceilings that gives natural light to the space. The fireplace is beautiful, warm, and inviting. The kitchen is open to the living room and just gorgeous. The quarts countertops go with the beautiful backsplash and upgraded cabinets. The primary bedroom suite is down stairs and very good sized. Upstairs you have a game room, 3 large bedrooms with nice closets, and two full baths. Out back you have a covered patio, yard big enough for a pool, and no rear neighbors. Plus a Tandem 3 car garage....Just Gorgeous.' ,`Acres` = '0.1578' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tomball South/Lakewood' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 15 BLK 6 COPPER RIDGE AT INDIAN TRAILS SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6875' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1045' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'WILDWOOD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL MEMORIAL H S' ,`SchoolMiddle` = 'GRAND LAKES JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Copper Rdg/Indian Trls' ,`TaxAmount` = '10516' ,`TaxRate` = '2.7564' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666203152' WHERE `Matrix_Unique_ID` = '213390659' --> 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','213418874','1666203152','213418874','2022-10-18T23:50:59.073','67723459','Gabriela Duran','Walzel Properties','','','29.290615','-94.812139','32','77550','8','599000.00','Active','Avenue M 1/2','4123','','Galveston','2','1','3','1998','Single-Family','WELCOME to 4123 Avenue M1/2, this beautiful home is a great opportunity either as a primary home or as an investment property! Its centrally located offering easy access to downtown strip, pleasure pier, and restaurants while keeping you in a tranquil location. This gorgeous open floor home offers a fantastic kitchen, with and oversized island that provides tons of storage; large open concept living/dining area, with a half bath on the main floor. Second floor offers a magnificent primary bedroom, with balcony, walk-in closed and unsuited double sick bathroom. As well as 2 extra bedrooms, with walking closets, a secondary bath. Laundry room offers lots of storage. This house also offers white quartz, 10-foot ceilings, ceiling fans, and recess lighting throughout. BONUS: extra storage in the Living/dining area, Refrigerator, wine cooler and a spacious 2 car garage!','0.1102','33','Timarron Investments','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','Midtown - Galveston','Central Electric','0','ABST 628 M B MENARD SUR E 26-4 FT OF LOT 2 & W 0-10 FT OF L','Subdivision Lot','4800','Appraisal District','','','1','Never Lived In','2','Electric Oven,Single Oven','0','','','Electric Cooktop','','Composition,Wood Shingle','22 - Galveston','GISD OPEN ENROLL','BALL HIGH SCHOOL','GISD OPEN ENROLL','Appointment Required,Leave Business Card,Request Online Appointment,Supra Keybox','Builder','2','Contemporary/Modern,Traditional','Galveston Outlots','','','Public Sewer,Public Water','2022','Builder'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-18T23:50:50.027' ,`MLSNumber` = '11985484' ,`ListAgentFullName` = 'Bain McEldowney' ,`ListOfficeName` = 'RE/MAX Metro' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.109348' ,`Longitude` = '-95.089684' ,`PhotoCount` = '47' ,`PostalCode` = '77554' ,`RoomCount` = '6' ,`ListPrice` = '730000.00' ,`Status` = 'Active' ,`StreetName` = 'King Rail' ,`StreetNumber` = '4130' ,`StreetSuffix` = 'Circle' ,`City` = 'Galveston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1760' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fabulous, fully furnished, Pointe West 3bed/3.5bath beachside cottage w/ open kitchen/living/dining. Stunning views of West Bay & beach from the living area & primary suite. 3 decks total. Large patio area under the home that spills into expansive green space & pond. Large primary suite has a private deck overlooking a serene lagoon & sunsets. Primary bath features double vanity plus separate tub & shower. Expansive kitchen w/ breakfast bar, granite counters, slate back splash, recessed lighting & stainless appliances. The patio under the home is a great area for play rain or shine. It also features an outdoor hot shower, garage, & storage area. The exterior of the home is cement siding. Impact windows and composite decking make it sturdy for all weather. All bedrooms include ensuite baths. Beach Club amenities of Pointe West include: hike and bike trail, playground, infinity pool, spa, lazy river, restaurant/bar, gas grills, and a game and fitness center. Short term rentals allowed.' ,`Acres` = '0.1022' ,`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` = 'POINTE WEST SEC 1 (2005), ABST 121, BLOCK 1, LOT 55, ACRES 0' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot,Water View' ,`LotSize` = '4454' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1130' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Pointe West Sec 1 2005' ,`TaxAmount` = '10233' ,`TaxRate` = '2.0324' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666203152' WHERE `Matrix_Unique_ID` = '213423560' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-18T23:58:13.763' ,`MLSNumber` = '30902780' ,`ListAgentFullName` = 'Tai Dinh' ,`ListOfficeName` = 'Precious Realty & Mortgage' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.708509' ,`Longitude` = '-95.574555' ,`PhotoCount` = '26' ,`PostalCode` = '77072' ,`RoomCount` = '7' ,`ListPrice` = '263000.00' ,`Status` = 'Active' ,`StreetName` = 'Bandlon' ,`StreetNumber` = '11111' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1836' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Wow, beautiful one story home with 3 beds, 2 baths in subdivision of Brays Village. Double front door. Upon entry the foyer opens up to a large atrium allowing lot of natural sunlight. Tile throughout the house, no carpet. Spacious family room for gathering and is accented with brick fireplace. Big kitchen offers large island, stainless steel appliances. Kitchen opens to dining room and surround with many windows. Master suite includes spacious living space, sitting area viewing atrium and have door to access to back yard. Large backyard for your entertainment. Not flooded. Close to West park, beltway 8, hwy 6, 59. Fridge, washer, dryer stay. House is ready to move in.' ,`Acres` = '0.1295' ,`Area` = '28' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alief' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 10 BLK 1 BRAYS VILLAGE SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5639' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '285' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '2 - Alief' ,`SchoolElementary` = 'CHANCELLOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AISD DRAW' ,`SchoolMiddle` = 'ALIEF MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Brays Village Sec 04' ,`TaxAmount` = '3719' ,`TaxRate` = '2.4411' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666203152' WHERE `Matrix_Unique_ID` = '213481439' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-18T23:30:06.547' ,`MLSNumber` = '63309385' ,`ListAgentFullName` = 'Patricia Fleming' ,`ListOfficeName` = 'Patricia Fleming Realty LLC' ,`SellingAgentFullName` = 'Ijlal Kilicarslan' ,`SellingOfficeName` = 'Ann/Max Real Estate INC' ,`Latitude` = '29.893108' ,`Longitude` = '-95.645272' ,`PhotoCount` = '40' ,`PostalCode` = '77095' ,`RoomCount` = '12' ,`ListPrice` = '418800.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Villa Palms' ,`StreetNumber` = '7803' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2954' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'UNRIVALED EXCELLANCE! YOU WILL FALL IN LOVE W THIS MASTERPIECE HOME SITUATED ON A LARGE CORNER LOT IN THE SOUGHT AFTER COMMUNITY OF SOUTHDOWN ESTATES! THIS EXQUISITE HOME FEATURES UPDATES INCL YOUR OWN OUTDOOR OASIS W HEATED POOL, SPILLOVER SPA,SUNSHELF & TROPICAL WATERFALL*OWNERS LOVINGLY INVESTED OVER $100K IN CUSTOM UPDATES INCL:PEX RE-PLUMBING($7,000)*NEW ROOF(2020) NEW HVAC(2022) POOL PUMPS(2021)TOTAL PRIMARY BATH REMODEL($40,000) INCL FRAMELESS SHOWER,CUSTOM CABINETRY,MARBLE COUNTERS & SHOWER*LARGE WHIRLPOOL TUB*FLOORING*CUSTOM LIGHTING & FIXTURES*FULL KITCHEN REMODEL W CUSTOM CABINETRY*DESIGNER GRANITE ON ISLAND & ALL COUNTERS*2 WALK IN CLOSETS*WONDERFUL OPEN PLAN W DRAMATIC HIGH CIELINGS AT ENTRY*EXTRA LONG DRIVE & SETBACK DETACHED GARAGE*LOCATED IN THE HIGHLY ACCLAIMED CY-FAIR SCHOOL DISTRICT*EASY ACCESS TO HWY 290, I-10 & HWY 99*EXCELLENT DINING & SHOPPING MINUTES AWAY AS WELL AS SEVERAL WALKING/BIKING TRAILS, POOLS & PARKS*YOU WILL NOT WANT TO MISS OUT ON THIS OPPORTUNITY!' ,`Acres` = '0.2145' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Copperfield Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 46 BLK 26 COPPERFIELD SOUTHDOWN VILLAGE SEC 2' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '9345' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '625' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'LOWERY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LANGHAM CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'ARAGON MIDDLE SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Lockbox Front,No Appointment Required,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Copperfield Southdown Village' ,`TaxAmount` = '6413' ,`TaxRate` = '2.3216' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1984' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666203153' WHERE `Matrix_Unique_ID` = '213537020' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-18T22:32:01.233' ,`MLSNumber` = '45322574' ,`ListAgentFullName` = 'Virginia Schilling' ,`ListOfficeName` = 'Turbo Realty of Texas' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.991784' ,`Longitude` = '-95.165877' ,`PhotoCount` = '33' ,`PostalCode` = '77346' ,`RoomCount` = '7' ,`ListPrice` = '237000.00' ,`Status` = 'Active' ,`StreetName` = 'Oak Bower' ,`StreetNumber` = '18811' ,`StreetSuffix` = 'Drive' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1824' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Very well kept 1 story Brick 4 Bedroom ~ 2 Bath ~ 2 Car Garage with a double wide driveway . Home near a right turn cul-de-sac in 77346 for $237K! Who could ask for more? Updated double windows , \r\nRoof replaced in 2020 5 burner Maytag Gas stove Oven / Refrigerator stays\', Living room features a vaulted ceiling and a beautiful brick gas log fireplace. Tile entry / Storm Door . Engineered wood floors . \r\nWalk to Elementary school and Atascoctia Middle School Close to Atascocita High School . Come check it out!' ,`Acres` = '0.1717' ,`Area` = '1' ,`BuilderName` = 'General Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Atascocita South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 15 BLK 18 ATASCOCITA SOUTH SEC 2' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '7480' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'TIMBERS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ATASCOCITA HIGH SCHOOL' ,`SchoolMiddle` = 'ATASCOCITA MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Atascocita South Sec 02' ,`TaxAmount` = '4068' ,`TaxRate` = '2.3974' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666203153' WHERE `Matrix_Unique_ID` = '213538448' --> 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','213574584','1666203153','213574584','2022-10-18T23:35:19.073','31869760','Rebecca Drake','RE/MAX The Woodlands & Spring','','','30.149650','-95.504620','22','77381','6','245000.00','Active','Wavy Oak','37','Circle','The Woodlands','1','1','3','1038','Single-Family','In this central Woodlands location this charming one story home is situated on a greenbelt home site and is nestled amongst beautiful, mature trees. Owners have updated the exterior with Hardie Plank siding, concrete driveway, garage door, and energy-efficient double-paned windows. The home has been freshly painted inside, and has easy-care laminate flooring in the living area. No carpet here. There\'s plenty of potential here for you to add your own touches to this sweet home, but it\'s neutral, clean and ready to go. Garage has a nice-sized storage closet for added convenience. The back yard is fenced too.','0.1217','15','Glenwood Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Exclusions,Mud,Sellers Disclosure','1','','0','The Woodlands','Central Gas','0','LOT 9, BLOCK 9','Greenbelt,In Golf Course Community,Subdivision Lot','5300','Appraisal District','','','0','','2','Freestanding Oven,Gas Oven','0','','','Freestanding Range,Gas Cooktop','','Composition','11 - Conroe','GLEN LOCH ELEMENTARY SCHOOL','THE WOODLANDS HIGH SCHOOL','MCCULLOUGH JUNIOR HIGH SCHOOL','Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox','Appraisal District','1','Ranch,Traditional','Woodlands Village Panther Creek','3449','2.0869','Public Sewer,Public Water,Water District','1981','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-18T22:16:01.750' ,`MLSNumber` = '19556079' ,`ListAgentFullName` = 'Dena May' ,`ListOfficeName` = 'Coastal Dream Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.526051' ,`Longitude` = '-95.076462' ,`PhotoCount` = '25' ,`PostalCode` = '77573' ,`RoomCount` = '7' ,`ListPrice` = '265000.00' ,`Status` = 'Active' ,`StreetName` = 'Woodwind' ,`StreetNumber` = '2227' ,`StreetSuffix` = 'Way' ,`City` = 'League City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1464' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'STOP THE CAR!! Completely Updated, never flooded, and in CCISD! Real wood floors. New 30 year shingle roof & new trusses. New kitchen cabinets, new stainless appliances including ice making fridge. Granite countertops & open to living area. Kitchen island for eating or formal dining/living room. Primary bedroom w/walk-in closet & completely new bathroom: New tub, new tile, new cabinet, new granite, new sink, new toilet, new hardware, new lighting, & new mirror. Secondary bathroom has New tub, new tile, new cabinets, new granite, new sinks, new toilet, new hardware, new lighting, & new mirrors. Extra storage in the home as well as the garage. This neighborhood has a voluntary HOA that allows access to the community pool & private boat ramp at the back of the neighborhood. Within walking distance to Clear Creek High. Beautiful covered front porch and fully fenced back yard with epoxy painted cement patio. Perfect to relax after a long day at work. Call for your private showing today.' ,`Acres` = '0.1793' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 18 M MULDOON SUR LOT 13 BLK 3 BAYOU BRAE SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7810' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'FERGUSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'CLEAR CREEK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Lockbox Right Side' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Bayou Brae Sec 2' ,`TaxAmount` = '3251' ,`TaxRate` = '2.0697' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1971' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666203153' WHERE `Matrix_Unique_ID` = '213589691' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-18T22:16:28.520' ,`MLSNumber` = '9523305' ,`ListAgentFullName` = 'Amy Hendrix' ,`ListOfficeName` = 'RE/MAX American Dream' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.335454' ,`Longitude` = '-95.293829' ,`PhotoCount` = '38' ,`PostalCode` = '77511' ,`RoomCount` = '4' ,`ListPrice` = '389000.00' ,`Status` = 'Active' ,`StreetName` = 'Finetta' ,`StreetNumber` = '12' ,`StreetSuffix` = 'Lane' ,`City` = 'Alvin' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2521' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 12 Finetta! This private estate is located off the beat\'n path down a dead end road. This home has it all, sunroom, pool with no back neighbors, multiple covered pergolas, newly remodeled kitchen, detached garage, storage shed, primary bedroom has a nook that can be a bedroom/nursery or office, water filtering system...this one has it ALL!\r\nCall today for your private showing.' ,`Acres` = '0.3712' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alvin South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'COUNTRY MANOR INC (A0006 A H & B R R) LOT 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '16169' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'NELSON ELEMENTARY SCHOOL (ALVIN)' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'FAIRVIEW JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Colonial' ,`Subdivision` = 'Country Manor Inc' ,`TaxAmount` = '8426' ,`TaxRate` = '2.7907' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666203153' WHERE `Matrix_Unique_ID` = '213642859' --> 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','213693077','1666203153','213693077','2022-10-18T22:34:06.733','24947320','Ibrahim Zakhary','REALM Real Estate Professional','','','29.858257','-95.733498','19','77449','7','325000.00','Active','Hawkins Manor','20610','Lane','Katy','3','0','4','2266','Single-Family','MUST SEE!! Welcome Home to this stunning 4 bedroom/ 3 full bath home located in Jasmine Heights community, with no back neighbors. Once you enter the home you will be greeted with 11 F high ceiling through the whole house, 3 bedrooms down and one up with a full bathroom and large game room. Brand new luxurious vinyl planks installed in the entrance, dining area and the kitchen, laminate flooring in living area, brand new carpets, the entire home got fresh paint, and much more. near major grocery stores, close to highways, and located in CyFair ISD. COME check it out before it\'s too late! prof pics coming soon!','0.133','25','','','','','Sellers Disclosure','1','','','Bear Creek South','Central Gas','1','LT 19 BLK 1 JASMINE HEIGHTS SEC 4','Greenbelt,Subdivision Lot','5795','Appraisal District','','320','0','','2','','0','','','Freestanding Range,Gas Range','','Composition','13 - Cypress-Fairbanks','HEMMENWAY ELEMENTARY SCHOOL','CYPRESS PARK HIGH SCHOOL','ROWE MIDDLE SCHOOL','Appointment Required,Vacant/Unoccupied','Appraisal District','2','Traditional','Jasmine Heights Sec 4','6243','2.831','Public Water,Water District','2012','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-18T22:23:00.230' ,`MLSNumber` = '45080213' ,`ListAgentFullName` = 'Yun Zhang' ,`ListOfficeName` = 'Texas Southwest Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.829781' ,`Longitude` = '-95.795960' ,`PhotoCount` = '42' ,`PostalCode` = '77493' ,`RoomCount` = '10' ,`ListPrice` = '565000.00' ,`Status` = 'Active' ,`StreetName` = 'Kee Cresta' ,`StreetNumber` = '24307' ,`StreetSuffix` = 'Court' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3271' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A RARE FIND - STUNNING LAKE FRONT HOME! Welcome to resort style living, luxury and charm are waiting! This gorgeous 5-bedroom home has been newly installed with wood imitation tile floors in the common area and newly painted with neutral color throughout the house. As you enter this home it will take your breath away – it boasts a spacious family room with two-story soaring ceilings overlooking the lake and fountain view, home office, formal dining, media room and game room. Kitchen open to the family room, with large granite countertop island and a breakfast bar. You don’t want to miss all that this gorgeous home has to offer! House is located in a quiet cul-de-sac in the heart of Katy. Great community amenities. Highly sought after Katy ISD. Check out the virtual 3D tour and schedule your showing today!' ,`Acres` = '0.1559' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 8 BLK 1 MARCELLO LAKES SEC 1' ,`LotDesciption` = 'Cul-De-Sac,Water View,Waterfront' ,`LotSize` = '6793' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'LEONARD ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Marcello Lakes Sec 1' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1666203153' WHERE `Matrix_Unique_ID` = '213698126' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-18T22:40:55.247' ,`MLSNumber` = '73773859' ,`ListAgentFullName` = 'Darla Watkins' ,`ListOfficeName` = 'C 4 Realty LLC.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.409484' ,`Longitude` = '-95.663386' ,`PhotoCount` = '50' ,`PostalCode` = '77356' ,`RoomCount` = '11' ,`ListPrice` = '674900.00' ,`Status` = 'Active' ,`StreetName` = 'Parkside' ,`StreetNumber` = '11719' ,`StreetSuffix` = 'Boulevard' ,`City` = 'Montgomery' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3113' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous custom 1.5 story located in the private gates of Grand Harbor on prestigious Lake Conroe. This home has approximately 3/4 acre with a backyard fully fenced backing up to several ponds. Perfect for a future pool and outside kitchen, where the patio is plumbed for gas. Very open floor plan with four spacious bedrooms. One bedroom is great for a guest, as it is on one side of the house making it very private. The primary and other bedrooms are a split plan. Gourmet kitchen with butlers pantry, 5 burner gas range, double ovens, huge island open to the family room, custom cabinets galore, wine rack and cabinets in the dining area with wine fridge, subway tile back splash, water softener and so much more. Come enjoy your media room with raised theatre seating. Theatre offers a 100 inch screen with a 4K projector, 11.1 surround sound with speakers in the front, rear, sides and ceiling and custom shelving for DVDS, Games, etc. This home is truly everything you could want, plus more.' ,`Acres` = '0.6664' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S538015 - GRAND HARBOR 15, BLOCK 1, LOT 34, ACRES 0.6664' ,`LotDesciption` = 'Cleared' ,`LotSize` = '29027' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'MADELEY RANCH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MONTGOMERY HIGH SCHOOL' ,`SchoolMiddle` = 'MONTGOMERY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Grand Harbor 15' ,`TaxAmount` = '8388' ,`TaxRate` = '1.8242' ,`WaterSewer` = 'Aerobic,Public Water' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666203154' WHERE `Matrix_Unique_ID` = '213738014' --> 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','213776746','1666203154','213776746','2022-10-18T23:16:00.630','28912747','Sonia Lopez','BHGRE Gary Greene','','','30.134460','-95.386816','5','77386','7','299000.00','Active','Ginger Trace','30606','Drive','Spring','2','0','3','1728','Single-Family','Welcome Home! This beauty is nestled in the quaint community of Legends Trace. Walk into the home with the formal dining on the left with 11 foot ceilings in the dining, kitchen, and living room areas. The kitchen with island is perfect for the chef in your family. The primary bedroom is split from the other bedrooms. Primary bathroom has double sinks and separate tub n shower. The backyard has a covered patio perfect for entertaining. Zoned to the much sought after Conroe ISD and located a mere 5 minutes from the Grand Parkway for an easy commute to the airport and also close to the Woodlands for all of your shopping needs. Contact me for a private showing today, it will not last long.','','15','','','','','Mud,Sellers Disclosure','1','Freestanding','1','Spring Northeast','Central Electric,Central Gas','1','Legends Trace 01, Block 1, Lot 10','Other','5250','Appraisal District','','520','0','','','Gas Oven','0','','','Gas Cooktop','','Other','11 - Conroe','BRADLEY ELEMENTARY SCHOOL (CONROE)','GRAND OAKS HIGH SCHOOL','YORK JUNIOR HIGH SCHOOL','Accompany,Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment','Appraisal District','1','Traditional','Legends Trace','','','Water District','2009','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','213780250','1666203154','213780250','2022-10-18T23:48:11.297','90319266','Debra Roobaert','Tricia Turner Properties','','','29.808576','-95.829924','29','77493','10','330000.00','Active','North Fawnlake','6122','Drive','Katy','2','0','3','2068','Single-Family','PERFECT LOCATION! NO FLOODING! Lovely, move-in ready home is a must see and nestled in the heart of Katy. This beautiful home is located in the Fawnlake Community which is zoned to the highly acclaimed Katy ISD. A spacious one-story floorplan with 3 bedrooms, 2 full baths, open kitchen, living and dining areas with a lot of natural light throughout, high ceilings, and beautiful views of the stunning covered patio area and backyard. The garage has a convenient work and storage space with Epoxy Flooring to keep things clean. Recent upgrades include interior/exterior paint, new carpet, new back fence/gate, fresh landscaping, and roof in 2020. This Fawnlake Community brings a hometown feel with a park, scenic water views, and walking trails, but only a short distance from dining, shopping, the library, and entertainment. Minutes away from I-10 and Grand Parkway. Don\'t miss out on this ideal home! Schedule your showing, today.','','25','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gas Connections','1','Katy - Old Towne','Central Gas','1','Lot 48, Block 1','Subdivision Lot','','','','500','0','','2','Electric Oven','0','','','Electric Cooktop','','Composition','30 - Katy','KATY ELEMENTARY SCHOOL','KATY HIGH SCHOOL','KATY JUNIOR HIGH SCHOOL','Accompany,Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox','Appraisal District','1','Traditional','Fawnlake','','','Public Sewer,Public Water','2005','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','213797035','1666203154','213797035','2022-10-18T23:24:15.753','88338696','Aiza Tufail','NXTSQFT.COM','','','29.633767','-95.467000','12','77085','4','249900.00','Active','Tidewater','5615','Drive','Houston','2','1','4','1527','Single-Family','Charming corner home, 2-story, 4 bed, 2.5 bath, conveniently located on S post oak just a few minutes away from 90. The kitchen has brand new appliances (stove, microwave, dishwasher), and granite countertops. The home has brand new carpet upstairs and tile throughout the first floor, fully fenced backyard, 2 car attached garage with lift, formal dining room, living room with a cozy fireplace. Master bedroom has a ceiling fan and shower/tub combo. Utility room is located on the 2nd floor with washer and dryer connections. Schedule your tour today! This gem won\'t last long.','','20','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','Five Corners','Central Electric','1','LT 23 BLK 1 POST OAK PLACE SEC 2','Subdivision Lot','','','','','0','','2','','0','','','','','Wood Shingle','27 - Houston','HINES-CALDWELL ELEMENTARY SCHOOL','MADISON HIGH SCHOOL (HOUSTON)','LAWSON MIDDLE SCHOOL','Accompany,Appointment Required,Lockbox Front,Request Online Appointment,Vacant/Unoccupied','Appraisal District','2','Contemporary/Modern','Post Oak Place Sec 02','','','Public Sewer,Public Water','2002','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','213797433','1666203154','213797433','2022-10-18T22:41:15.853','25988110','Monty Singh','RE/MAX Universal','','','29.812052','-95.495614','35','77055','6','379990.00','Active','Brecha','8304','Lane','Houston','3','1','3','1774','Single-Family','*LOW INTEREST RATE OFFERED, BUILDER PAYS BUYDOWN* NEW CONSTRUCTION Gated Community in Spring Branch!! Stunning 3 bed 3.5 Bath homes with private backyards centrally located inner city and minutes away from City Centre, Energy Corridor, and downtown Houston! Modern Open concept floorplan, Living and Kitchen area on the 2nd floor, massive kitchen island with shaker cabinets and elegant quartz counter-tops, living area opens up into a spacious exterior balcony. Beautiful finishes and fine craftsmanship adorn each floor. Stainless steel appliances, fine hardware, high ceilings on all levels make this community a one of a kind. BONUS: Smart Home setup WIFI Garage Door Opener/Thermostat, Pre-Wired for Surround Sound in Living Room & Master Suite, Smart Home, CAT 5 wiring, TV/Internet setup in every room, Wide 28ft streets with Guest Parking inside the community. Selection Sheet of all Finishes available upon request. Schedule your Private-Tour today!','','24','RDZ Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Other Disclosures','1','','','Spring Branch','Central Gas','1','LT 11 BLK 1 ESTATES AT PECH ROAD','Subdivision Lot','1401','Appraisal District','','1300','1','To Be Built/Under Construction','2','Freestanding Oven,Single Oven','0','','','Freestanding Range,Gas Range','','Composition','49 - Spring Branch','RIDGECREST ELEMENTARY SCHOOL (SPRING BRANCH)','NORTHBROOK HIGH SCHOOL','LANDRUM MIDDLE SCHOOL','Appointment Required','Builder','3','Contemporary/Modern','Estates at Pech Road','','2.44','Public Sewer,Public Water','2022','Builder'); --> 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','213797910','1666203154','213797910','2022-10-18T22:23:13.910','35230085','Stacey Roberts','RE/MAX Integrity','','','30.341918','-95.511440','34','77304','7','275000.00','Active','Parnevik','2006','Place','Conroe','2','0','3','1785','Single-Family','Remarkably beautiful 1 story located in the sought after Wedgewood Falls; this home features 3 beds, 2 baths, an open flowing layout with high ceilings, split floorplan and an attached 2-car garage! Your entertaining ready kitchen features an oversized granite island with breakfast bar, complementing subway backsplash, gorgeous cabinets, just steps away from the spacious dining area and living room. Feel like royalty in your secluded primary bedroom that has plenty of room for bedroom furniture and sitting area. Make sure you check out the great sized primary closet and linen closet! With a neighborhood nature lot on one side of you and part of a greenbelt behind your fence you can enjoy family time outside. Conveniently located with easy access to TX-105, I-45, and just minutes to fine dining and luxury shopping!','0.1502','19','KB','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','','','Lake Conroe Area','Central Gas','1','S954302 - WEDGEWOOD FALLS 02, BLOCK 4, LOT 1','Subdivision Lot','6544','Appraisal District','','665','0','','2','Gas Oven','0','','','Gas Cooktop','','Composition','11 - Conroe','GIESINGER ELEMENTARY SCHOOL','CONROE HIGH SCHOOL','PEET JUNIOR HIGH SCHOOL','Appointment Required,Lockbox Front,Supra Keybox','Seller','1','Traditional','Wedgewood Falls','7864','2.8863','Public Sewer,Public Water','2018','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','213800695','1666203154','213800695','2022-10-18T22:40:15.500','14957170','Monty Singh','RE/MAX Universal','','','29.812052','-95.495614','35','77055','6','384990.00','Active','Brecha','8311','Lane','Houston','3','1','3','1774','Single-Family','*LOW INTEREST RATE OFFERED, BUILDER PAYS BUYDOWN* PHASE 2 NOW SELLING!! NEW CONSTRUCTION Gated Community in Spring Branch!! Stunning 3 bed 3.5 Bath homes with private backyards centrally located inner city and minutes away from City Centre, Energy Corridor, and downtown Houston! Modern Open concept floorplan, Living and Kitchen area on the 2nd floor, massive kitchen island with shaker cabinets and elegant quartz counter-tops, living area opens up into a spacious exterior balcony. Beautiful finishes and fine craftsmanship adorn each floor. Stainless steel appliances, fine hardware, high ceilings on all levels make this community a one of a kind. BONUS: Smart Home setup WIFI Garage Door Opener/Thermostat, Pre-Wired for Surround Sound in Living Room & Master Suite, Smart Home, CAT 5 wiring, TV/Internet setup in every room, Wide 28ft streets with Guest Parking inside the community. Selection Sheet of all Finishes available upon request. Schedule your Private-Tour today!','','24','RDZ Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Other Disclosures','1','','','Spring Branch','Central Gas','1','LT 8 BLK 2 ESTATES AT PECH ROAD','Subdivision Lot','1401','Appraisal District','','1300','1','To Be Built/Under Construction','2','Freestanding Oven,Single Oven','0','','','Freestanding Range,Gas Range','','Composition','49 - Spring Branch','RIDGECREST ELEMENTARY SCHOOL (SPRING BRANCH)','NORTHBROOK HIGH SCHOOL','LANDRUM MIDDLE SCHOOL','Appointment Required','Builder','3','Contemporary/Modern','Estates at Pech Road','','2.44','Public Sewer,Public Water','2022','Builder'); --> 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','213800835','1666203154','213800835','2022-10-18T22:43:57.593','43895260','Kasie Chambers','eXp Realty, LLC','','','29.537705','-95.297833','15','77584','9','329999.00','Active','Spring Circle','3901','Drive','Pearland','2','1','4','2292','Single-Family','Beautifully updated 2-story home nestled in the heart of Pearland. Located in the quiet Spring Field community, this home offers 4 bedrooms, 2.5 baths, formal sitting AND dinning area that can be used as you like, large backyard with custom deck, oversized garage and lots of new finishes! Kitchen with updated backsplash, new Corian counters, custom cabinet system, upgraded LG appliances, 5 burner stove with griddle and oven with built-in air fryer. AC unit only 3 years old! Custom built BBQ Pitt & storage shed in backyard stays!\r\n***Buyer to verify all measurements***','0.2114','5','Pulte','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','','1','Pearland','Central Gas','1','SPRINGFIELD (PEARLAND) (A0509 H T & B) BLK 1 LOT 7 (REPLAT)','Subdivision Lot','9209','Appraisal District','','158','0','','2','Gas Oven','0','','','Gas Cooktop','','Composition','42 - Pearland','MAGNOLIA ELEMENTARY SCHOOL (PEARLAND)','PEARLAND HIGH SCHOOL','PEARLAND JUNIOR HIGH SOUTH','Appointment Required','Appraisal District','2','Traditional','Springfield Pearland','6776','2.5552','Public Sewer,Public Water','1994','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','213802254','1666203154','213802254','2022-10-18T22:39:09.167','9675936','Monty Singh','RE/MAX Universal','','','29.812052','-95.495614','35','77055','6','384990.00','Active','Brecha','8313','Lane','Houston','3','1','3','1774','Single-Family','** LOW INTEREST RATE OFFERED; BUILDER PAYS BUYDOWN ** MODEL HOME OPEN! NEW CONSTRUCTION Gated Community in Spring Branch!! Stunning 3 bed 3.5 Bath homes with private backyards. Modern Open concept floorplan, Living and Kitchen area on the 2nd floor, massive kitchen island with shaker cabinets and elegant quartz counter-tops, living area opens up into a spacious exterior balcony. Beautiful finishes and fine craftsmanship adorn each floor. Stainless steel appliances, fine hardware, high ceilings on all levels make this community a one of a kind. BONUS: Smart Home setup WIFI Garage Door Opener/Thermostat, Pre-Wired for Surround Sound in Living Room & Master Suite, Smart Home, CAT 5 wiring, TV/Internet setup in every room, Wide 28ft streets with Guest Parking inside the community. Selection Sheet of all Finishes available upon request. Centrally located inner city and minutes away from City Centre, Energy Corridor, and downtown Houston! Preview Link for 3D tour of Home!','','24','RDZ Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Other Disclosures','1','','','Spring Branch','Central Gas','1','LT 7 BLK 2 ESTATES AT PECH ROAD','Subdivision Lot','1401','Appraisal District','','1300','1','To Be Built/Under Construction','2','Freestanding Oven,Single Oven','0','','','Freestanding Range,Gas Range','','Composition','49 - Spring Branch','RIDGECREST ELEMENTARY SCHOOL (SPRING BRANCH)','NORTHBROOK HIGH SCHOOL','LANDRUM MIDDLE SCHOOL','Appointment Required','Builder','3','Contemporary/Modern','Estates at Pech Road','','2.44','Public Sewer,Public Water','2022','Builder'); --> 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','213803546','1666203154','213803546','2022-10-18T22:37:55.957','2361096','Monty Singh','RE/MAX Universal','','','29.812052','-95.495614','34','77055','6','379990.00','Active','Brecha','8306','Lane','Houston','3','1','3','1774','Single-Family','** LOW INTEREST RATE OFFERED; BUILDER PAYS BUYDOWN** PHASE 2 NOW SELLING!! NEW CONSTRUCTION Gated Community in Spring Branch!! Stunning 3 bed 3.5 Bath homes with private backyards centrally located inner city and minutes away from City Centre, Energy Corridor, and downtown Houston! Modern Open concept floorplan, Living and Kitchen area on the 2nd floor, massive kitchen island with shaker cabinets and elegant quartz counter-tops, living area opens up into a spacious exterior balcony. Beautiful finishes and fine craftsmanship adorn each floor. Stainless steel appliances, fine hardware, high ceilings on all levels make this community a one of a kind. BONUS: Smart Home setup WIFI Garage Door Opener/Thermostat, Pre-Wired for Surround Sound in Living Room & Master Suite, Smart Home, CAT 5 wiring, TV/Internet setup in every room, Wide 28ft streets with Guest Parking inside the community. Selection Sheet of all Finishes available upon request. Schedule your Private-Tour today!','','24','RDZ Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Other Disclosures','1','','','Spring Branch','Central Gas','1','LT 10 BLK 1 ESTATES AT PECH ROAD','Subdivision Lot','1401','Appraisal District','','1300','1','To Be Built/Under Construction','2','Freestanding Oven,Single Oven','0','','','Freestanding Range,Gas Range','','Composition','49 - Spring Branch','RIDGECREST ELEMENTARY SCHOOL (SPRING BRANCH)','NORTHBROOK HIGH SCHOOL','LANDRUM MIDDLE SCHOOL','Appointment Required','Builder','3','Contemporary/Modern','Estates at Pech Road','','2.44','Public Sewer,Public Water','2022','Builder'); --> 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','213809001','1666203154','213809001','2022-10-18T22:21:30.843','56057190','Lynn Beardslee','JPAR - The Sears Group','','','29.400330','-94.938151','20','77590','3','184900.00','Active','16th','2918','Avenue','Texas City','1','1','3','1250','Single-Family','Adorable brick 3 bedroom, 1 1/2 bath home, close to schools and shopping. Updated kitchen with all appliances. Over-sized backyard with room for a pool. Spacious 2-car attached garage.','0.1377','33','','','','','Real Estate Owned','1','','','Texas City','Central Gas','0','ABST 142 R LOGAN SUR LOT 33 WESTHAVEN','Cleared','6000','Appraisal District','','','0','','2','Gas Oven','0','','','Freestanding Range','','Composition','52 - Texas City','GUAJARDO ELEMENTARY SCHOOL','TEXAS CITY HIGH SCHOOL','BLOCKER MIDDLE SCHOOL','Appointment Required','Appraisal','1','Ranch','Westhaven','3597','2.5335','Public Sewer,Public Water','1979','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','213817061','1666203154','213817061','2022-10-18T22:46:13.187','77044923','Seema Pirzada','PIRZADA VENTURES LLC','','','29.653418','-95.695623','31','77407','9','669999.00','Active','Fermill','11119','Court','Richmond','4','1','5','3182','Single-Family','GORGEOUS STUCCO SHOWSTOPPER IN ALIANA THATS BETTER THAN NEW! AMAZING ONE AND A HALF STORY HOME LOCATED IN QUIET QUL-DE-SAC THAT\'S CONVENIENTLY LOCATED ACROSS THE STREET FROM MADDEN ELEMENTARY! TONS OF UPGRADES! BEAUTIFUL FRONT ELEVATION, HIGH CEILINGS AND FORMAL DINING WELCOME YOU HOME. CHEF INSPIRED KITCHEN W/ GRANITE COUNTERTOPS, SS APPLIANCES & HUGE ISLAND OPENS UP INTO LIVING ROOM WITH HIGH CEILINGS AND GORGEOUS STONE FIREPLACE. THIS FLOOR PLAN IS GREAT FOR ENTERTAINING! HUGE MASTER RETREAT W/ SPA LIKE BATH! 4 BEDROOMS LOCATED DOWNSTAIRS, SECOND FLOOR WITH GAME ROOM, LARGE BEDROOM AND FULL BATHROOM. TONS OF STORAGE SPACE! COVERED PATIO AND PRIVATE BACKYARD. ZONED TO GREAT SCHOOLS! EASY ACCESS TO 6, 59, 90, 99, I10, & WESTPARK TOLLWAY! PRICED TO SELL!','0.1604','37','','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Gas Connections','1','Sugar Land West','Central Electric,Central Gas','1','ALIANA SEC 11, BLOCK 1, LOT 26','Cul-De-Sac','6988','Appraisal District','','1137','0','','2','Convection Oven,Gas Oven','0','','','Gas Cooktop','','Composition','19 - Fort Bend','MADDEN ELEMENTARY SCHOOL','TRAVIS HIGH SCHOOL (FORT BEND)','GARCIA MIDDLE SCHOOL (FORT BEND)','Appointment Required,Supra Keybox','Appraisal District','1','Contemporary/Modern','Aliana Sec 11','11901','2.9329','Public Sewer,Public Water,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','213817442','1666203154','213817442','2022-10-18T22:29:13.363','27571893','Amberly Savage','Ward Real Estate, Inc','','','29.003235','-95.950427','30','77414','4','395000.00','Active','Birkhill','3206','Court','Bay City','2','1','4','2861','Single-Family','Beautiful turn-key ready home located in the desired Golden Glen subdivision. Built in 2017, this 4 bed 2.5 bath home features tall ceilings, granite countertops, and a charming back yard. The large primary bedroom just received new carpet and bathroom features separate shower, soaking tub, his and her closets and double sinks. A huge flex space up stairs allows for home office, playroom or second living room.','0.2342','54','','','','','Sellers Disclosure','1','','','','Central Gas','0','GOLDEN GLEN S/D, BLOCK 1, LOT 53','Subdivision Lot','10203','Appraisal District','','','0','','2','','0','','','','','Composition','132 - Bay City','TENIE HOLMES ELEMENTARY SCHOOL','BAY CITY HIGH SCHOOL','BAY CITY JUNIOR HIGH SCHOOL','Lockbox Front','Appraisal District','2','Traditional','Golden Glen Sub','7569','2.8238','Public Sewer,Public Water','2017','Appraisal District'); --> New record created successfully