Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-27T07:29:48.430' ,`MLSNumber` = '77083250' ,`ListAgentFullName` = 'Adriana Banks' ,`ListOfficeName` = 'Douglas Elliman Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.765244' ,`Longitude` = '-95.468877' ,`PhotoCount` = '36' ,`PostalCode` = '77056' ,`RoomCount` = '17' ,`ListPrice` = '5375000.00' ,`Status` = 'Active' ,`StreetName` = 'Green Tree' ,`StreetNumber` = '5215' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '6' ,`BathsHalf` = '2' ,`BedsTotal` = '6' ,`SqFtTotal` = '9646' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Enjoy exceptional indoor-outdoor living and entertaining in this stunning estate in Tanglewood area(Pine Shadows) featuring bespoke craftsmanship and premium finishes. Soaring ceilings, designer lighting and gleaming marble and ceramic floors. A grand formal living room and dining/family open room share a stone fireplace, and the work-of-art kitchen boasts double islands, custom cabinetry and a fleet of state-of-art stainless-steel appliances. A powder room, oversized closets and a bar area make gracious entertaining effortless. The massive family room opens to a backyard oasis with a covered pavilion, summer kitchen, staff rooms, gym, office, luxurious secondary bedroom suites and storage. Elevator, Creston controls, generator, integrated speakers, alarm and more. Circular drive and 3-car garage with EV charging. Ideal location close to Memorial Park and Galleria. Must see!' ,`Acres` = '' ,`Area` = '22' ,`BuilderName` = 'Davis' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tanglewood Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 19 BLK 2 BAYOU GLEN' ,`LotDesciption` = 'Other' ,`LotSize` = '14076' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BRIARGROVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WISDOM HIGH SCHOOL' ,`SchoolMiddle` = 'TANGLEWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern,Mediterranean,Spanish' ,`Subdivision` = 'Pine Shadows' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664310760' WHERE `Matrix_Unique_ID` = '204976872' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-27T07:46:08.210' ,`MLSNumber` = '12477933' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'Highland Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.161087' ,`Longitude` = '-95.589383' ,`PhotoCount` = '50' ,`PostalCode` = '77354' ,`RoomCount` = '8' ,`ListPrice` = '459990.00' ,`Status` = 'Active' ,`StreetName` = 'Flintlock Trail' ,`StreetNumber` = '27014' ,`StreetSuffix` = '' ,`City` = 'Magnolia' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2472' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 12477933 - Built by Highland Homes - Ready now! ~ Walk in to this beautiful two story entryway featuring a rod iron bannister staircase and 10’ ceilings in the downstairs area. The second bedroom and full bath are downstairs with three bedrooms and a bath upstairs and game room. The primary bedroom also has a bay window sitting area and an extended outdoor living area. Plenty of room for entertaining all year round! Smart Home Technology, fully sod front and back yard with sprinkler system and no connecting back neighbors!!' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 7 Block 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6242' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1295' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'CEDRIC C. SMITH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'NorthGrove' ,`TaxAmount` = '' ,`TaxRate` = '3.21' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664310760' WHERE `Matrix_Unique_ID` = '205529153' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-27T07:44:22.100' ,`MLSNumber` = '9420882' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'Highland Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.410108' ,`Longitude` = '-95.058037' ,`PhotoCount` = '9' ,`PostalCode` = '77568' ,`RoomCount` = '3' ,`ListPrice` = '379990.00' ,`Status` = 'Active' ,`StreetName` = 'Cobalt Cove' ,`StreetNumber` = '13113' ,`StreetSuffix` = 'Court' ,`City` = 'Texas City' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1871' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 9420882 - Built by Highland Homes - Ready now! ~ Spacious two-story home! Completely Upgraded Kitchen features Painted Cabinets with Hardware, Pendant Lighting, Silestone Countertops, and Built-in Stainless Steel Appliances. Tile plank flooring is featured throughout the common area of the first floor! And as always, our ‘Smart from the Start’ Technology Package!!' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 59 BLK 1 LAGO MAR POD 5 SEC 3 (2021) ABST 11' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4304' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '850' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'LOBIT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'LOBIT MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lago Mar' ,`TaxAmount` = '' ,`TaxRate` = '3.65' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664310760' WHERE `Matrix_Unique_ID` = '205758170' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-27T07:45:14.860' ,`MLSNumber` = '64277226' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'Highland Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.161772' ,`Longitude` = '-95.589041' ,`PhotoCount` = '50' ,`PostalCode` = '77354' ,`RoomCount` = '8' ,`ListPrice` = '484990.00' ,`Status` = 'Active' ,`StreetName` = 'Axis Ridge' ,`StreetNumber` = '7844' ,`StreetSuffix` = 'Drive' ,`City` = 'Magnolia' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2472' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 64277226 - Built by Highland Homes - Ready now! ~ Walk in to this beautiful two story entryway featuring a rod iron bannister staircase and 10’ ceilings in the downstairs area. The second bedroom and full bath are downstairs with three bedrooms and a bath upstairs and game room. The primary bedroom also has a bay window sitting area and an extended outdoor living area. Plenty of room for entertaining all year round. As an added plus this home backs to green space so no back fence neighbors! Smart Home Technology, fully sod front and back yard with sprinkler system!' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 2 Block 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6124' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1295' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'CEDRIC C. SMITH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'NorthGrove' ,`TaxAmount` = '' ,`TaxRate` = '3.21' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664310761' WHERE `Matrix_Unique_ID` = '206151799' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-27T07:50:40.583' ,`MLSNumber` = '37610030' ,`ListAgentFullName` = 'Kathy Matt' ,`ListOfficeName` = 'Elite Texas Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.982973' ,`Longitude` = '-95.705249' ,`PhotoCount` = '50' ,`PostalCode` = '77429' ,`RoomCount` = '11' ,`ListPrice` = '369900.00' ,`Status` = 'Active' ,`StreetName` = 'Auburn Woods' ,`StreetNumber` = '18426' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2395' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Totally Updated 4/2/2 One-Story in Cypress Mill features open floor plan, lots of closet space and the Kitchen/Breakfast/Family Room are all open to each other. There is a Living Room/Dining Room Combo near the Entry and the 4th bedroom is currently accessed thru double French doors. It has a closet and is now being used as a Home Office. This home has Recent flooring, updated Kitchen and Bathrooms and fresh interior paint. The Large Backyard has a deck and pergola. Located jut minutes from Hwy. 290, the Beltway, the Grand Parkway and to restaurants, shopping and medical offices. This home is Move-In Ready and is situated in the Highly Acclaimed Cy Fair School District.' ,`Acres` = '0.1531' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 7 BLK 1 CYPRESS MILL SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6670' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '640' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`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 Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cypress Mill' ,`TaxAmount` = '6776' ,`TaxRate` = '2.761' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1996' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664310761' WHERE `Matrix_Unique_ID` = '207364948' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-27T06:26:07.953' ,`MLSNumber` = '34901663' ,`ListAgentFullName` = 'Domenic Santilli' ,`ListOfficeName` = 'Capital Trust Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.485533' ,`Longitude` = '-95.508940' ,`PhotoCount` = '40' ,`PostalCode` = '77459' ,`RoomCount` = '10' ,`ListPrice` = '515000.00' ,`Status` = 'Active' ,`StreetName` = 'Monarch' ,`StreetNumber` = '2827' ,`StreetSuffix` = 'Crossing' ,`City` = 'Missouri City' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '3119' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful home in Sienna Plantation on a very private street. No neighbors across the street or behind the house. Two story entry, formal dining, engineered wood floors, great room with lots of windows looking into the back yard, nice kitchen with breakfast area and eat in island. Two bedrooms down plus two full bathrooms down, the master suite and one mother in law bedroom. Upstairs features 3 additional bedrooms, 2 more full bathrooms and a nice sized game room. Spacious back yard with covered patio. Home DO NOT flood. Fully fenced yard, no back neighbors. Zoned to Fort Bend schools. Sienna amenities include water parks, pools, recreation centers, gym. Golf Club, walking trails.' ,`Acres` = '0.1794' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SIENNA PLANTATION SEC 20, BLOCK 1, LOT 18' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7814' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1254' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'LEONETTI ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sienna Plantation Sec 20' ,`TaxAmount` = '12345' ,`TaxRate` = '3.1629' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664310761' WHERE `Matrix_Unique_ID` = '208264361' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-27T07:05:36.447' ,`MLSNumber` = '76848675' ,`ListAgentFullName` = 'Sally James' ,`ListOfficeName` = 'CB&A, Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.837922' ,`Longitude` = '-95.441157' ,`PhotoCount` = '50' ,`PostalCode` = '77018' ,`RoomCount` = '8' ,`ListPrice` = '580000.00' ,`Status` = 'Active' ,`StreetName` = 'Treebark' ,`StreetNumber` = '5011' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2345' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Outstanding 1-story home on a peaceful cul-de-sac lot zoned to Oak Forest Elementary. This open floor plan is perfect for entertaining & family living. Formal dining room at the front of the house was converted to home/office & formal living room was opened up to an enormous family room/flex space. The large kitchen features granite, ceramic tile backsplash, a Kohler sink, Frigidaire Electrolux cooktop & double oven. Additional updates include new carpet in family room & kitchen/family/bathroom has fresh paint. The roof was replaced in 2018. The owner’s retreat has 2 closets/en-suite bathroom with a vanity area. Plenty of room for furniture arrangement in the spacious secondary bedrooms & 2nd full bathroom has large vanity area. The detached 2 car garage/workshop with ample storage & the expansive backyard has plenty of room for a pool. This home on a cul-de-sac street with mature trees, zoned to Oak Forest Elem. has great curb appeal & move-in ready!' ,`Acres` = '0.2276' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Oak Forest East Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 7 BLK 2 CANDLELIGHT ESTATES SEC 2' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '9915' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'OAK FOREST ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'BLACK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Candlelight Estates Sec 02' ,`TaxAmount` = '10855' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1963' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664310761' WHERE `Matrix_Unique_ID` = '209528620' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-27T06:29:37.553' ,`MLSNumber` = '68629672' ,`ListAgentFullName` = 'Domenic Santilli' ,`ListOfficeName` = 'Capital Trust Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.490684' ,`Longitude` = '-95.122102' ,`PhotoCount` = '20' ,`PostalCode` = '77573' ,`RoomCount` = '5' ,`ListPrice` = '249900.00' ,`Status` = 'Active' ,`StreetName` = 'Mimosa' ,`StreetNumber` = '2309' ,`StreetSuffix` = 'Court' ,`City` = 'League City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1704' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great one story home in Newport. This home is zoned to Clear Creek ISD. The kitchen opens to dining & living area. The living room has a tile surround fireplace, crown molding in entry and living area, black on black appliance in kitchen, double oven, bar top separates dining from living, garage door opener, mature trees, covered back patio/deck area, 4 sides brick. Needs a little love to make it your own. Roof replaced 2017.' ,`Acres` = '0.1567' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 3 PAGE 3 LOT 5 BLK 19 NEWPORT SEC 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6825' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '45' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'ROSS ELEMENTARY SCHOOL (CLEAR CREEK)' ,`SchoolHigh` = 'CLEAR SPRINGS HIGH SCHOOL' ,`SchoolMiddle` = 'CREEKSIDE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Call Occupant' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Newport 6' ,`TaxAmount` = '4444' ,`TaxRate` = '2.0697' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1973' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664310761' WHERE `Matrix_Unique_ID` = '209641553' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-27T07:28:51.693' ,`MLSNumber` = '79986089' ,`ListAgentFullName` = 'Maria Barnabe' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.847203' ,`Longitude` = '-95.591676' ,`PhotoCount` = '38' ,`PostalCode` = '77041' ,`RoomCount` = '12' ,`ListPrice` = '599000.00' ,`Status` = 'Active' ,`StreetName` = 'Chase' ,`StreetNumber` = '5514' ,`StreetSuffix` = 'Harbor' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3582' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful multi-tonal brick home with unique facade that sets the tone for the rest of the house. Arched and semi arched windows graces this Cottage-Style home. Lot backs to the green belt contributing to the privacy of the lush green backyard and refreshing pool and spa. Impressive and welcoming foyer leads the way to the living area that flows to breakfast room and kitchen. Double-pane windows on first floor, well kept Cherry wood floors, high ceilings in living room, 2020 new roof, built in office cabinets, these are just a few of the array of details that makes this property very desirable. Gated community built around a lake with cycling/jog/walk trail. Buses stop here for the Awty, British International, and Village school. Within minutes to the energy corridor area, shopping area, restaurants and venues, I-10, Hwy 8, and 290. Summer time pool time!\r\nNEW PHOTOS COMING UP! In the meantime imagine your personal style in this white canvas.' ,`Acres` = '0.212' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Eldridge North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 13 BLK 1 LAKES ON ELDRIDGE SEC 18' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9235' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1670' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'KIRK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'TRUITT MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Call Occupant,Controlled Access,Lockbox Right Side,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakes On Eldridge Sec 18' ,`TaxAmount` = '11767' ,`TaxRate` = '2.471' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664310761' WHERE `Matrix_Unique_ID` = '209797089' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-27T07:01:51.607' ,`MLSNumber` = '26969376' ,`ListAgentFullName` = 'Jo Anne Johnson' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.935651' ,`Longitude` = '-95.688141' ,`PhotoCount` = '43' ,`PostalCode` = '77433' ,`RoomCount` = '12' ,`ListPrice` = '675000.00' ,`Status` = 'Active' ,`StreetName` = 'Dawn River' ,`StreetNumber` = '10711' ,`StreetSuffix` = 'Court' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3541' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'LIKE NEW w/UPGRADES THROUGHOUT! Situated in coveted Towne Lake community w/amenities ranging from Lazy River, Splash Pad, resort pools, Boardwalk w/shops, dining, daily services, trails, parks, recreational courts, lake use, boating & more! This Village Builders home is fresh & inspiring, keeping with modern buyer demands! Premium cul-de-sac lot and classic stone & stucco elevation w/oversized 2+1 garage w/carriage door accents - framing its irresistible curb appeal! Contemporary entry & welcoming foyer highlight 1st impressions + study w/beamed ceiling, versatile dining rm, offset utility rm & powder rm, gourmet kitchen w/walk-in pantry, custom encased cooking hearth w/stainless vent hood, 2-story den, cast stone fireplace, wall of wdws overlooking private backyard oasis, and secluded owners retreat w/luxe primary bath w/dressing mirror! Spacious secondary BR\'s feature a guest suite + game/media rooms upstairs! Awesome storage w/TX basement & award-winning schools in all of Houston!' ,`Acres` = '0.1693' ,`Area` = '25' ,`BuilderName` = 'Village Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 16 BLK 4 TOWNE LAKE SEC 46' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '7376' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1699' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'RENNELL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'ANTHONY MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Towne Lake' ,`TaxAmount` = '16942' ,`TaxRate` = '3.471' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664310762' WHERE `Matrix_Unique_ID` = '209825587' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-27T07:26:09.520' ,`MLSNumber` = '20344156' ,`ListAgentFullName` = 'Kaye Kaye Smith' ,`ListOfficeName` = 'Legacy Real Estate Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.432844' ,`Longitude` = '-94.281858' ,`PhotoCount` = '24' ,`PostalCode` = '75972' ,`RoomCount` = '3' ,`ListPrice` = '359900.00' ,`Status` = 'Active' ,`StreetName` = 'CR 3137' ,`StreetNumber` = '6551' ,`StreetSuffix` = '' ,`City` = 'San Augustine' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1860' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Looking for some farm life with amazing views of your property, pond and livestock? Here it is! This is 35.78 acres of awesome pasture land with barbed wire fence, pond and a perfect hill which is occupied by a beautiful DW. You will most likely find yourself out on the front and back porches with your favorite beverage enjoying the breeze, peace and quiet while watching the cattle graze and deer pass through. This property is located between Broaddus and San Augustine in Broaddus ISD. There is also a perfect place with full utility connections for another home site. MAKE AN OFFER!' ,`Acres` = '35.78' ,`Area` = '78' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'AB 4 M CARTWRIGHT & IMP - 35.784 acres' ,`LotDesciption` = 'Cleared' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '232 - Broaddus' ,`SchoolElementary` = 'BROADDUS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BROADDUS HIGH SCHOOL' ,`SchoolMiddle` = 'BROADDUS HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'None' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664310762' WHERE `Matrix_Unique_ID` = '209951487' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-27T06:45:20.033' ,`MLSNumber` = '78386330' ,`ListAgentFullName` = 'Kati Hall' ,`ListOfficeName` = 'RE/MAX On The Water - Bolivar' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.461387' ,`Longitude` = '-94.617376' ,`PhotoCount` = '35' ,`PostalCode` = '77650' ,`RoomCount` = '3' ,`ListPrice` = '580000.00' ,`Status` = 'Active' ,`StreetName` = 'Antigua' ,`StreetNumber` = '2341' ,`StreetSuffix` = 'Circle' ,`City` = 'Crystal Beach' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1558' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Ready for life at the Beach!?! This beautiful New Construction home located in Sandpiper Subdivision offers water views as well as walking distance to the Beach! Open concept Kitchen/Livingroom area with Shiplap accent wall. Crown Molding throughout the home. Primary Bedroom offers great views with tons of natural lighting. The en-suite bathroom offers double sinks, over-sized shower with rainfall shower head, and large closet perfect for an Owner\'s closet. Upstairs you will find a full bath with amazing views of the Gulf! Perfect place for a bunkroom! This one wont last long!' ,`Acres` = '0.246' ,`Area` = '33' ,`BuilderName` = 'Prestige' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Crystal Beach' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 65 FRANKS B SUR LOT 57 BLK 1 SANDPIPER BEACH' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '10716' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required,Lockbox Right Side,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Sandpiper Beach' ,`TaxAmount` = '476' ,`TaxRate` = '1.6103' ,`WaterSewer` = 'Aerobic,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664310762' WHERE `Matrix_Unique_ID` = '210072124' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-27T07:40:30.113' ,`MLSNumber` = '15438596' ,`ListAgentFullName` = 'Terin Varghese' ,`ListOfficeName` = 'XAG Properties, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.137773' ,`Longitude` = '-95.648119' ,`PhotoCount` = '13' ,`PostalCode` = '77362' ,`RoomCount` = '6' ,`ListPrice` = '289000.00' ,`Status` = 'Active' ,`StreetName` = 'Elizabeth' ,`StreetNumber` = '11719' ,`StreetSuffix` = 'Court' ,`City` = 'Pinehurst' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1904' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come see this beautiful home featuring 3 Large Bedrooms, 2 Bath, 2 Car Garage with a huge backyard, Foyer entrance, Large Living room with lots of natural lighting and gas lines with wood burning fireplace. New carpets in some rooms in 2018, Kitchen showcases an island w/separate Dining area, Large Primary Bedroom features Walk in closets, Standing showing and tub with HIS & Her Vanity! Close to Lone Star College& SH 249 for an easy commute!!! Tomball I.S.D. A Must See!!!!!!!' ,`Acres` = '0.1541' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tomball' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S942602 - VILLAGE OF DECKER OAKS 02, BLOCK 2, LOT 6, ACRES 0' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6712' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '523' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'DECKER PRAIRIE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'TOMBALL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Village Of Decker Oaks 02' ,`TaxAmount` = '3824' ,`TaxRate` = '1.9215' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664310762' WHERE `Matrix_Unique_ID` = '210385803' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-27T07:36:39.720' ,`MLSNumber` = '88804096' ,`ListAgentFullName` = 'Kiara Estis' ,`ListOfficeName` = 'Keller Williams Realty -SW' ,`SellingAgentFullName` = 'Thao Dinh' ,`SellingOfficeName` = 'World Wide Realty' ,`Latitude` = '29.707870' ,`Longitude` = '-95.668078' ,`PhotoCount` = '26' ,`PostalCode` = '77083' ,`RoomCount` = '7' ,`ListPrice` = '255000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Alta Mesa' ,`StreetNumber` = '16011' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1837' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully Updated 3 BR Home conveniently located near the Westpark Tollway! Spacious Primary Bedroom with sitting area. Brand new Flooring, redone Kitchen, and freshly painted. Amazing swing on the back patio. Tremendous value, it won\'t last long!' ,`Acres` = '0.1663' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Levee District,Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Mission Bend Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 76 BLK 8 MISSION BEND SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7245' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '220' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '2 - Alief' ,`SchoolElementary` = 'PETROSKY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AISD DRAW' ,`SchoolMiddle` = 'ALBRIGHT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Mission Bend Sec 01' ,`TaxAmount` = '4213' ,`TaxRate` = '2.437' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664310762' WHERE `Matrix_Unique_ID` = '210411016' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-27T07:45:20.100' ,`MLSNumber` = '75282685' ,`ListAgentFullName` = 'John Garza' ,`ListOfficeName` = 'Windsor Hill Real Estate Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.588535' ,`Longitude` = '-95.046819' ,`PhotoCount` = '42' ,`PostalCode` = '77586' ,`RoomCount` = '4' ,`ListPrice` = '765000.00' ,`Status` = 'Active' ,`StreetName` = 'Shoreline' ,`StreetNumber` = '1823' ,`StreetSuffix` = 'Drive' ,`City` = 'Seabrook' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3384' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Exclusive Waterfront Neighborhood of Taylor Lake Shores is where you\'ll find this incredible fully updated 3,384 square foot home on a huge 32,597 square foot corner lot, a private community boat ramp, and an all night security guard with 24 hour surveillance. \r\nThe completely updated home features quartzite kitchen countertops, tons of counter & cabinet space, the large living room looks out to the back porch and features a remote fireplace. The oversized master bedroom has vaulted ceilings and master bath has a jacuzzi tub, and a large his and her closet. The home also has a mother-in-law suite which can be used for a guest room or hobby room. Plus. A new Roof (2021) and a new HVAC (2022), an extra long 3-car Garage, Sprinkler system, and Security cameras to boot. This home has never flooded. And zoned to award winning CCISD schools. \r\nCome see this beauty before it’s gone. \r\n\r\nAll information is per the seller.*' ,`Acres` = '0.7483' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Clear Lake Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 3 BLK 2 HARBOUR VILLAGE AMEND' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '32597' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1800' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'ROBINSON ELEMENTARY SCHOOL (CLEAR CREEK)' ,`SchoolHigh` = 'CLEAR LAKE HIGH SCHOOL' ,`SchoolMiddle` = 'SEABROOK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Harbour Village Amd' ,`TaxAmount` = '17783' ,`TaxRate` = '2.5419' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664310762' WHERE `Matrix_Unique_ID` = '210513961' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-27T06:59:07.307' ,`MLSNumber` = '25080930' ,`ListAgentFullName` = 'Stephen Metarelis' ,`ListOfficeName` = 'Offerpad Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.481261' ,`Longitude` = '-95.131359' ,`PhotoCount` = '11' ,`PostalCode` = '77573' ,`RoomCount` = '4' ,`ListPrice` = '369900.00' ,`Status` = 'Active' ,`StreetName` = 'Kingfisher' ,`StreetNumber` = '2117' ,`StreetSuffix` = 'Court' ,`City` = 'League City' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2390' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful and well-kept two-story, 4 Bedroom, 2 1/2 Bath home in Brittany Lakes with new A/C condensor. Super clean and move-in ready. Fresh exterior and interior paint. The Kitchen features new granite countertops with all stainless steel appliances including new range. New carpet. Primary Bedroom is spacious with private adjoining Bathroom featuring dual sinks, jetted tub and separate shower. Huge covered patio and fully fenced backyard for privacy and outdoor entertainment areas. Big backyard with storage shed. Refrigerator, Washer/Dryer stay. Easy access to Kemah Boardwalk and Space Center. Welcome home!' ,`Acres` = '0.1648' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'BRITTANY LAKES SEC 9 (2004) ABST 9, BLOCK 2, LOT 33, ACRES 0' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7179' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'GILMORE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR SPRINGS HIGH SCHOOL' ,`SchoolMiddle` = 'VICTORYLAKES INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Brittany Lakes Sec 9 2004' ,`TaxAmount` = '6194' ,`TaxRate` = '2.2667' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664310763' WHERE `Matrix_Unique_ID` = '210684721' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-27T07:46:10.707' ,`MLSNumber` = '25837724' ,`ListAgentFullName` = 'Nicole Handy' ,`ListOfficeName` = 'Braden Real Estate Group, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.470012' ,`Longitude` = '-95.463956' ,`PhotoCount` = '12' ,`PostalCode` = '77583' ,`RoomCount` = '5' ,`ListPrice` = '299990.00' ,`Status` = 'Active' ,`StreetName` = 'Suffolk Valley' ,`StreetNumber` = '7718' ,`StreetSuffix` = 'Lane' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1501' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'DR Horton, America\'s #1 Builder! NEW CONSTRUCTION Camden Plan with Elevation N, features a modern design and offers 3 spacious bedrooms and 2 bathrooms, covered patio and 2-car garage! This open concept home has a stunning kitchen which includes quartz countertops, 42\" cabinets, and stainless & steel appliances. Delight yourself in the primary bathroom, with dual sinks, separate shower, garden tub (on select inventory homes) and a large walk-in closet! (All information provided by builder). Located in Rosharon\'s newest DR Horton Community, Caldwell Ranch this gorgeous community will feature a resort-style pool, Covered Pavilion with Picnic Tables, Splash areas, Water Slides, Soccer Fields, and miles of walking trails. Visit our onsite sales center today!\r\n\r\nListing photos are of a similar floor plan. Finishes may vary and are subject to change.' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'D.R. HORTON, INC' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'N/A' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '850' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'HERITAGE ROSE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required,No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Caldwell Ranch' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664310763' WHERE `Matrix_Unique_ID` = '210871396' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-27T07:57:20.267' ,`MLSNumber` = '42884461' ,`ListAgentFullName` = 'Cody Scurlock' ,`ListOfficeName` = 'Keller Williams Realty - Clear Lake/ NASA' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.940225' ,`Longitude` = '-95.207888' ,`PhotoCount` = '43' ,`PostalCode` = '77346' ,`RoomCount` = '8' ,`ListPrice` = '310000.00' ,`Status` = 'Active' ,`StreetName` = 'Spring Sun' ,`StreetNumber` = '15118' ,`StreetSuffix` = 'Court' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1939' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come out and see this beautiful K Hovananian 4-bedroom home with a pool! As soon as you drive up, you\'re welcomed with a wonderful, manicured lawn with bright green shrubs lining the covered porch. Come in and you will be delighted to see the stunning wood floors throughout the home that complement the grey-blue walls that offer a calming mood for when you arrive home after a busy day. Take a load off in the spacious living room, which is semi-open to the roomy kitchen and dining room. As you make your way further into the home you find 3 bedrooms that offer an abundance of space as well as the Master bedroom with a stunning master bathroom with a separate shower and soaking tub! The home also offers a sizable backyard with a water softener, pool, shed, and trampoline! Great location, easy commute, close by all stores, and friendly neighborhood!' ,`Acres` = '0.1346' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Summerwood/Lakeshore' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 15 BLK 2 SUNSET RIDGE SEC 4' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '5865' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Above Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'RIDGE CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'AUTUMN RIDGE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sunset Rdg Sec 04' ,`TaxAmount` = '6144' ,`TaxRate` = '3.0673' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664310763' WHERE `Matrix_Unique_ID` = '211097998' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-27T07:37:00.593' ,`MLSNumber` = '39374228' ,`ListAgentFullName` = 'Maria Barnabe' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.743593' ,`Longitude` = '-95.597526' ,`PhotoCount` = '45' ,`PostalCode` = '77077' ,`RoomCount` = '10' ,`ListPrice` = '480000.00' ,`Status` = 'Active' ,`StreetName` = 'Round Lake' ,`StreetNumber` = '1923' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2744' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This Pristine, beautiful property is located in the subdivision of Shadowbriar and set in a street ending on a cul-de-sac. Get ready for Summer and BBQ, gather family and friends around the sparkling pool, relax on the wooden deck under the shade of the pergola. Living area with cathedral ceilings, wet bar, and array of windows. There is a great flow from dining room to kitchen and breakfast area. Master bedroom on first floor just off entrance hall. Freshly painted, manicured back and front yard, granite counters, stainless steel appliances, interior balcony, these are just a few of the details that make this house unique. Natural light pouring in through array of windows around the house. Subdivision close to venues, a variety of international restaurants, specialty food markets, and for the outdoor family, Terry Hersey park, where you can run, cycle, walk etc. Within minutes from mayor Hwys 8, and Westpark. READ AND SIGN COVID-19 NOTICE' ,`Acres` = '0.1795' ,`Area` = '31' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Energy Corridor' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 91 BLK 6 SHADOWBRIAR SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7820' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '645' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ASHFORD/SHADOWBRIAR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'WEST BRIAR MIDDLE SCHOOL' ,`ShowInstructions` = 'Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Shadowbriar Sec 01' ,`TaxAmount` = '4095' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1981' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664310763' WHERE `Matrix_Unique_ID` = '211154413' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-27T07:54:38.340' ,`MLSNumber` = '43319904' ,`ListAgentFullName` = 'Lauren Silva' ,`ListOfficeName` = 'RE/MAX Adventure' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.515866' ,`Longitude` = '-95.820695' ,`PhotoCount` = '37' ,`PostalCode` = '77471' ,`RoomCount` = '8' ,`ListPrice` = '359900.00' ,`Status` = 'Active' ,`StreetName` = 'Walnut Green' ,`StreetNumber` = '1922' ,`StreetSuffix` = 'Circle' ,`City` = 'Rosenberg' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2572' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This gorgeous home in Rosenberg has all of the upgrades you desire! Large rooms, high ceilings, and so much storage. Walk-in closets, pantries, and a large laundry room. All with no back neighbors! Schedule your showing today and see how this is the home for you!' ,`Acres` = '0.1584' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'FAIRPARK VILLAGE SEC 5, BLOCK 3, LOT 26' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6900' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '533' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'CULVER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TERRY HIGH SCHOOL' ,`SchoolMiddle` = 'NAVARRO/GEORGE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Fairpark Village Sec 5' ,`TaxAmount` = '8300' ,`TaxRate` = '3.2048' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664310763' WHERE `Matrix_Unique_ID` = '211272445' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-27T07:25:21.580' ,`MLSNumber` = '55933700' ,`ListAgentFullName` = 'Mark Bland' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.510235' ,`Longitude` = '-95.737120' ,`PhotoCount` = '25' ,`PostalCode` = '77469' ,`RoomCount` = '8' ,`ListPrice` = '395000.00' ,`Status` = 'Active' ,`StreetName` = 'Shoal Valley' ,`StreetNumber` = '2406' ,`StreetSuffix` = 'Lane' ,`City` = 'Rosenberg' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2720' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 2406 Shoal Valley Ln! This spacious Lennar Terrazzo 2 is a 4brd 3.5bth has a downstairs study with a half bath. Upstairs has a game room or it can be used as a media room. Master bedroom is downstairs with a stand up shower, soak tube and a large walk-in closet. Home is laid out for those family get-togethers or entertaining friends.' ,`Acres` = '0.1531' ,`Area` = '30' ,`BuilderName` = 'Lennar' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'WALNUT CREEK SEC 16, BLOCK 2, LOT 40' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6671' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'THOMAS ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'RANDLE HIGH SCHOOL' ,`SchoolMiddle` = 'WRIGHT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Walnut Creek Sec 16' ,`TaxAmount` = '6986' ,`TaxRate` = '2.5848' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664310763' WHERE `Matrix_Unique_ID` = '211396699' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-27T07:48:55.143' ,`MLSNumber` = '95655475' ,`ListAgentFullName` = 'Sandra Gomez' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.138738' ,`Longitude` = '-94.885012' ,`PhotoCount` = '34' ,`PostalCode` = '77535' ,`RoomCount` = '5' ,`ListPrice` = '485999.00' ,`Status` = 'Active' ,`StreetName` = 'Road 660' ,`StreetNumber` = '928' ,`StreetSuffix` = '' ,`City` = 'Dayton' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2303' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful custom-built home in the up-and-coming community of Encino Estates. This Gorgeous open concept single story contemporary home is designed with high end finishes. Study room/ office can be turned into a 4th bedroom for Guests. A welcoming entry that opens to the formal dining, kitchen and living room. Spacious living area has a beautiful stylish fireplace. The Kitchen has beautiful cabinets and lots of storage for everything needed in a Chefs dream kitchen. The primary room has a huge walk-in closet, a cozy bathtub, a fabulous chandelier, and did I mention the HUGE walk-in closet? Its a MUST SEE. Large windows throughout the house provide lots of natural light that keeps the open and inviting feel. This home is ready for all the family gatherings and holidays, Schedule your appointment today to see this beautiful home waiting for you.' ,`Acres` = '0.74' ,`Area` = '52' ,`BuilderName` = 'KJIM' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Dayton' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ENCINO ESTATES, SEC 1, BLOCK 2, LOT 12, ACRES .74' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '32234' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '74 - Dayton' ,`SchoolElementary` = 'STEPHEN F. AUSTIN ELEMENTARY SCHOOL (DAYTON)' ,`SchoolHigh` = 'DAYTON HIGH SCHOOL' ,`SchoolMiddle` = 'WOODROW WILSON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Encino Estates, Sec 1' ,`TaxAmount` = '654' ,`TaxRate` = '1.7512' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664310764' WHERE `Matrix_Unique_ID` = '211405188' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-27T07:53:24.100' ,`MLSNumber` = '23536979' ,`ListAgentFullName` = 'Aramed Chavarria' ,`ListOfficeName` = 'Forbes International Real Est.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.783923' ,`Longitude` = '-95.955411' ,`PhotoCount` = '17' ,`PostalCode` = '77423' ,`RoomCount` = '5' ,`ListPrice` = '425000.00' ,`Status` = 'Active' ,`StreetName` = '6th' ,`StreetNumber` = '4211' ,`StreetSuffix` = 'Street' ,`City` = 'Brookshire' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3057' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful New Home: Spacious 5 bedroom with 3.5 bathroom home is perfect for a family. You will enjoy an open concept kitchen, dining and family room space. The kitchen features brand new stainless steel appliances and a large island with granite countertops.\r\nNote: Note: We are finishing constructions we will let know once we can set appointments.' ,`Acres` = '0.1703' ,`Area` = '26' ,`BuilderName` = 'MCC Home Builders' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Brookshire' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'S548000 KELLNER BLK 41 LOT E/3\' OF 3 & ALL OF 4' ,`LotDesciption` = 'Other' ,`LotSize` = '7418' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '0' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '44 - Royal' ,`SchoolElementary` = 'ROYAL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ROYAL HIGH SCHOOL' ,`SchoolMiddle` = 'ROYAL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Kellner' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664310764' WHERE `Matrix_Unique_ID` = '211410628' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-27T07:57:29.750' ,`MLSNumber` = '25238196' ,`ListAgentFullName` = 'Lori Barnett' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.120581' ,`Longitude` = '-95.308082' ,`PhotoCount` = '30' ,`PostalCode` = '77365' ,`RoomCount` = '8' ,`ListPrice` = '380000.00' ,`Status` = 'Active' ,`StreetName` = 'Kanawha Drive' ,`StreetNumber` = '19297' ,`StreetSuffix` = '' ,`City` = 'Porter' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2039' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WELCOME to this 4B/2B, 1-story home located on a beautiful 1-acre lot in the highly desirable Riverwalk Community! The home has an open concept living space and features high ceilings throughout, LED lights, and a wood-burning fireplace. It has a split floor plan. The primary suite is located in the back of the home with 2 large walk-in closets. There is a jetted tub and separate shower in the primary bathroom. The kitchen has stainless appliances, granite countertops, and lots of cabinets for storage! A room located right off the foyer can be used as a formal dining room, home office/study, or whatever your preference would be. New AC unit was installed approximately one year ago. A large storage building is located behind the home, tucked away just inside the tree line. There is plenty of room available in the huge back yard to add a pool and still have lots of space to entertain! The Riverwalk Community offers too many amenities to list. Schedule your showing today!' ,`Acres` = '1.02' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure,Special Addendum' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Porter/New Caney West' ,`HeatSystem` = 'Propane' ,`HOAMandatory` = '1' ,`Legal` = 'RIVERWALK 02, BLOCK 6, LOT 100' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '44431' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '361' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'SORTERS MILL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PORTER HIGH SCHOOL (NEW CANEY)' ,`SchoolMiddle` = 'WHITE OAK MIDDLE SCHOOL (NEW CANEY)' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,No Supra Keybox,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Riverwalk' ,`TaxAmount` = '5555' ,`TaxRate` = '2.1331' ,`WaterSewer` = 'Aerobic,Public Water,Septic Tank' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664310764' WHERE `Matrix_Unique_ID` = '211649941' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-27T07:10:00.863' ,`MLSNumber` = '82405567' ,`ListAgentFullName` = 'Kiesha Curtis' ,`ListOfficeName` = 'Realty Kings Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.928340' ,`Longitude` = '-95.243839' ,`PhotoCount` = '48' ,`PostalCode` = '77396' ,`RoomCount` = '8' ,`ListPrice` = '309900.00' ,`Status` = 'Active' ,`StreetName` = 'Deborah Colony' ,`StreetNumber` = '9706' ,`StreetSuffix` = 'Lane' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2025' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming 3-bedroom, 2-bathroom home located in the highly sought Fall Creek master-planned community. The inviting covered entry welcomes you into the foyer leading you onto the spacious living area with views to the kitchen, dining, and outdoor space. The kitchen is equipped with granite countertops, center island, ample counter and cabinet space, SS-appliances, and breakfast nook. Bedroom split floor plan with primary at the rear of the home featuring high ceilings, bay window, large walk-in closet and deluxe primary bath with dual sinks, soaking tub, and private water closet. 2 secondary bedrooms, a full bath with double sinks and a spacious study complete this wonderful floor plan. Additional features:, covered rear patio, full-size utility room and beautiful arched entries throughout. Community amenities include golf course, pools, tennis courts, fitness center, sports complex, trails and more. Located within minutes from the Airport, Downtown Houston, and local shops.' ,`Acres` = '0.1662' ,`Area` = '1' ,`BuilderName` = 'Ryland Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate,Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fall Creek Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 15 BLK 1 FALL CREEK SEC 42' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '7241' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1090' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'AUTUMN CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'WOODCREEK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Fall Creek' ,`TaxAmount` = '8085' ,`TaxRate` = '3.0673' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664310764' WHERE `Matrix_Unique_ID` = '211696847' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-27T06:42:38.420' ,`MLSNumber` = '90728598' ,`ListAgentFullName` = 'Jena Valley' ,`ListOfficeName` = 'Tramco Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.636886' ,`Longitude` = '-95.466972' ,`PhotoCount` = '17' ,`PostalCode` = '77085' ,`RoomCount` = '3' ,`ListPrice` = '275000.00' ,`Status` = 'Active' ,`StreetName` = 'Violet Path' ,`StreetNumber` = '5530' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1945' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Two story home in great location with large fenced in backyard! Hard floors throughout whole home! Open concept living/kitchen area. Fridge, microwave, and range all updated to stainless units. Utility room in house. Fridge, washer, and dryer included. Schedule your showing today!' ,`Acres` = '' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Five Corners' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 15 BLK 3 POST OAK PLACE SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '285' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HINES-CALDWELL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MADISON HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LAWSON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'POST OAK PLACE' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664310764' WHERE `Matrix_Unique_ID` = '211824413' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-27T06:33:07.667' ,`MLSNumber` = '51928121' ,`ListAgentFullName` = 'Jennifer Nesloney-Jonas' ,`ListOfficeName` = 'Keller Williams Metropolitan' ,`SellingAgentFullName` = 'Jessica Burton' ,`SellingOfficeName` = 'IndyQuest Properties' ,`Latitude` = '29.795803' ,`Longitude` = '-95.383719' ,`PhotoCount` = '16' ,`PostalCode` = '77009' ,`RoomCount` = '6' ,`ListPrice` = '660000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Gardner' ,`StreetNumber` = '921' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1572' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great Opportunity to own in the Heights, Owners have a job opportunity they cannot refuse! Charming updated 2 Bedroom/2 Full Bath home with open floor plan. which includes formal living & dining and bonus family room for enjoying time down time after work. Great kitchen for cooking/baking, granite countertops, SS appliances. Breakfast bar seating opens to the light-filled family room! Primary suite includes large walk-in closet & gorgeous bath with dual vanities, oversized shower, new cabinetry and water closet. Second full bath beautifully remodeled and includes, a claw foot tub & shower. Easy to maintain hardwood floors throughout. Lovely turfed backyard along with spacious deck. Finished air conditioned garage with automatic driveway gate. Home provides easy access to shopping, I-45, I-10, downtown, hiking/biking trails.' ,`Acres` = '0.1113' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TR 4 BLK 1 CASH' ,`LotDesciption` = 'Other' ,`LotSize` = '4850' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BROWNING ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cash' ,`TaxAmount` = '13103' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1930' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664310764' WHERE `Matrix_Unique_ID` = '211871678' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-27T07:20:56.633' ,`MLSNumber` = '82630448' ,`ListAgentFullName` = 'Omar Sanchez' ,`ListOfficeName` = 'SIS Group LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.989690' ,`Longitude` = '-95.179358' ,`PhotoCount` = '24' ,`PostalCode` = '77346' ,`RoomCount` = '3' ,`ListPrice` = '309900.00' ,`Status` = 'Active' ,`StreetName` = 'Huron Park' ,`StreetNumber` = '18514' ,`StreetSuffix` = 'Trail' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2215' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful Lennar home in Eagle Springs. High ceilings with open concept for entertaining, soaking tub with separate shower with his and her sinks with walk in closet. Enjoy cozy nights next to gas fireplace. Island in kitchen with breakfast bar. This home is within walking distance to neighborhood park also neighborhood gym & pool! Schedule your showing today!!' ,`Acres` = '0.174' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Atascocita South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 9 BLK 3 EAGLE SPRINGS SEC 12' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7580' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '825' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'EAGLE SPRINGS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ATASCOCITA HIGH SCHOOL' ,`SchoolMiddle` = 'TIMBERWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Eagle Spgs Sec 12' ,`TaxAmount` = '7184' ,`TaxRate` = '2.9726' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664310765' WHERE `Matrix_Unique_ID` = '211935498' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-27T07:52:58.500' ,`MLSNumber` = '26334646' ,`ListAgentFullName` = 'Beckie Martinez' ,`ListOfficeName` = 'Keller Williams RealtyNortheast' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.764521' ,`Longitude` = '-95.225895' ,`PhotoCount` = '20' ,`PostalCode` = '77029' ,`RoomCount` = '5' ,`ListPrice` = '189000.00' ,`Status` = 'Active' ,`StreetName` = 'Serpentine' ,`StreetNumber` = '1509' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1192' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '** UPDATE as of 8-2022 backyard has been completed** Fully remodeled adorable home in Jacinto Oaks with no back neighbors! Come see this beautiful 3 bedroom home that has been completely updated with new floors -both carpet and tile, all new sheetrock, modern kitchen sink and faucet along with new cabinets. New windows and duct work and much more! Long driveway and large front shaded lawn and a front porch for evening relaxation. Covered patio out back with extended concrete. Electrical and PVC plumbing has also been updated. Move in ready!' ,`Acres` = '0.1331' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 3 BLK 7 JACINTO OAKS SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5796' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '21 - Galena Park' ,`SchoolElementary` = 'PYBURN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GALENA PARK HIGH SCHOOL' ,`SchoolMiddle` = 'WOODLAND ACRES MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Jacinto Oaks Sec 02' ,`TaxAmount` = '2705' ,`TaxRate` = '2.993' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664310765' WHERE `Matrix_Unique_ID` = '211936592' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-27T06:06:36.313' ,`MLSNumber` = '11441650' ,`ListAgentFullName` = 'Sandy Brabham' ,`ListOfficeName` = 'Keller Williams RealtyNortheast' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.984061' ,`Longitude` = '-95.173246' ,`PhotoCount` = '44' ,`PostalCode` = '77346' ,`RoomCount` = '9' ,`ListPrice` = '414900.00' ,`Status` = 'Active' ,`StreetName` = 'Timber Edge' ,`StreetNumber` = '7002' ,`StreetSuffix` = 'Lane' ,`City` = 'Humble' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3256' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful Perry Home situated on an oversized cul-de-sac lot. Conveniently located just a few minutes away from IAH Airport and a short commute to Downtown Houston. Surrounded by shopping, dining and family entertainment. Home features stunning engineered wood floors, high ceilings and plenty of space for a large group. The kitchen has been updated with stainless appliances and gorgeous granite counter tops. Work from home in your private office. Enjoy a large primary bedroom with huge windows for natural light. Primary bathroom has double sinks, a vanity area, jetted tub, seamless glass shower and large walk in closet with built- ins. Good size formal dining room for family dinners or holiday parties. Upstairs you will find a game room and 3 additional bedrooms; one has it\'s own private bathroom; the other two share a Jack & Jill bathroom. The pool size backyard offers plenty of room for children and pets to play.' ,`Acres` = '0.3158' ,`Area` = '1' ,`BuilderName` = 'Perry Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Atascocita South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 23 BLK 4 ATASCA WOODS SEC 4 AMEND' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '13755' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '550' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'TIMBERS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ATASCOCITA HIGH SCHOOL' ,`SchoolMiddle` = 'ATASCOCITA MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Atasca Woods' ,`TaxAmount` = '7408' ,`TaxRate` = '2.3974' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664310765' WHERE `Matrix_Unique_ID` = '212139054' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-27T07:43:26.020' ,`MLSNumber` = '11853920' ,`ListAgentFullName` = 'Rickey Chavez' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = 'Lisa Burns' ,`SellingOfficeName` = 'RE/MAX Universal' ,`Latitude` = '30.017332' ,`Longitude` = '-95.764018' ,`PhotoCount` = '37' ,`PostalCode` = '77433' ,`RoomCount` = '7' ,`ListPrice` = '320000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Empire Gold' ,`StreetNumber` = '16711' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '2061' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This great home is located in a gated section on an over-sized lot in Fairfield. Walk to the lake and walking trails from the house. Lots of upgrades! 3 bedroom (or 2 bedroom and an office) and 2 full baths. Kitchen features granite counters, undermount sink, stainless appliances, tumbled marble backsplash, and custom cabinets. Nest digital programmable thermostat. Upgraded tile in all living and wet areas. Wood like floors in bedrooms/office. Energy Star home saves on utility costs. Close to great shopping, dining, and award-winning Cy-Fair ISD schools. Easy access to Hwy. 290 and the Grand Parkway. Make an appointment to see this well-cared for home!' ,`Acres` = '0.1671' ,`Area` = '35' ,`BuilderName` = 'Village Builder' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 13 BLK 2 FAIRFIELD VILLAGE NORTH SEC 13' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7278' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '925' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'SWENKE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRIDGELAND HIGH SCHOOL' ,`SchoolMiddle` = 'SALYARDS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Fairfield Village North Sec 13' ,`TaxAmount` = '6878' ,`TaxRate` = '2.611' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2009' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664310765' WHERE `Matrix_Unique_ID` = '212323273' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-27T07:33:21.697' ,`MLSNumber` = '19416778' ,`ListAgentFullName` = 'Julie Brann' ,`ListOfficeName` = 'Bernstein Realty, Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.788415' ,`Longitude` = '-95.486752' ,`PhotoCount` = '36' ,`PostalCode` = '77055' ,`RoomCount` = '8' ,`ListPrice` = '955000.00' ,`Status` = 'Active' ,`StreetName` = 'Glourie' ,`StreetNumber` = '1118' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2268' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Immaculately maintained ranch style home with abundant upgrades on expansive 15,800sf lot in sought after Hillshire Village. Upgrades* include: High quality Timberline roof (2014); HVAC, including ducts (2018); water heater (2021). Kitchen remodeled with granite counters, stone backsplash, upgraded cabinetry & high-end stainless appliances. Primary bath remodeled 2018 boasting upgraded cabinetry, quartz counters & oversize walk-in shower with beautiful tile surround & frameless door. Spacious primary bedroom features two walk-in closets & updated bath! Two sizeable secondary bedrooms with large closets, plus spacious secondary bath with dual sinks, separate vanity area & neutral tile. Large utility/mud room & private powder room for guests. Huge fenced backyard with covered back patio & lush landscaping on one of the best streets in Spring Valley! Stainless refrigerator, washer & dryer included! Zoned to award-winning Valley Oaks Elem., Spring Branch MS & Memorial HS. *per Seller.' ,`Acres` = '0.3627' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Memorial Villages' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 6 BLK 5 BURKHARDT PLAZA' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '15800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'VALLEY OAKS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'SPRING BRANCH MIDDLE SCHOOL (SPRING BRANCH)' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Burkhardt Plaza' ,`TaxAmount` = '18191' ,`TaxRate` = '2.4805' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664310765' WHERE `Matrix_Unique_ID` = '212343533' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-27T07:38:29.090' ,`MLSNumber` = '14218267' ,`ListAgentFullName` = 'Jerelynn Smith Foy' ,`ListOfficeName` = 'Sky Real Estate Professionals' ,`SellingAgentFullName` = 'Janice Kopfler' ,`SellingOfficeName` = 'Coldwell Banker RealtyREALTORS' ,`Latitude` = '30.078472' ,`Longitude` = '-95.503242' ,`PhotoCount` = '24' ,`PostalCode` = '77388' ,`RoomCount` = '6' ,`ListPrice` = '263500.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Mandarin Glen' ,`StreetNumber` = '21114' ,`StreetSuffix` = 'Circle' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1558' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New Price!! Great house in a convenient and great location. This cozy 1 story home features 3 bedrooms with 2 full baths. Large spacious family room with updated vinyl flooring. Granite countertops large pantry and lots of cabinets in the kitchen. Large primary bedroom with walk in closet. Primary bath features double sinks, separate shower and a garden tub. House sits on a premium lot close to shopping, dining and less than 10 miles from the Woodlands. Home never flooded, high and dry through Harvey and Tax day! Make your appointment today.' ,`Acres` = '0.1717' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring/Klein' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 7 BLK 1 GOSLING PINES SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7479' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '375' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'FOX ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN COLLINS HIGH SCHOOL' ,`SchoolMiddle` = 'SCHINDEWOLF INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Gosling Pines Sec 02' ,`TaxAmount` = '5076' ,`TaxRate` = '2.644' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2010' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664310765' WHERE `Matrix_Unique_ID` = '212404218' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-27T07:12:22.883' ,`MLSNumber` = '84999004' ,`ListAgentFullName` = 'Gaelin Nichols' ,`ListOfficeName` = 'Heritage Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.194916' ,`Longitude` = '-95.217513' ,`PhotoCount` = '17' ,`PostalCode` = '77357' ,`RoomCount` = '6' ,`ListPrice` = '235000.00' ,`Status` = 'Active' ,`StreetName` = 'Juniper Crossing' ,`StreetNumber` = '21948' ,`StreetSuffix` = '' ,`City` = 'New Caney' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1335' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Less than a year old, this Lennar San Marcos plan offers 4 bedrooms, a spacious family room, in-house utility room, and is set apart from all the others by the 17x10 covered patio and huge yard with no back neighbors. If privacy and outdoor space is what you are looking for don\'t miss out on this beauty. The refrigerator, washer, and dry will be included with the sale.' ,`Acres` = '' ,`Area` = '40' ,`BuilderName` = 'Lennar' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Porter/New Caney West' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 41, Block 6 Pinewood at Grand Texas' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '47 - Splendora' ,`SchoolElementary` = 'TIMBER LAKES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPLENDORA HIGH SCHOOL' ,`SchoolMiddle` = 'SPLENDORA JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Pinewood at Grand Texas' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664310766' WHERE `Matrix_Unique_ID` = '212416549' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-27T07:38:00.620' ,`MLSNumber` = '69303268' ,`ListAgentFullName` = 'Jody Roche' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.058068' ,`Longitude` = '-95.560322' ,`PhotoCount` = '50' ,`PostalCode` = '77379' ,`RoomCount` = '10' ,`ListPrice` = '450000.00' ,`Status` = 'Active' ,`StreetName` = 'Night Beacon Point' ,`StreetNumber` = '9222' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3224' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning 4 Bedroom, 3.5 bath home backing to a Greenbelt in Gleannloch Farms. This recently updated home has it all! Large Primary bedroom with bay window sitting area, updated Primary bath with walk in shower, soaking tub, dual sinks and built-in linen/display cabinet. Updated kitchen with stainless appliances, custom cabinets and walk-in pantry and open to living and dining. Large home office with French doors for privacy. 3 spacious secondary bedrooms upstairs with ceiling fans and walk-in closets. Two additional full baths up and both have recently been updated. Large game room for toys & games. Media/Bonus room upstairs is wired for sound. Laundry room features a built-in cabinet and storage unit that serves as Mud room and broom closet. There is a lovely front porch and a large covered patio to relax and unwind. Dual Zoned HVAC system installed 2019; water heater replaced 2022; Dishwasher and Microwave replaced 2020; refrigerator included. Quick access to walking path. Klein ISD' ,`Acres` = '0.1616' ,`Area` = '14' ,`BuilderName` = 'Ryland' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein/Tomball' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 40 BLK 1 GLEANNLOCH FARMS SEC 30' ,`LotDesciption` = 'Greenbelt,In Golf Course Community,Subdivision Lot' ,`LotSize` = '7040' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'FRANK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN CAIN HIGH SCHOOL' ,`SchoolMiddle` = 'DOERRE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Gleannloch Farms' ,`TaxAmount` = '7451' ,`TaxRate` = '2.7315' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664310766' WHERE `Matrix_Unique_ID` = '212420764' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-27T06:20:05.727' ,`MLSNumber` = '61520966' ,`ListAgentFullName` = 'Karen Crawn' ,`ListOfficeName` = 'Stanfield Properties' ,`SellingAgentFullName` = 'Blake Bachtel' ,`SellingOfficeName` = 'Eaton Realty' ,`Latitude` = '29.507123' ,`Longitude` = '-95.004941' ,`PhotoCount` = '18' ,`PostalCode` = '77573' ,`RoomCount` = '10' ,`ListPrice` = '399000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Arbor Crest' ,`StreetNumber` = '4920' ,`StreetSuffix` = 'Lane' ,`City` = 'League City' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2204' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Inviting & nearly new 4 bedroom single story home in League City’s Coastal Point community boasts an easy commute to multiple locations via 146! Step into this light & airy 2020 Empire Homes design to find soothing grey paint tones, high ceilings, & luxury vinyl plank flooring throughout the open floor plan with a combined family room, dining room, & oversized island kitchen with beautiful quartz counters, a designer tile backsplash, a farmhouse sink, slate stainless appliances including a gas cooktop, & a generous pantry. The split floorplan boasts a flex use 4th bedroom or home office just off of the foyer, as well as a spacious & secluded owners retreat with his & hers sinks, a soaker tub, seamless glass shower, & a large walk-in closet. Outdoors, enjoy the covered patio overlooking the private backyard or utilize the master-planned amenities that include a resort-style pool & clubhouse, ponds, parks, & walking trails. Don\'t miss this opportunity to own this better-than-new home!' ,`Acres` = '0.1487' ,`Area` = '33' ,`BuilderName` = 'Empire Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 5 BLK 2 COASTAL POINT SEC 3 (2020) ABST 153' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '6477' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '925' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'SANDRA MOSSMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'BAYSIDE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Coastal Point Sec 3' ,`TaxAmount` = '8370' ,`TaxRate` = '2.8997' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664310766' WHERE `Matrix_Unique_ID` = '212455921' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-27T07:59:11.960' ,`MLSNumber` = '36252697' ,`ListAgentFullName` = 'Cuong Le' ,`ListOfficeName` = 'Fathom Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.000402' ,`Longitude` = '-95.488046' ,`PhotoCount` = '44' ,`PostalCode` = '77068' ,`RoomCount` = '8' ,`ListPrice` = '324000.00' ,`Status` = 'Active' ,`StreetName` = 'Walters' ,`StreetNumber` = '14930' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2784' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Start living the lifestyle you deserve today in this gorgeous renovated home with a rare converted garage suite with a full kitchen huge walk in closet! Feel the recent beautiful luxury vinyl upstairs under your feet with new wood style plank tiles throughout first floor. New roof and foundation repair with transferrable lifetime warranty. Whole home repiped with PEX plumbing, stainless steel appliances, quartz counter tops and hand selected interior paint color and more! Spacious fully fenced backyard with wood decks next to your well maintained private pool. Check out the lifestyle map to see the nearby parks, highly Yelp rated eateries and hot spots nearby. See it today!' ,`Acres` = '0.2121' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '1960/Cypress Creek North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 8 BLK 6 OLDE OAKS SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9240' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '445' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'PAT REYNOLDS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTFIELD HIGH SCHOOL' ,`SchoolMiddle` = 'EDWIN M WELLS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Left Side,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Olde Oaks' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664310766' WHERE `Matrix_Unique_ID` = '212470164' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-27T06:17:07.217' ,`MLSNumber` = '61306273' ,`ListAgentFullName` = 'Patrick Rollins' ,`ListOfficeName` = 'City Cottage Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.835324' ,`Longitude` = '-95.432454' ,`PhotoCount` = '50' ,`PostalCode` = '77018' ,`RoomCount` = '10' ,`ListPrice` = '1299000.00' ,`Status` = 'Active' ,`StreetName` = 'Richelieu' ,`StreetNumber` = '1255' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3365' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New construction zoned to Oak Forest Elementary! Open living space, hardwoods throughout, gorgeous trim, oversized garage and more!' ,`Acres` = '0.167' ,`Area` = '9' ,`BuilderName` = 'City Cottage' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Oak Forest East Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 16 BLK 33 OAK FOREST SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7274' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'OAK FOREST ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'BLACK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Oak Forest Sec 03' ,`TaxAmount` = '8335' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664310766' WHERE `Matrix_Unique_ID` = '212498463' --> 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','212579118','1664310767','212579118','2022-09-27T07:03:05.640','10033540','Swee Koh','Tasek Realty','','','29.645411','-95.511288','41','77071','11','329500.00','Active','Candlegreen','7627','Lane','Houston','3','0','5','2890','Single-Family','Total remodeled house with new hardie plank sidings, new fence, new paint both inside and outside, new granite countertops in Kitchen and all bathrooms, new faucets and light fixtures, new wood floor and new carpet, new AC coil and new concrete on the driveway. The roof was installed in 2017 summer. Almost all major remodeled has been taken care of. \r\nSpacious house with high ceilings! The home has both formal living, dining, and a large Den with a fireplace open to the kitchen. 3 bedrooms and 2 baths downstairs and 2 bedrooms and a full bath upstairs with a game room. Nice size backyard with trees, perfect for a party or retreat. Mature pecan tree in the front yard. Convenience location, close to the major highways--Hwy59, beltway 8, and Hwy 90. Make this one your home sweet home!','','20','','','','','Sellers Disclosure','1','Freestanding','1','Brays Oaks','Central Electric','1','LT 16 BLK 5 FONDREN SW SOUTHMEADOW SEC 2','Corner','7475','Appraisal District','','364','0','','2','Convection Oven','0','','','Electric Range','','Composition','27 - Houston','MILNE ELEMENTARY SCHOOL','WESTBURY HIGH SCHOOL','WELCH MIDDLE SCHOOL','Appointment Required,Supra Keybox','Appraisal District','2','Traditional','Fondren Sw Southmeadow Sec 0','','','Public Sewer,Public Water','1977','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-27T06:49:34.717' ,`MLSNumber` = '2885450' ,`ListAgentFullName` = 'Hector Alpuing' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.029765' ,`Longitude` = '-95.534238' ,`PhotoCount` = '44' ,`PostalCode` = '77379' ,`RoomCount` = '9' ,`ListPrice` = '349900.00' ,`Status` = 'Active' ,`StreetName` = 'Ralick' ,`StreetNumber` = '7502' ,`StreetSuffix` = 'Court' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2704' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful home on huge half acre corner lot in established Memorial Northwest Subdivision. Home boasts 4 bedrooms, 2.5 baths, 2 car garage and both formal dining and living rooms. Upgrades include new roof, A/C, granite counter tops, stainless steel appliances, travertine tile backsplash, crown molding, and recently tiled 2nd floor balcony to name a few. Zoned to highly desired Klein ISD and has a neighborhood community center, fitness room, tennis courts, splash pad & pool. Never Flooded. Make your appointment today!' ,`Acres` = '0.5234' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 3 BLK 1 017*M1876900-001-001-003 MEMORIAL NORTHWEST SEC 1' ,`LotDesciption` = 'Corner' ,`LotSize` = '22800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '693' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'THEISS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN HIGH SCHOOL' ,`SchoolMiddle` = 'DOERRE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Memorial Northwest Sec 01' ,`TaxAmount` = '5117' ,`TaxRate` = '2.3213' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1971' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664310767' WHERE `Matrix_Unique_ID` = '212623482' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-27T06:37:32.990' ,`MLSNumber` = '33013114' ,`ListAgentFullName` = 'Courtney Peters' ,`ListOfficeName` = 'Courtney Lane Properties, LLC' ,`SellingAgentFullName` = 'Jennifer Trevino' ,`SellingOfficeName` = 'RE/MAX Signature' ,`Latitude` = '29.824968' ,`Longitude` = '-95.749789' ,`PhotoCount` = '34' ,`PostalCode` = '77449' ,`RoomCount` = '10' ,`ListPrice` = '299900.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Lantern Bay' ,`StreetNumber` = '3414' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2129' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this stunning Lakes of Bridgewater home! You won\'t want to miss this amazing opportunity to get into this newly renovated cul-de-sac home. Spacious open floor plan with high ceilings. Towering windows throughout provide ample natural light. Roomy primary suite has spacious closet, free standing tub with separate shower, and double sinks. Two secondary bedrooms and large game room upstairs. Enormous backyard features lovely covered patio, \"the beach\", and backs up to amazing green space and trails. Come see it today and make this your home!' ,`Acres` = '0.1775' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 29 BLK 1 LAKES OF BRIDGEWATER SEC 5 AMD' ,`LotDesciption` = 'Cul-De-Sac,Other,Subdivision Lot' ,`LotSize` = '7734' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'GOLBOW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MORTON RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'MCDONALD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakes Bridgewater Sec 05 Amd' ,`TaxAmount` = '5467' ,`TaxRate` = '2.8233' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664310767' WHERE `Matrix_Unique_ID` = '212657725' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-27T07:34:43.830' ,`MLSNumber` = '64827733' ,`ListAgentFullName` = 'Eduardo Polack' ,`ListOfficeName` = 'Elite Texas Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.975222' ,`Longitude` = '-95.402738' ,`PhotoCount` = '13' ,`PostalCode` = '77073' ,`RoomCount` = '8' ,`ListPrice` = '233000.00' ,`Status` = 'Active' ,`StreetName` = 'Crosshill' ,`StreetNumber` = '19307' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1582' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful Single Family Cottage Home built by KB Home 5 years ago. Downstairs Features: Foyer, Kitchen with Nice Cabinets, Fridge included and Pantry, Breakfast Area, Living Room, Guest Bathroom, Closet area, 2 Car Garage with Garage Door Opener and additional storage area (Attached), Fenced Patio. Upstairs Features : Principal Bedroom with excellent Walking Closet Space, Principal Bathroom with counter Space and Extra closet, Other two Bedrooms with closets share the Second Bathroom (not Connected) , Game Room area and Utility Room with Full Size Washer and Dryer set included, Cold A/C System with Digital Thermostat and Extra Ceiling Fans in all Bedrooms and Living Room. Storage area in attic Space too.' ,`Acres` = '0.0603' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Owner/Agent' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Aldine Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 34 BLK 2 REMINGTON RANCH SEC 27' ,`LotDesciption` = 'Cleared' ,`LotSize` = '2628' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'HOYLAND ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ANDY DEKANEY H S' ,`SchoolMiddle` = 'DUEITT MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Remington Ranch Sec 27' ,`TaxAmount` = '4691' ,`TaxRate` = '2.8804' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664310767' WHERE `Matrix_Unique_ID` = '212714918' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-27T07:53:52.163' ,`MLSNumber` = '31014852' ,`ListAgentFullName` = 'Jackie Murray' ,`ListOfficeName` = 'Weichert,REALTORS-Murray Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.664176' ,`Longitude` = '-95.494430' ,`PhotoCount` = '38' ,`PostalCode` = '77096' ,`RoomCount` = '8' ,`ListPrice` = '249500.00' ,`Status` = 'Active' ,`StreetName` = 'Carlota' ,`StreetNumber` = '10702' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1662' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEVER FLOODED! Charming home on a corner lot. Well thought out floorplan ready for your personal touches. Entry welcomes you with versatile formal living or dining room. Formal would also make a great home office. Kitchen with ample counter and cabinet space with eat-in breakfast room. Breakfast room with large window and great views of back yard. Den features high vaulted ceiling with charming brick fireplace. Spacious primary retreat. Primary bathroom with shower. Generous size secondary bedrooms. Hall bathroom features tub/shower combination. Entertainer\'s dream back yard with patio and pergola. Two car attached garage. Updates include double pane windows, sprinkler system and foundation repaired with life time warranty! Estate...Being sold AS IS.' ,`Acres` = '0.212' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Brays Oaks' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'N 72.23 FT OF LT 7 BLK 151 WESTBURY SEC 5 R/P' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '9233' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ELROD ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WESTBURY HIGH SCHOOL' ,`SchoolMiddle` = 'FONDREN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Westbury Sec 05' ,`TaxAmount` = '5720' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1962' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664310767' WHERE `Matrix_Unique_ID` = '212731670' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-27T07:44:51.710' ,`MLSNumber` = '73081981' ,`ListAgentFullName` = 'Francois Jones' ,`ListOfficeName` = 'Masters Realty' ,`SellingAgentFullName` = 'Vicki Fullerton' ,`SellingOfficeName` = 'RE/MAX The Woodlands & Spring' ,`Latitude` = '30.142438' ,`Longitude` = '-95.410097' ,`PhotoCount` = '37' ,`PostalCode` = '77386' ,`RoomCount` = '7' ,`ListPrice` = '348500.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Copperwood Park' ,`StreetNumber` = '2043' ,`StreetSuffix` = 'Lane' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2653' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'IT WONT LAST!!! Incredible Remodeled Kitchen: Granite Counters + Stainless Appliances! 42\" Cabinetry with Under Cabinet Lighting + Recessed Lighting! Private First Floor Primary Suite with Tray Ceiling! Lovely Whirlpool Garden Bath with Dual Sinks and a Big Walk-In Closet! Large Secondary Bedrooms. Large Gameroom/Media Room with Great 16 x 4 Walk-In Storage Closet! Windows, roof and 1st floor HVAC replaced in the last several years! Quite Backyard Setting with No Neighbors Behind and access to greenbelt. Master-Planned Community with Easy Access to I-45, GP 99, & The Woodlands Amenities! WON\'T LAST - HURRY!' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'IMPERIAL OAKS PARK 01, BLOCK 1, LOT 37' ,`LotDesciption` = 'Greenbelt' ,`LotSize` = '8164' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'KAUFMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'OAK RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'IRONS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Imperial Oaks' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664310767' WHERE `Matrix_Unique_ID` = '212762465' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-27T06:42:13.163' ,`MLSNumber` = '77314241' ,`ListAgentFullName` = 'Dan McCarver' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.524083' ,`Longitude` = '-95.000768' ,`PhotoCount` = '50' ,`PostalCode` = '77518' ,`RoomCount` = '13' ,`ListPrice` = '3499000.00' ,`Status` = 'Active' ,`StreetName` = 'Bayshore' ,`StreetNumber` = '2611' ,`StreetSuffix` = 'Drive' ,`City` = 'Bacliff' ,`BathsFull` = '4' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '6222' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Captivating Bayfront home offers panoramic views of Galveston Bay from multiple balconies and fabulous covered living area and salt water pool and spa. The domed foyer and grand staircase welcome you to this remarkable home that was designed for entertaining on a large scale. A central Great Room is open to the chef\'s island kitchen, dining and breakfast areas. Game room complete with bar and wine cellar. Primary suite is a must see with its\' private balcony, spectacular bath, extensive his and hers closets and home gym. There are three additional guest suites w en suite baths and large closets. Third floor study. The outdoor living area is 24 x 74 complete with fireplace, DCS grill and rotisserie, 2 dishwashers, pool bath, large dining space and TVs. Elevator. 22 KW Generator. Workshop. Built by Harbour Classics. Control 4 audio, Pool, AC, Security controlled by app.' ,`Acres` = '0.344' ,`Area` = '33' ,`BuilderName` = 'Harbour Classics' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Bacliff/San Leon' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 32 R BASQUEZ SUR LOTS 11 & 12 BLK 34 BAYVIEW SUB' ,`LotDesciption` = 'Waterfront' ,`LotSize` = '14985' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '5' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Heated,In Ground,Salt Water' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'STEWART ELEMENTARY SCHOOL (CLEAR CREEK)' ,`SchoolHigh` = 'CLEAR FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'BAYSIDE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Seller' ,`Stories` = '3' ,`Style` = 'Traditional' ,`Subdivision` = 'Bayview Add' ,`TaxAmount` = '16898' ,`TaxRate` = '1.9548' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664310767' WHERE `Matrix_Unique_ID` = '212783193' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-27T06:13:07.930' ,`MLSNumber` = '12178785' ,`ListAgentFullName` = 'Susan Vaughan' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.657929' ,`Longitude` = '-95.138761' ,`PhotoCount` = '38' ,`PostalCode` = '77331' ,`RoomCount` = '3' ,`ListPrice` = '309000.00' ,`Status` = 'Active' ,`StreetName` = 'Fairway' ,`StreetNumber` = '351' ,`StreetSuffix` = 'Loop' ,`City` = 'Coldspring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1300' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Nestled in a natural setting on two lots, this charming architect-designed home is aesthetically pleasing and maximizes space. The exposed wood- beamed ceiling lends a spacious feel in the craftsman style open concept. The primary loft suite has a vaulted ceiling. Appreciate the outdoors from the covered porch on the front and back which overlooks a ravine, a perfect spot to observe wildlife. The second lot provides ample room for a garage. Located in Cape Royale, the premier waterfront community on Lake Livingston, recreational activities are endless.\r\nFurnishings are negotiable.' ,`Acres` = '0.533' ,`Area` = '64' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'CAPE ROYALE - ROYALE GREENS, BLOCK 5, LOT 31 & 32, ACRES .53' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '23217' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '101 - Coldspring-Oakhurst Consolidated' ,`SchoolElementary` = 'JAMES STREET ELEMENTARY SCHOOL' ,`SchoolHigh` = 'COLDSPRING-OAKHURST HIGH SCHOOL' ,`SchoolMiddle` = 'LINCOLN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Cape Royale' ,`TaxAmount` = '3289' ,`TaxRate` = '2.0554' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664310768' WHERE `Matrix_Unique_ID` = '212812646' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-27T06:03:24.950' ,`MLSNumber` = '37600023' ,`ListAgentFullName` = 'Kathleen Karing' ,`ListOfficeName` = 'UTR TEXAS, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.386958' ,`Longitude` = '-95.332673' ,`PhotoCount` = '35' ,`PostalCode` = '77511' ,`RoomCount` = '3' ,`ListPrice` = '370000.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 392' ,`StreetNumber` = '6435' ,`StreetSuffix` = '' ,`City` = 'Alvin' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1120' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'HIDDEN AWAY ON THE FRINGE OF THE BIG CITY IS A CHARMING 1-STORY HOME ON 7.25 ACRES OF PRISTINE LAND. FULLY FENCED PROPERTY BOASTS AN EXPANSIVE BARN (42 x 35) WITH 5 HORSE STALLS & A TACK ROOM TO STORE & ORGANIZE ALL OF YOUR EQUESTRIAN GEAR. A LARGE WORKSHOP SHED IS ON THE PROPERTY, AS WELL. THE HOME FEATURES AN INVITING FRONT PORCH, WOOD FLOORING INTERIOR, RUSTIC WOOD PANELING, CUSTOM CABINETRY, DOUBLE OVENS, GAS RANGE, BLACK STAINLESS LG KITCHEN APPLIANCES. OPEN CONCEPT W/ A LARGE FAMILY ROOM & KITCHEN / DINING COMBO. THE OWNERS\' RETREAT IS A RELAXING SPACE FEATURING AN UPDATED EN-SUITE BATH W/ A HUGE SOAKING TUB. 2 SECONDARY BEDROOMS & ANOTHER FULL BATH ARE ON THE OPPOSITE SIDE OF THE HOME. NUMEROUS WINDOWS PROVIDE NATURAL LIGHT THROUGHOUT. PER SELLER, RECENT ROOF (2018), GAS WATER HEATER (2016), RECENT A/C, LIGHTING, DOORS & WINDOWS. THERE IS A SPACIOUS BACK DECK TO ENJOY ALL THE BEAUTY OF THIS TRANQUIL PROPERTY. CROSS FENCED FOR GRAZING LIVESTOCK. BRING YOUR HORSES!' ,`Acres` = '7.25' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'A0454 A C H & B TRACT 1B ACRES 7.25 MH DESIGNATED AS REAL PR' ,`LotDesciption` = 'Cleared' ,`LotSize` = '315810' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'NELSON ELEMENTARY SCHOOL (ALVIN)' ,`SchoolHigh` = 'ALVIN HIGH SCHOOL' ,`SchoolMiddle` = 'FAIRVIEW JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'A C H & B' ,`TaxAmount` = '6341' ,`TaxRate` = '2.2174' ,`WaterSewer` = 'Aerobic,Septic Tank' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664310768' WHERE `Matrix_Unique_ID` = '212817254' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-27T06:59:48.570' ,`MLSNumber` = '72346999' ,`ListAgentFullName` = 'Ferdinand Esquivel' ,`ListOfficeName` = 'JPAR - The Sears Group' ,`SellingAgentFullName` = 'Nadia Deanda' ,`SellingOfficeName` = 'Texas Prominent Realty, Inc.' ,`Latitude` = '29.939925' ,`Longitude` = '-95.453445' ,`PhotoCount` = '31' ,`PostalCode` = '77067' ,`RoomCount` = '10' ,`ListPrice` = '239900.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Day Lily way' ,`StreetNumber` = '1918' ,`StreetSuffix` = 'Way' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1864' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**TURN KEY HOME** READY TO MOVE IN**WONT LAST LONG** Located minutes from Sam Houston PKWY and close to the northwest freeway making it very convenient for easy commute. When you enter the home you will be greeted with Designer selected fixtures and designer upgraded finishes , Brand new stainless steel Dishwasher Microwave and Range , New Carpet and Pad thru out the upstairs bedrooms. New Designer selected interior and exterior paint. New quartz counter tops and New backsplash tile in the kitchen , Professionally refinished cabinets , Upgraded cabinet hardware , New bathroom floor tile, New vanity lighting, New faucets, New sink, New disposal. Brand new stainless steel ceiling fans thru out the house . \r\n\r\n\r\n\r\nProfessionally refinished cabinets' ,`Acres` = '0.1034' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '1960/Cypress Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 11 BLK 3 LINCOLN GREEN PLACE SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4506' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '205' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'STEHLIK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DAVIS HIGH SCHOOL (ALDINE)' ,`SchoolMiddle` = 'PLUMMER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lincoln Green Place Sec 02' ,`TaxAmount` = '4155' ,`TaxRate` = '2.8128' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664310768' WHERE `Matrix_Unique_ID` = '212823333' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-27T07:09:27.137' ,`MLSNumber` = '10371426' ,`ListAgentFullName` = 'Heather Niemeyer' ,`ListOfficeName` = 'Camelot Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.799536' ,`Longitude` = '-95.414308' ,`PhotoCount` = '28' ,`PostalCode` = '77008' ,`RoomCount` = '6' ,`ListPrice` = '619000.00' ,`Status` = 'Active' ,`StreetName` = 'W 16th Street' ,`StreetNumber` = '907A' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2988' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great opportunity to own in the coveted Shady Acres area, just east of the historic Houston Heights. Residents may enjoy the White Oak Bayou Hike & Bike Trail, M-K-T shopping & dining center, and the renowned Memorial Park & Golf Course which has been added to the PGA Tours annual schedule! Quick access to I10 & 610! With ample street parking & NO HOA, this distinctly impressive custom spec home by Old Oaks Builders is located on a quiet cul-de-sac street. Upon arrival, you will notice 5 free-standing homes with Hardie plank siding & decorative exterior lighting & constructed with steel beams! The first level has one bedroom & bathroom. The second level features an open-to-living gourmet style kitchen with 2\" thick quartz counters, a Jennair gas cooktop, double ovens, top can be used as 2nd microwave, & folding style doors off the living room. Supreme privacy with only the primary room & ensuite bath on the 3rd level. FIRE SAFETY SYSTEM INSTALLED & ELEVATORS ARE INCLUDED IN THE PRICE!' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = 'Old Oaks Builder' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Electric,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'LT 3 BLK 1 SHADY ACRES EXTN SEC 3 10TH PAR R/P' ,`LotDesciption` = 'Other' ,`LotSize` = '1749' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LOVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '4' ,`Style` = 'Contemporary/Modern,Other Style,Traditional' ,`Subdivision` = 'Shady Acres' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664310768' WHERE `Matrix_Unique_ID` = '212842028' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-27T07:56:27.040' ,`MLSNumber` = '92910497' ,`ListAgentFullName` = 'Douglas Rodriguez' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.004209' ,`Longitude` = '-95.438557' ,`PhotoCount` = '38' ,`PostalCode` = '77090' ,`RoomCount` = '10' ,`ListPrice` = '239900.00' ,`Status` = 'Active' ,`StreetName` = 'Deer Lick' ,`StreetNumber` = '16339' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1498' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.1591' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Probate' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '1960/Cypress Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 60 BLK 19 NORTH FOREST SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6930' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'MEYER ELEMENTARY SCHOOL (SPRING)' ,`SchoolHigh` = 'WESTFIELD HIGH SCHOOL' ,`SchoolMiddle` = 'BAMMEL MIDDLE SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'North Forest Sec 03' ,`TaxAmount` = '5767' ,`TaxRate` = '2.6492' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1973' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664310768' WHERE `Matrix_Unique_ID` = '212844696' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-27T07:07:03.087' ,`MLSNumber` = '42742235' ,`ListAgentFullName` = 'Juan Marin' ,`ListOfficeName` = 'Executive Texas Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.853605' ,`Longitude` = '-95.200415' ,`PhotoCount` = '30' ,`PostalCode` = '77044' ,`RoomCount` = '6' ,`ListPrice` = '319900.00' ,`Status` = 'Active' ,`StreetName` = 'Hunters Field' ,`StreetNumber` = '12911' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2413' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully updated three bedroom, two and a half bathroom house with office on the main floor! High ceilings throughout the entire first floor. Spacious kitchen has been updated with new Calacatta quartz countertops, new paint, and new stainless appliances. Primary bedroom is oversized with an updated, luxurious primary bathroom. All new carpet and paint throughout the house. NEW HVAC, NEW ROOF, and energy efficient Nest thermostats in both up and downstairs. Come see this gorgeous home. It wont last long!' ,`Acres` = '0.1798' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 5 BLK 2 STONEFIELD TERRACE SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7833' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '480' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '46 - Sheldon' ,`SchoolElementary` = 'MONAHAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CE KING HIGH SCHOOL' ,`SchoolMiddle` = 'C.E. KING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Stonefield Terrace Sec 01' ,`TaxAmount` = '6593' ,`TaxRate` = '2.9993' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664310769' WHERE `Matrix_Unique_ID` = '212847503' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-27T07:47:38.330' ,`MLSNumber` = '2248846' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'Highland Homes Realty' ,`SellingAgentFullName` = ' Non-MLS Agent' ,`SellingOfficeName` = 'Non-MLS ' ,`Latitude` = '30.293981' ,`Longitude` = '-95.564761' ,`PhotoCount` = '21' ,`PostalCode` = '77316' ,`RoomCount` = '4' ,`ListPrice` = '564571.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Sky Top' ,`StreetNumber` = '230' ,`StreetSuffix` = '' ,`City` = 'Montgomery' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2046' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 2248846 - Built by Highland Homes - November completion! ~ The Amberley plan features expanded bedrooms 2 and 3, built in appliances, painted kitchen cabinets, 8\' solid core doors throughout, bay window in primary bedroom.' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '24/1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6000' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1150' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'STEWART ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodforest 40\' and 50\'' ,`TaxAmount` = '' ,`TaxRate` = '2.9' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664310769' WHERE `Matrix_Unique_ID` = '212926648' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-27T07:10:28.367' ,`MLSNumber` = '5877707' ,`ListAgentFullName` = 'Jessica Dorough' ,`ListOfficeName` = 'Pam Westlake Realty Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.467427' ,`Longitude` = '-95.667355' ,`PhotoCount` = '36' ,`PostalCode` = '77356' ,`RoomCount` = '9' ,`ListPrice` = '419000.00' ,`Status` = 'Active' ,`StreetName` = 'Shore' ,`StreetNumber` = '19916' ,`StreetSuffix` = 'Drive' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1850' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'CALLING ALL INVESTORS! This home is a rare find! Home sits on a one acre lakefront lot, overlooking a 33 acre private lake that is bordered by the Sam Houston National Forest! This quiet subdivision is zoned to highly acclaimed Montgomery ISD! Home has been partially renovated, with 2 bedrooms and 1 bathroom complete. Could be a 4/2. Would be perfect for a primary home, vacation home, or vacation rental! Home has a 300 ft. slab that is grandfathered into the conventional septic. Slab can be re-framed for a guest house! Composite roof new in 2020, new Pex Plumbing, brand new HVAC 2022. Home features hardwood cedar siding, a 40X12 back porch that spans the home, a covered breakfast porch (200 sq. ft) and front porch on slab (140 sq. ft.). HOME IS SOLD AS IS!' ,`Acres` = '1.07' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'S732000 - MOUNT PLEASANT LAKE, LOT 1' ,`LotDesciption` = 'Waterfront' ,`LotSize` = '46609' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '175' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'LINCOLN ELEMENTARY SCHOOL (MONTGOMERY)' ,`SchoolHigh` = 'MONTGOMERY HIGH SCHOOL' ,`SchoolMiddle` = 'MONTGOMERY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Mount Pleasant Lake' ,`TaxAmount` = '3581' ,`TaxRate` = '1.8242' ,`WaterSewer` = 'Aerobic' ,`YearBuilt` = '1975' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664310769' WHERE `Matrix_Unique_ID` = '212951416' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-27T07:41:37.507' ,`MLSNumber` = '76773372' ,`ListAgentFullName` = 'Chau Nguyen' ,`ListOfficeName` = 'Chau Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.689534' ,`Longitude` = '-95.289917' ,`PhotoCount` = '5' ,`PostalCode` = '77087' ,`RoomCount` = '5' ,`ListPrice` = '229900.00' ,`Status` = 'Active' ,`StreetName` = 'Greenstone' ,`StreetNumber` = '7610' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1224' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'EXCELLENT LOCATION to downtown, to UH Central, to Hobby airport, to medical center, to Pasadena, to Galveston, and many more. It is located at the junction of I-45 South and loop 610 South, minutes to Gulfgate Center Mall. Private gated property, never been flooded, quiet neighborhood, lovely interior, super cute loft upstairs, .' ,`Acres` = '0.1377' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hobby Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'TRS 2 & 3A BLK 1 GREENWAY SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'GOLFCREST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'HARTMAN MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Call Occupant,Leave Business Card,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Greenway 1' ,`TaxAmount` = '2933' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1951' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664310769' WHERE `Matrix_Unique_ID` = '212952913' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-27T07:48:58.200' ,`MLSNumber` = '23125311' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'Highland Homes Realty' ,`SellingAgentFullName` = 'Carolina Numa Montoya' ,`SellingOfficeName` = 'Keller Williams Metropolitan' ,`Latitude` = '30.293969' ,`Longitude` = '-95.563475' ,`PhotoCount` = '48' ,`PostalCode` = '77316' ,`RoomCount` = '5' ,`ListPrice` = '567215.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Cascade Heights' ,`StreetNumber` = '430' ,`StreetSuffix` = 'Drive' ,`City` = 'Montgomery' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2664' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 23125311 - Built by Highland Homes - January completion! ~ The Ellington plan has built-in appliances, 5 burner cooktop with pot and pan drawers, 2 story open dining area, 2 sinks in secondary bathroom. Primary bedroom has bay window and primary bath has drop in tub with shower. Downstairs includes primary bedroom and secondary bedroom with full baths.' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S965280 - Woodforest 80, BLOCK 1, Lot 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1150' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'STEWART ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodforest' ,`TaxAmount` = '' ,`TaxRate` = '2.9' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664310769' WHERE `Matrix_Unique_ID` = '212978043' --> 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','212993116','1664310769','212993116','2022-09-27T07:53:51.977','97371324','Shannon Hall','Gulf Coast, Realtors','','','29.514006','-95.091310','31','77573','5','215000.00','Active','Kansas','321','Avenue','League City','1','0','2','1309','Single-Family','Buyer ready! Situated on an amazing 10,500 sqft corner lot in Old League City! Updated with recent flooring, paint, granite counters. Easy access to shopping, park, and I-45! Large living room, dining area with wall of windows, two spacious bedrooms, and one car garage is auto opener. Never flooded! Central AC/Heat','0.241','33','','','Electric Dryer Connections,Washer Connections','','Other Disclosures,Sellers Disclosure','1','','','League City','Central Gas','0','ABST 3 PAGE 14 LOT 1 & NE 1/2 OF LOT 2 BLK 16 LEAGUE CITY TO','Corner,Subdivision Lot','10500','Appraisal District','','','0','','1','Freestanding Oven','0','','','Gas Range','','Composition','9 - Clear Creek','LEAGUE CITY ELEMENTARY SCHOOL','CLEAR CREEK HIGH SCHOOL','CLEAR CREEK INTERMEDIATE SCHOOL','Appointment Required,Supra Keybox','Appraisal District','1400','Ranch,Traditional','League City Townsite Blk 1-48','3495','2.0697','Public Sewer,Public Water','1951','Seller'); --> 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','212996951','1664310769','212996951','2022-09-27T06:30:24.807','40439617','Moon Kim','Lifestyles Realty, Inc.','','','30.363098','-95.622701','6','77316','4','161000.00','Active','W Hammon','16914','','Conroe','2','0','3','900','Single-Family','Look no further! Located in the desired Lake Conroe Village subdivision. This 3 bedroom 2 bathroom home is a perfect opportunity for a first time home buyer or an investor. An updated kitchen with granite counter tops and nice appliances. With easy access to Hwy105, next to Lake Conroe, 5 miles from Montgomery & Conroe. This one is a MUST SEE!!!','0.0482','39','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','Lake Conroe Area','Central Electric','1','S660300 - LAKE CONROE VILLAGE, BLOCK 13, LOT 60','Subdivision Lot','2100','Appraisal District','','106','0','','0','Electric Oven','0','','','Electric Range','','Composition','37 - Montgomery','STEWART CREEK ELEMENTARY SCHOOL','LAKE CREEK HIGH SCHOOL','OAK HILL JUNIOR HIGH SCHOOL','Appointment Required','Appraisal District','1','Traditional','Lake Conroe Village','2312','1.825','Public Sewer,Public Water','2020','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','212997037','1664310770','212997037','2022-09-27T07:06:44.647','90263429','Moon Kim','Lifestyles Realty, Inc.','','','29.667604','-95.009579','12','77571','4','185000.00','Active','Holmes','233','Street','La Porte','2','0','3','1632','Single-Family','This 3 bedroom 2 bathroom home on a large lot features lots of updates. The kitchen is updated with stainless fixtures and appliances. Both restrooms have an updated tile surrounds. Roof, foundation, and water heater replaced in 2017. HVAC 2014. Spacious living areas and bedrooms. Walking distance to Sylvan Beach. Easy access to Baytown, Pasadena, and Clear Lake. This one is a MUST SEE!!!','0.287','7','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','La Porte/Shoreacres','Central Electric','0','LTS 13 14 15 & 16 BLK 73 BAY FRONT TO LA PORTE','Subdivision Lot','12500','Appraisal District','','','0','','2','Electric Oven','0','','','Electric Range','','Composition','35 - La Porte','LA PORTE ELEMENTARY SCHOOL','LA PORTE HIGH SCHOOL','LA PORTE J H','Appointment Required','Appraisal District','1','Traditional','Bay Front Add','4721','2.7208','Public Sewer,Public Water','1985','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','212997155','1664310770','212997155','2022-09-27T07:45:13.500','73150938','Pamela M. Sims','Keller Williams Signature','','','29.826919','-95.703827','50','77449','10','336000.00','Active','Lilywood Springs','19102','Drive','Katy','3','1','5','2588','Single-Family','You will fall in love with this cozy and pristine two-story beauty, located in a cul-de-sac in the Westfield subdivision! New tile flooring, professionally painted, granite countertops, with stainless steel kitchen appliances, and spacious bedrooms will make you feel like you are home. Spacious primary bedroom located downstairs and four additional located on the second floor with the utility room. All appliances are included!! And it is located in one of the top school districts, Katy ISD!\r\n\r\nRoom measurements are approximate.','0.1219','25','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','Katy - North','Central Gas','1','LT 4 BLK 1 WESTFIELD SEC 16','Cul-De-Sac','5308','Other','','473','0','','2','Gas Oven','0','','','Freestanding Range,Gas Cooktop','','Composition','30 - Katy','RHOADS ELEMENTARY SCHOOL','MAYDE CREEK HIGH SCHOOL','CARDIFF JUNIOR HIGH SCHOOL','Appointment Required,Lockbox Front,Supra Keybox','Seller','2','Contemporary/Modern,Ranch','Westfield Sec 16','6617','2.822','Water District','2005','Seller'); --> New record created successfully