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-23T07:09:23.280' ,`MLSNumber` = '10540397' ,`ListAgentFullName` = 'Traci Crawford' ,`ListOfficeName` = 'Origen Realty' ,`SellingAgentFullName` = 'Karen Woolf' ,`SellingOfficeName` = 'Virginia Malone & Assoc.,' ,`Latitude` = '29.877814' ,`Longitude` = '-94.707199' ,`PhotoCount` = '46' ,`PostalCode` = '77597' ,`RoomCount` = '3' ,`ListPrice` = '495000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Lake Charlotte' ,`StreetNumber` = '724' ,`StreetSuffix` = 'Road' ,`City` = 'Wallisville' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2646' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This 5 acre beauty is looking for new owners! Gated access to front of home with 2 long driveways lead you to the front porch with double french front doors. Inside you will find a sitting area with fireplace, study/office, leading into kitchen area with eat-in kitchen, and additional living room/den. There are 2 secondary bedrooms with built-ins, full bathroom, and large primary bedroom with doors leading out to patio. Outside is a covered patio, large carport, and plenty of room in the front and backyard. Call to schedule your showing today!' ,`Acres` = '5.023' ,`Area` = '53' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Chambers County East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = '17 TR 11B-0 J MCFADDIN' ,`LotDesciption` = 'Cleared,Wooded' ,`LotSize` = '218802' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '4 - Anahuac' ,`SchoolElementary` = 'ANAHUAC ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ANAHUAC HIGH SCHOOL' ,`SchoolMiddle` = 'ANAHUAC MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'MCFADDIN' ,`TaxAmount` = '7240' ,`TaxRate` = '2.8113' ,`WaterSewer` = 'Public Sewer,Septic Tank' ,`YearBuilt` = '1995' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663949691' WHERE `Matrix_Unique_ID` = '201278354' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-23T07:25:38.377' ,`MLSNumber` = '6227801' ,`ListAgentFullName` = 'Deanna Parsons' ,`ListOfficeName` = 'Hill & Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.194294' ,`Longitude` = '-95.096460' ,`PhotoCount` = '13' ,`PostalCode` = '77327' ,`RoomCount` = '5' ,`ListPrice` = '174900.00' ,`Status` = 'Active' ,`StreetName` = 'Plum Grove' ,`StreetNumber` = '9365' ,`StreetSuffix` = 'Road' ,`City` = 'Cleveland' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2768' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'OVER THREE ACRES!! This one has a nice big shop and a blank slate for you! Large living area. Big backyard. Measurements are approximate, please measure if important.' ,`Acres` = '3.1836' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Real Estate Owned' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = '000208 A HOLHOUSEN, TRACT 203, ACRES 3.1836' ,`LotDesciption` = 'Cleared' ,`LotSize` = '138678' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '100 - Cleveland' ,`SchoolElementary` = 'COTTONWOOD SCHOOL (CLEVELAND)' ,`SchoolHigh` = 'CLEVELAND HIGH SCHOOL' ,`SchoolMiddle` = 'CLEVELAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'A Holhousen' ,`TaxAmount` = '4254' ,`TaxRate` = '2.2178' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663949691' WHERE `Matrix_Unique_ID` = '204881347' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-23T07:43:36.950' ,`MLSNumber` = '68345251' ,`ListAgentFullName` = 'Lizabeth Comiskey' ,`ListOfficeName` = 'Comiskey Realty' ,`SellingAgentFullName` = 'Tina Langford' ,`SellingOfficeName` = 'BHGRE Gary Greene' ,`Latitude` = '29.297676' ,`Longitude` = '-94.916792' ,`PhotoCount` = '40' ,`PostalCode` = '77554' ,`RoomCount` = '8' ,`ListPrice` = '799997.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Paradise' ,`StreetNumber` = '310' ,`StreetSuffix` = '' ,`City` = 'Tiki Island' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2316' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BACK UP OFFERS ARE BEING ACCEPTED.\r\n\r\nBeautifully fully furnished updated home facing east. This home has a three - car garage and an overabundance of outdoor space for entertaining. The open concept floor plan has high ceilings, lots of windows and beautiful views. \r\n\r\nTenant occupied so ask for Tenants exclusions. Weekday showings only!!\r\n\r\n\r\nGreat boat lift area with plenty of room to catch the fish off the dock.\r\nThe huge covered sitting area around the boat area can easily be created into a fab outdoor kitchen.\r\nThe three car garage has plenty of extra space to make it your own.\r\nDon\'t forget about the beautiful sunsets off the upper deck. You won\'t want to miss this perfect home!' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tiki Island' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 7 PAGE 17 LOT 32 TIKI ISLAND SEC 6' ,`LotDesciption` = 'Subdivision Lot,Water View,Waterfront' ,`LotSize` = '5401' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '160' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '52 - Texas City' ,`SchoolElementary` = 'HIGHLANDS ELEMENTARY SCHOOL (LA MARQUE)' ,`SchoolHigh` = 'LA MARQUE HIGH SCHOOL (TEXAS CITY)' ,`SchoolMiddle` = 'LA MARQUE MIDDLE SCHOOL (TEXAS CITY)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Tiki Island' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1984' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663949691' WHERE `Matrix_Unique_ID` = '206252290' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-23T07:48:37.463' ,`MLSNumber` = '79273080' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'Highland Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.276596' ,`Longitude` = '-95.573602' ,`PhotoCount` = '27' ,`PostalCode` = '77316' ,`RoomCount` = '8' ,`ListPrice` = '865000.00' ,`Status` = 'Active' ,`StreetName` = 'South Empress Green' ,`StreetNumber` = '207' ,`StreetSuffix` = 'Place' ,`City` = 'Montgomery' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3035' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 79273080 - Built by Huntington Homes - December completion! ~ MODERN exterior elevation with PAINTED BRICK & DARK window frames. This Sleek Sophisticated luxury home features a grand Double Door entryway and stunning architecturally designed 13\' ceilings throughout. The bountiful kitchen is polished and modern with Professional SS appliances, oversized island, breakfast bar, keeping room & FIREPLACE for ambiance. Sliding glass doors that open to an extended covered patio. LOTS of Natural Light! Study, Entertainment room and a beautiful Primary Suite that offers Dual Sinks and Built-in Make Up Vanity, Separate Tub/Glass Shower, and long walk-in closet attached to Laundry Rm. 3 Car Tandem Garage. Tankless Water Heater, Full Gutter Package, Full Sprinkler System, PEX Plumbing, Built-in Pest Control system & more! e Package including Kwikset SmartCode Deadbolt, Honey well Smart Thermostat, Eero Wifi Router System, Skybell and Liftmaster, Wifi Garage Door Opener!!' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'Huntington Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 12 / Block 1' ,`LotDesciption` = 'Cul-De-Sac,In Golf Course Community,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1265' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'LONE STAR ELEMENTARY SCHOOL (MONTGOMERY)' ,`SchoolHigh` = 'LAKE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'OAK HILL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'English' ,`Subdivision` = 'Woodforest Noble Greens' ,`TaxAmount` = '' ,`TaxRate` = '2.81' ,`WaterSewer` = 'Other Water/Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663949691' WHERE `Matrix_Unique_ID` = '206899729' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-23T07:30:41.997' ,`MLSNumber` = '52499843' ,`ListAgentFullName` = 'Daisy Lopez' ,`ListOfficeName` = 'Move Up America' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.953285' ,`Longitude` = '-95.192987' ,`PhotoCount` = '14' ,`PostalCode` = '77396' ,`RoomCount` = '5' ,`ListPrice` = '331565.00' ,`Status` = 'Active' ,`StreetName` = 'Black Grouse' ,`StreetNumber` = '15855' ,`StreetSuffix` = 'Drive' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1714' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WELCOME HOME TO THE OAKDALE PLAN in beautiful Balmoral! This home is part of Chesmar\'s BRAND NEW TOWN SQUARE SERIES. The Oakdale features a split level plan, step up to Wide Open Concept living with wall to wall windows and a spacious master on the main floor, or step down to 2 additional Bedrooms, a hall Bathroom, and study nook. This home showcases TWO Covered Outdoor Living Space (Ground floor and second-floor Balcony off living room!)+ 2 Car Attached Garage. Stainless Steel Appliances, 2\" Blinds, Upgraded Vinyl Plank Flooring, on-trend white quartz counters in the kitchen, Sprinkler System, Fully Sodded Yard + Landscaping Pkg all included! Home is available for immediate move-in, Chesmar Homes is the builder.' ,`Acres` = '' ,`Area` = '1' ,`BuilderName` = 'Chesmar Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Summerwood/Lakeshore' ,`HeatSystem` = 'Central Electric,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot:14 Block:1 Section:26' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1150' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'GROVES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'WEST LAKE MIDDLE SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Balmoral' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663949691' WHERE `Matrix_Unique_ID` = '206943699' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-23T07:26:41.133' ,`MLSNumber` = '50638752' ,`ListAgentFullName` = 'Deanna Parsons' ,`ListOfficeName` = 'Gen Stone Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.004361' ,`Longitude` = '-95.174085' ,`PhotoCount` = '10' ,`PostalCode` = '77346' ,`RoomCount` = '6' ,`ListPrice` = '407000.00' ,`Status` = 'Active' ,`StreetName` = 'Wild Violet' ,`StreetNumber` = '6810' ,`StreetSuffix` = 'Drive' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3219' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Over 3000 SF on a nice sized lot. Detached 3 car garage.' ,`Acres` = '0.2957' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Real Estate Owned' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Atascocita North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 9 BLK 35 PINEHURST OF ATASCOCITA 8 AMND' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '12879' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '618' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'PINEFOREST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ATASCOCITA HIGH SCHOOL' ,`SchoolMiddle` = 'ATASCOCITA MIDDLE SCHOOL' ,`ShowInstructions` = 'Temporarily No Showings' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Pinehurst/Atascocita Sec 8' ,`TaxAmount` = '7003' ,`TaxRate` = '2.453' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663949691' WHERE `Matrix_Unique_ID` = '208162211' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-23T07:53:17.573' ,`MLSNumber` = '51637505' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'Highland Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.135446' ,`Longitude` = '-95.317993' ,`PhotoCount` = '29' ,`PostalCode` = '77365' ,`RoomCount` = '7' ,`ListPrice` = '445000.00' ,`Status` = 'Active' ,`StreetName` = 'Jordan Pond' ,`StreetNumber` = '21551' ,`StreetSuffix` = 'Ridge' ,`City` = 'Porter' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2356' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 51637505 - Built by Highland Homes - December completion! ~ Enter this 2-story home to high ceilings and beautiful staircase at the entry. This open concept floorplan is great for entertaining with soaring ceilings above the family areas. The primary suite, which features a bay window, is located on the first floor with all secondary bedrooms located on the second. The second floor also includes two full bathrooms and a game room.' ,`Acres` = '' ,`Area` = '40' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Porter/New Caney West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot: 12 Block: 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1420' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'ROBERT CRIPPEN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PORTER HIGH SCHOOL (NEW CANEY)' ,`SchoolMiddle` = 'WHITE OAK MIDDLE SCHOOL (NEW CANEY)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'The Highlands' ,`TaxAmount` = '' ,`TaxRate` = '3.38' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663949692' WHERE `Matrix_Unique_ID` = '208316691' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-23T07:41:30.043' ,`MLSNumber` = '80378000' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'LennarVillageBldr-JaredTurner' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.518503' ,`Longitude` = '-95.784257' ,`PhotoCount` = '6' ,`PostalCode` = '77471' ,`RoomCount` = '8' ,`ListPrice` = '427390.00' ,`Status` = 'Active' ,`StreetName` = 'Springview' ,`StreetNumber` = '3615' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosenberg' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2393' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW! Lennar Fairway Collection \"Russo IV\" Plan with Elevation \"A\" in Sendero! Beautiful single-story home featuring a cohesive design shared among the modern kitchen, dining and family room, with an attached covered patio. Three bedrooms and a study present ample flexibility in the front of the home. The owner’s suite highlights privacy tucked away at the end of the home, complete with a lavish bathroom and walk-in closet. *HOME ESTIMATED TO BE COMPLETE, NOVEMBER, 2022*' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Lennar' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SEC 0003 BLK 001 LOT 030' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '756' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'MEYER ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'RANDLE HIGH SCHOOL' ,`SchoolMiddle` = 'WRIGHT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sendero' ,`TaxAmount` = '' ,`TaxRate` = '3.09' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663949692' WHERE `Matrix_Unique_ID` = '209015697' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-23T07:34:55.383' ,`MLSNumber` = '79633034' ,`ListAgentFullName` = 'Thomas Schwenk' ,`ListOfficeName` = 'Coldwell Banker TGRE' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.286744' ,`Longitude` = '-94.805234' ,`PhotoCount` = '28' ,`PostalCode` = '77550' ,`RoomCount` = '6' ,`ListPrice` = '279000.00' ,`Status` = 'Active' ,`StreetName` = '37th' ,`StreetNumber` = '2005' ,`StreetSuffix` = 'Street' ,`City` = 'Galveston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1105' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New price! This long-term rental has a great floor plan! 2-3 beds and 1 bath. Hallway has an additional closet and cool built-ins. Nice sized bedrooms with good closet space. The primary has his and hers! One car detached garage with nice yard. Front porch adds to living space. the back room apparently a porch presumably at one time could be used as a 3rd bedroom if needed also make a great home office.' ,`Acres` = '0.0786' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'East End' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 628 M B MENARD SUR PT OF LOTS 6 & 7 (3006-3) SE BLK 85' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '3424' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Galveston Outlots' ,`TaxAmount` = '3573' ,`TaxRate` = '2.0662' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1958' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663949692' WHERE `Matrix_Unique_ID` = '209036120' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-23T07:50:24.103' ,`MLSNumber` = '86208689' ,`ListAgentFullName` = 'Demitra Turner' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.102166' ,`Longitude` = '-95.522946' ,`PhotoCount` = '43' ,`PostalCode` = '77389' ,`RoomCount` = '11' ,`ListPrice` = '549999.00' ,`Status` = 'Active' ,`StreetName` = 'Barronton' ,`StreetNumber` = '6615' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3638' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Location, Location, Location! This Home Has It All! Beautiful 5 bedroom home located in golf course community of Northampton Forest. Texas-sized cul-de-sac lot (approx. 1/3 acre) with a 3-car detached garage, large pool, and spacious back yard with plenty of room to expand the outdoor entertainment area. Traditionally styled interior boasts a home office/library (with built in shelves), formal dining room, large living area and kitchen, gas log fireplace, utility room, and large master suite downstairs, with four generously sized bedrooms, 2 full baths, and an enormous combination game and living area upstairs. New Roof (Nov. 2021) - A/C unit (2018). Willowcreek Golf Course is in the neighborhood. 3 other courses, including Augusta Pines Golf Course are within a short distance. The home is also ideally located within a short distance of the ExxonMobil Spring campus, The Woodlands - Woodlands Mall. Quick and easy access to SH-99 Grand Parkway, I-45, and the 249 corridor.' ,`Acres` = '0.3168' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 15 BLK 5 NORTHAMPTON FOREST SEC 1' ,`LotDesciption` = 'Cul-De-Sac,In Golf Course Community,Subdivision Lot,Wooded' ,`LotSize` = '13800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '385' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'NORTHAMPTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN OAK HIGH SCHOOL' ,`SchoolMiddle` = 'HILDEBRANDT INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Northampton Forest Sec 01' ,`TaxAmount` = '10024' ,`TaxRate` = '2.664' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1994' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663949692' WHERE `Matrix_Unique_ID` = '209129684' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-23T07:50:33.950' ,`MLSNumber` = '80395796' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'Highland Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.816102' ,`Longitude` = '-95.844328' ,`PhotoCount` = '37' ,`PostalCode` = '77493' ,`RoomCount` = '12' ,`ListPrice` = '675000.00' ,`Status` = 'Active' ,`StreetName` = 'San Bernard' ,`StreetNumber` = '7026' ,`StreetSuffix` = 'Trail' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3009' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 80395796 - Built by Highland Homes - November completion! ~ This stunning Highland Home is available in Cane Island in Katy Texas. 3011 sq ft includes a primary bedroom extension, extended outdoor living, sliding glass doors, gorgeous hutch in the kitchen, and fireplace in the family room. With Katy ISD schools, and a beautiful welcome center you have found a place to call home.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '18/1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7879' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'BRYANT ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'KATY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cane Island 65s' ,`TaxAmount` = '' ,`TaxRate` = '3.4' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663949692' WHERE `Matrix_Unique_ID` = '209218831' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-23T07:44:51.530' ,`MLSNumber` = '37958865' ,`ListAgentFullName` = 'Johnny Schiro' ,`ListOfficeName` = 'Icon Realty Group, L.L.C.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.094970' ,`Longitude` = '-95.451579' ,`PhotoCount` = '36' ,`PostalCode` = '77389' ,`RoomCount` = '10' ,`ListPrice` = '510000.00' ,`Status` = 'Active' ,`StreetName` = 'Dobbs View' ,`StreetNumber` = '70' ,`StreetSuffix` = 'Lane' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2031' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'HUGE BACK YARD - with no rear neighbors! LUXURY new construction from Sullivan Brothers - Literally 30 seconds from Grand Parkway 99 and I-45, and STEPS from the Exxon Campus, HP, and the HOTTEST NEW RETAIL in Houston - CityPlace (much like City Centre, with 400,000 SQ FT of top-tier shopping & dining!!!) Wide-open main living space (up) with absolutely gorgeous double balcony doors overlooking the reserve - awesome natural light and a gorgeous view! Huge master suite with his & hers closets, soaking tub + oversized shower, and a private balcony! 10’ ceilings upstairs and down, generous secondary bedrooms, covered patio, and upgraded finishes throughout! All of this just 10 minutes from Market Street, 20 minutes from IAH, and 35 minutes from Downtown! Luxury lifestyle, true convenience...and HUGE APPRECIATION POTENTIAL. Limited homesites remain - come visit Harper Woods before we\'re sold out!' ,`Acres` = '' ,`Area` = '14' ,`BuilderName` = 'Sullivan Brothers' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Spring/Klein' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 7 BLK 1 Harper Woods Partial Replat 1' ,`LotDesciption` = 'Greenbelt,Subdivision Lot' ,`LotSize` = '6197' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'NORTHGATE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'SPRINGWOODS VILLAGE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Harper Woods at Springwoods Village' ,`TaxAmount` = '' ,`TaxRate` = '3.087' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663949692' WHERE `Matrix_Unique_ID` = '209321381' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-23T07:44:23.500' ,`MLSNumber` = '29621348' ,`ListAgentFullName` = 'Johnny Schiro' ,`ListOfficeName` = 'Icon Realty Group, L.L.C.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.092779' ,`Longitude` = '-95.450521' ,`PhotoCount` = '33' ,`PostalCode` = '77389' ,`RoomCount` = '10' ,`ListPrice` = '471960.00' ,`Status` = 'Active' ,`StreetName` = 'Thorpe' ,`StreetNumber` = '15' ,`StreetSuffix` = 'Lane' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2031' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Builder Close-out!! Last Opportunities from Sullivan Brothers in Harper Woods! LUXURY lifestyle, PRIME location, and no rear neighbors! Hard flooring throughout! Literally 30 seconds from Grand Parkway 99 and I-45, and STEPS from the Exxon Campus, HP, and the HOTTEST NEW RETAIL in Houston - CityPlace (much like City Centre, with 400,000 SQ FT of top-tier shopping & dining!!!) Wide-open main living space (up) with absolutely gorgeous double balcony doors overlooking the reserve - awesome natural light and a gorgeous view! Huge master suite with his & hers closets, soaking tub + oversized shower, and a private balcony! 10’ ceilings upstairs and down, generous secondary bedrooms, covered patio, and upgraded finishes throughout! All of this just 10 minutes from Market Street, 20 minutes from IAH, and 35 minutes from Downtown! Luxury lifestyle, true convenience...and HUGE APPRECIATION POTENTIAL. Limited homesites remain - come visit Harper Woods before we\'re sold out!' ,`Acres` = '' ,`Area` = '14' ,`BuilderName` = 'Sullivan Brothers' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Spring/Klein' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 6 BLK 3 Harper Woods Partial Replat 2' ,`LotDesciption` = 'Cul-De-Sac,Greenbelt,Subdivision Lot' ,`LotSize` = '2629' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'NORTHGATE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'SPRINGWOODS VILLAGE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Harper Woods at Springwoods Village' ,`TaxAmount` = '' ,`TaxRate` = '3.087' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663949693' WHERE `Matrix_Unique_ID` = '209321551' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-23T07:45:16.400' ,`MLSNumber` = '5511238' ,`ListAgentFullName` = 'Johnny Schiro' ,`ListOfficeName` = 'Icon Realty Group, L.L.C.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.092850' ,`Longitude` = '-95.451886' ,`PhotoCount` = '30' ,`PostalCode` = '77389' ,`RoomCount` = '7' ,`ListPrice` = '499000.00' ,`Status` = 'Active' ,`StreetName` = 'Thorpe' ,`StreetNumber` = '55' ,`StreetSuffix` = 'Lane' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1913' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Model Home - Builder CLOSING OUT! New LUXURY in Harper Woods at Springwoods Village - 30 seconds from Grand Parkway 99 and I-45, and STEPS from the Exxon Campus, HP, and the HOTTEST NEW RETAIL in Houston - CityPlace!! Pure charm & charisma from Sullivan Brothers - it’s that French Quarter style that you just can’t find elsewhere in North Houston! 3 bedrooms up including a HUGE primary bedroom with a PRIVATE BALCONY, open-concept island kitchen w/ gorgeous Quartz counter tops, a HUGE family room, and over 160 SF of covered patio! First class finishes throughout: 10’ ceilings up & down, gorgeous hardwoods, 8\' doors, elegant trim work, and upgraded fixtures & hardware. All of this just a short walk from Houston\'s newest and HOTTEST retail development! Don\'t miss YOUR OPPORTUNITY for one of the last homesites in the coveted Harper Woods! Luxury and convenience...with HUGE APPRECIATION POTENTIAL. Limited homesites remain - come visit Harper Woods before we\'re sold out!' ,`Acres` = '' ,`Area` = '14' ,`BuilderName` = 'Sullivan Brothers' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Spring/Klein' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 6 BLK 1 HARPER WOODS REPLAT 1' ,`LotDesciption` = 'Cul-De-Sac,Greenbelt,Subdivision Lot' ,`LotSize` = '2667' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'NORTHGATE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'SPRINGWOODS VILLAGE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Harper Woods Springwoods Village' ,`TaxAmount` = '' ,`TaxRate` = '3.087' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663949693' WHERE `Matrix_Unique_ID` = '209321707' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-23T07:31:19.950' ,`MLSNumber` = '2855809' ,`ListAgentFullName` = 'Daisy Lopez' ,`ListOfficeName` = 'Move Up America' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.953099' ,`Longitude` = '-95.192987' ,`PhotoCount` = '41' ,`PostalCode` = '77396' ,`RoomCount` = '5' ,`ListPrice` = '342540.00' ,`Status` = 'Active' ,`StreetName` = 'Black Grouse' ,`StreetNumber` = '15854' ,`StreetSuffix` = 'Drive' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1714' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WELCOME HOME TO THE OAKDALE PLAN in beautiful Balmoral! This home is part of Chesmar\'s BRAND NEW TOWN SQUARE SERIES. The Oakdale features a split level plan, step up to Wide Open Concept living with wall-to-wall windows and a spacious master on the main floor, or step down to 2 additional Bedrooms, hall Bathroom, and study nook. This home showcases TWO Covered Outdoor Living Space (Ground floor and second-floor Balcony off living room!)+ 2 Car Attached Garage. Stainless Steel Appliances, 2\" Blinds, Upgraded Vinyl Plank Flooring, on-trend white quartz counters in the kitchen, Sprinkler System, Fully Sodded Yard + Landscaping Pkg all included! Home is available for immediate move-in!' ,`Acres` = '' ,`Area` = '1' ,`BuilderName` = 'Chesmar Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Summerwood/Lakeshore' ,`HeatSystem` = 'Central Electric,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot:14 Block:2 Section:26' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1150' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'CENTENNIAL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = '' ,`ShowInstructions` = 'Leave Business Card,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Balmoral' ,`TaxAmount` = '' ,`TaxRate` = '3.55735' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663949693' WHERE `Matrix_Unique_ID` = '209359204' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-23T07:43:44.937' ,`MLSNumber` = '23456872' ,`ListAgentFullName` = 'Aaron Jistel' ,`ListOfficeName` = 'Listing Spark' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.984430' ,`Longitude` = '-95.102096' ,`PhotoCount` = '44' ,`PostalCode` = '77532' ,`RoomCount` = '8' ,`ListPrice` = '374500.00' ,`Status` = 'Active' ,`StreetName` = 'Moose' ,`StreetNumber` = '719' ,`StreetSuffix` = 'Drive' ,`City` = 'Crosby' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2260' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful newly constructed home 2260 sq. ft.: 3 bedrooms with upper office and bonus media/bedroom. This finely detailed home has a large, covered patio and is move-in ready including kitchen appliances. Tile flooring in primary areas with carpeted bedrooms and upper rooms. 42” high cabinets w/ night under-cabinet sensory activated lighting, wood stairs, customized master bath, and bedroom closets; even the garage is detailed with trim and epoxy flooring. Interior and exterior lighting can be adjusted to light tone preference. Large driveway and lot. Neighborhood has private Lake Houston access 1.5 miles from property with boat launch. Motivated HOA for neighborhood revitalization. Within the excellent, State recognized, Huffman Independent School District with easy access to medical centers, shopping, and fun activities in Houston, Atascocita, Kingwood, and Crosby, Texas. This is a must-see property!' ,`Acres` = '0.3329' ,`Area` = '1' ,`BuilderName` = 'FM Businesses Unli L' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Huffman Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 654 HAPPY HIDE A WAY SEC 4 U/R' ,`LotDesciption` = 'Other' ,`LotSize` = '14500' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '50' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '28 - Huffman' ,`SchoolElementary` = 'HUFFMAN ELEMENTARY SCHOOL (HUFFMAN)' ,`SchoolHigh` = 'HARGRAVE HIGH SCHOOL' ,`SchoolMiddle` = 'HUFFMAN MIDDLE SCHOOL' ,`ShowInstructions` = 'Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1.5' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Happy Hide A Way Sec 04 U/R' ,`TaxAmount` = '403' ,`TaxRate` = '2.0083' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663949693' WHERE `Matrix_Unique_ID` = '209554478' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-23T07:29:59.660' ,`MLSNumber` = '86012983' ,`ListAgentFullName` = 'Daisy Lopez' ,`ListOfficeName` = 'Move Up America' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.953229' ,`Longitude` = '-95.191142' ,`PhotoCount` = '22' ,`PostalCode` = '77396' ,`RoomCount` = '5' ,`ListPrice` = '343690.00' ,`Status` = 'Active' ,`StreetName` = 'Glascorri' ,`StreetNumber` = '15806' ,`StreetSuffix` = 'Drive' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1760' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New Construction- Chesmar Homes \"Rowen” Plan. Two-Story 3 Bed/2 Bath w/ Study, & 2-car Attached Garage. Grand 8’ Doorway Leads to Naturally Lit Open Floor Plan w/ 11’ Ceilings in the Main Living Areas, Kitchen Features Beautiful Decorator White Cabinets, 42\" Uppers w/ 3 CM Shell White Quartz, Eat-in Kitchen + Breakfast Area. Main Suite offers Attached Bath w/ Dual Vanities, Tub/Shower Combo, & Walk-in Closet & Covered Patio. Upgraded Wood Tile Flooring Sweeping Through Main Living Area. Stainless GE Appliance Pkg, PEX Plumbing, 2” Faux-Wood Cordless Blinds in All Operable Windows, Double-pane LoE3 Colored Insulated Vinyl Windows, Energy Efficient Light Pkg, Automatic Garage Door Opener, 1st Floor All 4 Sides Brick, Fully Sodded Lot, Front & Back Sprinkler System + Landscape Pkg all included! For more info, contact Chesmar Homes in Balmoral. Projected time of completion Sept. 2022. Photos are representative.' ,`Acres` = '' ,`Area` = '1' ,`BuilderName` = 'Chesmar Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Summerwood/Lakeshore' ,`HeatSystem` = 'Central Electric,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot:7 Block:4 Section:26' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5265' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1330' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'CENTENNIAL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'AUTUMN RIDGE MIDDLE SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Balmoral' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663949693' WHERE `Matrix_Unique_ID` = '209652954' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-23T07:56:06.130' ,`MLSNumber` = '27324575' ,`ListAgentFullName` = 'Rudolph Reyes' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.077819' ,`Longitude` = '-95.774940' ,`PhotoCount` = '20' ,`PostalCode` = '77447' ,`RoomCount` = '6' ,`ListPrice` = '267000.00' ,`Status` = 'Active' ,`StreetName` = 'Bauer Canyon' ,`StreetNumber` = '22418' ,`StreetSuffix` = 'Drive' ,`City` = 'Hockley' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1416' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Looking for a great place to call home? This is it! This charming one story 3-bedroom 2-bath 2-car garage home is in Bauer Landing and has easy access to 290 and the 99. This open concept floorplan is very inviting and perfect for entertaining family and friends. Kitchen features custom granite countertops and ceramic tile floor. This home truly is a hidden gem. The backyard is huge and ideal for weekend BBQs with family and friends. Great location with tons of community amenities, local shopping & restaurants. This home was built in 2017 and is zoned to Waller ISD and won\'t last long. Priced to sell. Call to make your appointment today.' ,`Acres` = '0.1421' ,`Area` = '35' ,`BuilderName` = 'LGI Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hockley' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 30 BLK 6 BAUER LANDING SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6192' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '475' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'EVELYN TURLINGTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'SCHULTZ JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Bauer Landing' ,`TaxAmount` = '5358' ,`TaxRate` = '2.8556' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663949693' WHERE `Matrix_Unique_ID` = '209691506' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-23T07:50:07.973' ,`MLSNumber` = '77310274' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'Highland Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.816171' ,`Longitude` = '-95.842813' ,`PhotoCount` = '28' ,`PostalCode` = '77493' ,`RoomCount` = '11' ,`ListPrice` = '650000.00' ,`Status` = 'Active' ,`StreetName` = 'San Bernard' ,`StreetNumber` = '6914' ,`StreetSuffix` = '' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2976' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 77310274 - Built by Highland Homes - November completion! ~ The beautiful Highland Home is perfect for you in Cane Island. With over 3000 sq ft, extended outdoor living space great for get togethers, an extended primary suite, a fireplace in the family room for those cozy winter nights, an enhanced kitchen perfect for your own cooking show! Cane Island has Katy ISD school with a brand new elementary school.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '28/1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8001' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'ROBERTSON ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'KATY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cane Island 65s' ,`TaxAmount` = '' ,`TaxRate` = '3.4' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663949693' WHERE `Matrix_Unique_ID` = '209757369' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-23T07:47:24.817' ,`MLSNumber` = '34589557' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'Highland Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.800579' ,`Longitude` = '-95.852194' ,`PhotoCount` = '41' ,`PostalCode` = '77493' ,`RoomCount` = '11' ,`ListPrice` = '750000.00' ,`Status` = 'Active' ,`StreetName` = 'Cypress' ,`StreetNumber` = '7506' ,`StreetSuffix` = 'Cove' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3680' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 34589557 - Built by Highland Homes - December completion! ~ This stunning Highland Home is located in Cane Island with Katy Schools! With a brand new elementary school opening this fall you can\'t miss out on this one. With over 3600 sq ft it comes with an extended outdoor living space, and extended primary suite, a formal dining room, media room on the first floor, game room on the second floor, study, and enhanced bedrooms upstairs' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '12/1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10237' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'ROBERTSON ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'KATY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cane Island 65s' ,`TaxAmount` = '' ,`TaxRate` = '3.4' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663949694' WHERE `Matrix_Unique_ID` = '209775812' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-23T06:24:32.353' ,`MLSNumber` = '1022449' ,`ListAgentFullName` = 'Mary Wise' ,`ListOfficeName` = 'Stanfield Properties' ,`SellingAgentFullName` = 'Kelly Kelley' ,`SellingOfficeName` = 'RE/MAX Leading Edge' ,`Latitude` = '29.151779' ,`Longitude` = '-95.026579' ,`PhotoCount` = '48' ,`PostalCode` = '77554' ,`RoomCount` = '15' ,`ListPrice` = '1765000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Bluewing Teal' ,`StreetNumber` = '4114' ,`StreetSuffix` = 'Court' ,`City` = 'Galveston' ,`BathsFull` = '4' ,`BathsHalf` = '2' ,`BedsTotal` = '5' ,`SqFtTotal` = '3027' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Coastal living at its finest in the gated Sunset Cove community on Galveston\'s west end! This nearly new custom design with beautiful landscaping boasts 5 bedrooms, 4 full & 2 half baths, & an exquisite open concept with wood look tile floors, recessed lighting, & custom window shades throughout. The oversized island kitchen showcases white quartz counters, custom ceiling height cabinetry with lighting, & top-notch Viking appliances. Additionally, on this level, you\'ll find a bedroom with ensuite bath, an oversized utility room, & convenient half bath. Upstairs, find 3 additional bedrooms with ensuite baths, a built-in bunk room, & a game room. Enjoy the sunrise or sunset off your bi-level east & west-facing decks with endless views of the beach, bay, & canal. Entertain outdoors with numerous covered sitting areas, an outdoor kitchen, bath, & shower, a 2-level composite decked boathouse with a 23\'x10\' slip, boat lift, & green lights, & a fully fenced backyard with sprinkler system.' ,`Acres` = '0.2141' ,`Area` = '33' ,`BuilderName` = 'Bay Point Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'West End' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SUNSET COVE (2005), ABST 121, BLOCK F, LOT 3, ACRES 0.214' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot,Waterfront' ,`LotSize` = '9327' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sunset Cove 2005' ,`TaxAmount` = '29714' ,`TaxRate` = '2.2124' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663949694' WHERE `Matrix_Unique_ID` = '209924920' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-23T07:46:59.887' ,`MLSNumber` = '12596731' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'Highland Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.444173' ,`Longitude` = '-95.400289' ,`PhotoCount` = '50' ,`PostalCode` = '77583' ,`RoomCount` = '4' ,`ListPrice` = '650000.00' ,`Status` = 'Active' ,`StreetName` = 'Coronado' ,`StreetNumber` = '4643' ,`StreetSuffix` = 'Court' ,`City` = 'Manvel' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3009' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 12596731 - Built by Highland Homes - October completion! ~ This beautiful home has a tall elevation with a double door entry. Natural wood flooring throughout the home leads to sliding glass doors that take you outside to the extended covered patio! Black cabinets on the lower perimeter and island with white cabinets above. Quartz countertops with black cabinet hardware complete the look! Floor to ceiling tiled fireplace!' ,`Acres` = '0.1926' ,`Area` = '5' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'MERIDIANA SEC 43 (A0286) (MANVEL) BLK 1 LOT 47' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8391' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1050' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Meridiana' ,`TaxAmount` = '' ,`TaxRate` = '0' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663949694' WHERE `Matrix_Unique_ID` = '210226825' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-23T06:14:05.537' ,`MLSNumber` = '7988441' ,`ListAgentFullName` = 'Suzanne Heinrich' ,`ListOfficeName` = 'Main Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.775474' ,`Longitude` = '-94.931419' ,`PhotoCount` = '48' ,`PostalCode` = '77521' ,`RoomCount` = '9' ,`ListPrice` = '378000.00' ,`Status` = 'Active' ,`StreetName` = 'Parkwood' ,`StreetNumber` = '2927' ,`StreetSuffix` = 'Drive' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2809' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come take a look at this spacious, beautifully updated home that is move-in ready. The open floor plan is perfect for entertaining. Gorgeous granite countertops in the kitchen, with lots of cabinets for storage. The amazing primary suite is large and full of natural light. The en-suite primary bathroom has been beautifully updated. \r\nThe split floor plan upstairs is a nice set up for or to provide a special place for guests. Upstairs includes a gameroom/office space that could also become a 5th bedroom. The backyard has a lovely patio and plenty of room for new owners to put in a pool. All of this and the convenience of being close to the schools, HWY 146, Interstate 10, and the Grand Parkway! This quiet neighborhood is close to walking and bike trails and a city park. This property is a MUST see!' ,`Acres` = '0.2258' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 7 BLK 2 PARKWOOD PLACE SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9834' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '235' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'STEPHEN F. AUSTIN ELEMENTARY SCHOOL (GOOSE CREEK)' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (GOOSE CREEK)' ,`SchoolMiddle` = 'CEDAR BAYOU J H' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Parkwood Place Sec 01' ,`TaxAmount` = '7441' ,`TaxRate` = '2.97' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1993' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663949694' WHERE `Matrix_Unique_ID` = '210315654' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-23T07:52:55.390' ,`MLSNumber` = '25634363' ,`ListAgentFullName` = 'Randall Ver Ploeg' ,`ListOfficeName` = 'Woodlands Preferred Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.133666' ,`Longitude` = '-95.409397' ,`PhotoCount` = '30' ,`PostalCode` = '77386' ,`RoomCount` = '10' ,`ListPrice` = '269900.00' ,`Status` = 'Active' ,`StreetName` = 'Invermere' ,`StreetNumber` = '2015' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1608' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'HARD to find SINGLE STORY, 4 BEDROOM, split floorplan w/ formal dining room! Home has Nest iPhone compatability! Recent upgrades include fresh paint throughout and carpet. Appliances include a 5 burner gas stove with griddle, dishwasher, SS sink & microwave. REFRIGERATOR, WASHER & DRYER INCLUDED! Also replaced water heater, blinds, fixtures, electrical outlets and switches. Granite in kitchen & bathrooms. Updated vessel bowl sinks in both baths! Fresh landscaping. Home has a sprinkler system and fully guttered. Shopping center less than a mile away! Less than 10 minutes to The Woodlands mall & amenities. Make an appt. today!' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'IMPERIAL OAKS 03, BLOCK 20, LOT 48' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '7200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'KAUFMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'OAK RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'IRONS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Imperial Oaks 03' ,`TaxAmount` = '3987' ,`TaxRate` = '2.487' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1992' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663949694' WHERE `Matrix_Unique_ID` = '210754664' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-23T07:06:41.990' ,`MLSNumber` = '93410421' ,`ListAgentFullName` = 'Deanna Parsons' ,`ListOfficeName` = 'Hill & Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.816071' ,`Longitude` = '-94.830796' ,`PhotoCount` = '15' ,`PostalCode` = '77523' ,`RoomCount` = '6' ,`ListPrice` = '279900.00' ,`Status` = 'Active' ,`StreetName` = 'Coral Cove' ,`StreetNumber` = '6123' ,`StreetSuffix` = 'Road' ,`City` = 'Cove' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2042' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW APPLIANCES!! NEW PAINT!! NEW CARPET!! This 3/2.5 is so beautiful! Large livingroom. Breakfast area. Great kitchen with new appliances. Half bath downstairs. All bedrooms are upstairs along with the large utility room.' ,`Acres` = '0.172' ,`Area` = '53' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Real Estate Owned' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Chambers County West' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 19 BK 2 JOSEPHS COVE SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7492' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '380' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '6 - Barbers Hill' ,`SchoolElementary` = 'BARBERS HILL SOUTH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BARBERS HILL HIGH SCHOOL' ,`SchoolMiddle` = 'BARBERS HILL SOUTH MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Josephs Cove Sec 3' ,`TaxAmount` = '4074' ,`TaxRate` = '1.7058' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663949694' WHERE `Matrix_Unique_ID` = '210792828' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-23T06:48:56.257' ,`MLSNumber` = '40618104' ,`ListAgentFullName` = 'Andrew West' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.434934' ,`Longitude` = '-95.438084' ,`PhotoCount` = '33' ,`PostalCode` = '77583' ,`RoomCount` = '6' ,`ListPrice` = '409950.00' ,`Status` = 'Active' ,`StreetName` = 'Banner Peak' ,`StreetNumber` = '2503' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosharon' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2548' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Relax in the comforts of this amazing home with a coveted in-ground private pool and outdoor living in the gated community of Sierra Vista. Loaded with upgrades and custom home features, this home rests on a spacious lot, has a bonus 2nd story game room and bathroom. This home boasts a stone elevation, luxury flooring, an office, and an extended covered patio. Try a new recipe in the kitchen, fully equipped with granite countertops, a tile backsplash, and stainless-steel appliances. Get some much-needed rest in the primary suite, complete with a walk-in closet, dual vanities, and custom shower. Residents in the gated Sierra Vista community enjoy the 4-acre Crystal Clear Lagoon and beach club. Located along the Highway 288 corridor and just 20 minutes from Downtown Houston, residents love the quick access to the Texas Medical Center and NRG Stadium. A selection of restaurants and shops can be found only minutes away. Schools in the area are zoned to Alvin ISD.' ,`Acres` = '0.2616' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SIERRA VISTA SEC 2 (A0288 HT&BRR) BLK 7 LOT 4' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '11395' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '950' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Sierra Vista Sec 2' ,`TaxAmount` = '10947' ,`TaxRate` = '3.6007' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663949695' WHERE `Matrix_Unique_ID` = '210940649' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-23T07:54:20.990' ,`MLSNumber` = '88259793' ,`ListAgentFullName` = 'Catalina Jackson' ,`ListOfficeName` = 'Houstonian Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.838925' ,`Longitude` = '-95.675350' ,`PhotoCount` = '45' ,`PostalCode` = '77084' ,`RoomCount` = '8' ,`ListPrice` = '365000.00' ,`Status` = 'Active' ,`StreetName` = 'Mountfield' ,`StreetNumber` = '18003' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2880' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 18003 Mountfield Dr. Located in the cul-de-sac of highly sought-after Deerfield Village, this elegant home has been tastefully remodeled with Luxury Vinyl Plank flooring throughout the entire first floor, and beautiful new plush carpet throughout the second floor. Enjoy your days in the spacious living room, centered by a floor-to-ceiling brick fireplace. High ceilings and large windows allow for an abundance of natural light. Conveniently placed wet bar between the living room and breakfast area. Stylish new lighting fixtures throughout. New PEX plumbing, new A/C and ductwork, fresh paint inside and out, and new SS kitchen appliances. The generous primary suite is located on the first floor. Flex space between the kitchen and the primary room can be used as formal dining or office space. The bathrooms have new vanities with quartz countertops. Deerfield Village offers great amenities: tennis courts, pool, playground, and greenbelt with lots of social activities.' ,`Acres` = '0.2158' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 10 BLK 7 DEERFIELD VILLAGE SEC 2' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '9400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '950' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'WILSON ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CYPRESS LAKES HIGH SCHOOL' ,`SchoolMiddle` = 'WATKINS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Deerfield Village Sec 02' ,`TaxAmount` = '6391' ,`TaxRate` = '2.251' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1981' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663949695' WHERE `Matrix_Unique_ID` = '210984724' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-23T06:59:15.510' ,`MLSNumber` = '78095049' ,`ListAgentFullName` = 'David Herzog' ,`ListOfficeName` = 'Texas Ally Real Estate Group,' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.834306' ,`Longitude` = '-95.434181' ,`PhotoCount` = '37' ,`PostalCode` = '77018' ,`RoomCount` = '4' ,`ListPrice` = '1497500.00' ,`Status` = 'Active' ,`StreetName` = 'Martin' ,`StreetNumber` = '1333' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4410' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Just finished! Herzog Homes proudly presents a new custom home in sought-after Oak Forest Elementary! Tastefully contemporary, the wide-open floor plan is spaciously designed for family living & entertaining. The generous Primary Suite includes a beamed high ceiling & large sitting room, 2 large custom walk in closets, romantic gas FP, and a primary bathroom draped in marble. The custom kitchen boasts Thermidor built-in appliances, quartz tops, butler\'s pantry, a wine room housed in hand-designed wrought iron. The living room is spacious with a gas FP, cabinetry, huge windows looking into a spacious fenced yard w very large covered patio. You will also notice the wide plank hardwood is almost everywhere. Atop the wood-stained stairs, lined with a custom iron railing, you will find the Primary Suite, 3 generously sized bedrooms, 2 more full baths, a walk-in laundry & a huge game room with raised ceilings. It is our pleasure to share our new property with you.' ,`Acres` = '0.168' ,`Area` = '9' ,`BuilderName` = 'Herzog Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Oak Forest East Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 6 BLK 32 OAK FOREST SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7320' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'OAK FOREST ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'BLACK MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Oak Forest Sec 03' ,`TaxAmount` = '9229' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663949695' WHERE `Matrix_Unique_ID` = '211016557' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-23T06:47:53.420' ,`MLSNumber` = '29764734' ,`ListAgentFullName` = 'Pam Shockey' ,`ListOfficeName` = 'Keller Williams Realty -SW' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.531643' ,`Longitude` = '-95.548523' ,`PhotoCount` = '47' ,`PostalCode` = '77459' ,`RoomCount` = '10' ,`ListPrice` = '449803.00' ,`Status` = 'Active' ,`StreetName` = 'Buffalo Gap' ,`StreetNumber` = '5803' ,`StreetSuffix` = '' ,`City` = 'Missouri City' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '3269' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The best of both a 1 story & a 2 story! This 1.5 story has all the Bedrooms downstairs and a huge Game room and Media Room, along with a full bathroom upstairs. The Primary suite has 2 walk in closets, Double sinks with a knee well. The Kitchen with granite countertops is open to the family room and there is a Butlers Pantry between the Kitchen and the Dining Room. The study with French doors also has a closet and could be a 4th Bedroom. Lots of natural lighting. This home backs to Flat Bank Creek, so there are no back neighbors, but never flooded. Interior has been freshly painted and carpets steam cleaned. Roof in 2021. It can close quickly. Located near Sienna Springs, Sienna Ranch, Sienna Parkway and Fort Bend Parkway for easy access in/out.' ,`Acres` = '0.1734' ,`Area` = '38' ,`BuilderName` = 'Meritage' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Levee District,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'SIENNA VILLAGE OF ANDERSON SPRINGS SEC 3-A, BLOCK 1, LOT 16' ,`LotDesciption` = 'Greenbelt,In Golf Course Community,Subdivision Lot,Water View' ,`LotSize` = '7553' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1307' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'SCHIFF ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'BAINES MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Sienna Village Of Anderson Springs' ,`TaxAmount` = '9613' ,`TaxRate` = '2.8129' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663949695' WHERE `Matrix_Unique_ID` = '211081721' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-23T06:17:39.100' ,`MLSNumber` = '2931792' ,`ListAgentFullName` = 'Lydia Davies' ,`ListOfficeName` = 'Norhill Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.919424' ,`Longitude` = '-95.173734' ,`PhotoCount` = '32' ,`PostalCode` = '77044' ,`RoomCount` = '5' ,`ListPrice` = '524000.00' ,`Status` = 'Active' ,`StreetName` = 'Bryan Creek' ,`StreetNumber` = '15711' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3817' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New fixtures and paint! Spacious and bright 5 bed in the heart of the Summerwood Community. This is the perfect family home nestled at the end of a Cul de Sac. As you walk in the front door there is a private office and dining space with wet bar. The Primary and guest bedrooms are on the first floor for convenience. The primary has a spacious closet, double sinks, and separate bath/shower. The downstairs kitchen/living area is open plan with high ceilings and lots of natural light. There is a large play/office area, media room and remAining bedrooms upstairs. The backyard is large with sheltered patio area to BBQ and relax. The Summerwood community has a full clubhouse with all the amenities, and an HEB close by.' ,`Acres` = '0.2312' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Summerwood/Lakeshore' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 48 BLK 2 SUMMERWOOD SEC 33' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '10069' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'SUMMERWOOD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'WOODCREEK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Summerwood Sec 33' ,`TaxAmount` = '11013' ,`TaxRate` = '2.7932' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663949695' WHERE `Matrix_Unique_ID` = '211170181' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-23T07:32:57.277' ,`MLSNumber` = '29991110' ,`ListAgentFullName` = 'Daisy Lopez' ,`ListOfficeName` = 'Move Up America' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.953099' ,`Longitude` = '-95.192987' ,`PhotoCount` = '12' ,`PostalCode` = '77396' ,`RoomCount` = '6' ,`ListPrice` = '399365.00' ,`Status` = 'Active' ,`StreetName` = 'Black Grouse' ,`StreetNumber` = '15859' ,`StreetSuffix` = 'Drive' ,`City` = 'Humble' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2054' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WELCOME HOME TO THE THREE STORY FAIRVIEW PLAN in beautiful Balmoral! This home is part of Chesmar\'s BRAND NEW TOWN SQUARE SERIES. The Fairview features a split level plan, step down to a guest suite or step up to open concept living with tons of natural light, spacious kitchen, and a private study and half bath tucked away. Head upstairs again to a spacious master suite and another large bedroom with ensuite bathroom. This home showcases THREE Covered Outdoor Living Space (Ground floor side patio, raised front porch, and second floor Balcony off kitchen!)+ 2 Car Attached Garage with additional storage space for hobby items or an extra long truck! Stainless Steel Appliances, 2\" Blinds, Upgraded Wood-Look Tile Flooring, on-trend quartz counters and neutral cabinets in the kitchen, Fully Sodded Yard + Landscaping Pkg all included! **HOME IS UNDER CONSTRUCTION. For more info, contact Chesmar Homes in BALMORAL community. August 2022 estimated completion.**' ,`Acres` = '' ,`Area` = '1' ,`BuilderName` = 'Chesmar Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Summerwood/Lakeshore' ,`HeatSystem` = 'Central Electric,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot:15 Block:1 Section:26' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1150' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'CENTENNIAL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'AUTUMN RIDGE MIDDLE SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Balmoral' ,`TaxAmount` = '' ,`TaxRate` = '3.55735' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663949695' WHERE `Matrix_Unique_ID` = '211293779' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-23T07:19:29.690' ,`MLSNumber` = '96445287' ,`ListAgentFullName` = 'Jeffrey Tarver' ,`ListOfficeName` = 'Keller Williams RealtyNortheast' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.837827' ,`Longitude` = '-95.254031' ,`PhotoCount` = '38' ,`PostalCode` = '77078' ,`RoomCount` = '6' ,`ListPrice` = '199990.00' ,`Status` = 'Active' ,`StreetName` = 'Richland' ,`StreetNumber` = '9137' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1752' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'On almost a 1/3 acre corner lot, this large 3 bedroom, 2 bath, 2 car garage home is fully bricked and nicely updated. The interior just received a complete paint job and new carpets. The exterior was painted about 1 year ago. The roof is about 10 years old. The large kitchen opens to the living room and dining room. Both bathrooms have granite countertops and large walk-in showers. The primary bedroom has two walk-in closets. Call today for an appointment' ,`Acres` = '0.3441' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northeast Houston' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 894 BLK 36 CHATWOOD PLACE SEC 6' ,`LotDesciption` = 'Corner' ,`LotSize` = '14990' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ELMORE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KASHMERE HIGH SCHOOL' ,`SchoolMiddle` = 'KEY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Chatwood Place' ,`TaxAmount` = '4262' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1966' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663949696' WHERE `Matrix_Unique_ID` = '211347202' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-23T07:02:38.430' ,`MLSNumber` = '39594572' ,`ListAgentFullName` = 'Maggie McFarland' ,`ListOfficeName` = 'Re/Max Pearland Home Team' ,`SellingAgentFullName` = 'Jamie Headley' ,`SellingOfficeName` = 'J Headley Properties' ,`Latitude` = '29.527237' ,`Longitude` = '-95.306287' ,`PhotoCount` = '38' ,`PostalCode` = '77584' ,`RoomCount` = '7' ,`ListPrice` = '350000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Grace' ,`StreetNumber` = '6509' ,`StreetSuffix` = 'Lane' ,`City` = 'Pearland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1852' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'COME HOME to the quiet life. Beautiful 3 bedroom, 2 bath home situated on large lot offers country charm with city convenience. Family room features wood burning fireplace with built in cabinets & shelves. Large kitchen with granite counters and breakfast bar. Generous size primary bedroom with his & her walk-in closets, en-suite bath with jacuzzi tub & separate shower. Spacious secondary bedrooms. Updated laminate wood flooring in family, study & bedrooms along with fresh interior paint. HUGE 47 x 30 detached garage can be used to store your boat, cars or a workshop. Out back you will find covered patio, mature pecan trees and vegetable garden. No HOA or City Taxes! Call today to schedule your showing!' ,`Acres` = '0.4' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'A0245 H T & B R R, TRACT 22B, ACRES 0.400' ,`LotDesciption` = 'Cleared' ,`LotSize` = '17424' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '42 - Pearland' ,`SchoolElementary` = 'MASSEY RANCH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PEARLAND HIGH SCHOOL' ,`SchoolMiddle` = 'PEARLAND JUNIOR HIGH SOUTH' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'H T & B R R' ,`TaxAmount` = '3369' ,`TaxRate` = '1.9537' ,`WaterSewer` = 'Other Water/Sewer,Septic Tank' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663949696' WHERE `Matrix_Unique_ID` = '211424957' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-23T06:00:23.207' ,`MLSNumber` = '81479197' ,`ListAgentFullName` = 'Marie Davis' ,`ListOfficeName` = 'Century 21 Realty Partners' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.131714' ,`Longitude` = '-95.522752' ,`PhotoCount` = '50' ,`PostalCode` = '77389' ,`RoomCount` = '9' ,`ListPrice` = '644900.00' ,`Status` = 'Active' ,`StreetName` = 'Carrick Bend' ,`StreetNumber` = '25211' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4111' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'If you love to entertain, this home is for you! This fantastic open floorplan is filled with natural light for a space that\'s easy to host in and you will love to show off! Gather with family in the impressive two-story family room that overlooks the kitchen. This kitchen is perfect for hosting guests with dual ovens, a huge granite island, under cabinet lighting, and more! A flex space tucked away off the breakfast nook offers so many possibilities...a study, hobby room, play area, and more! Relax and unwind in the luxurious primary suite with a spacious sitting area, spa-like bath, and walk-in closet. Upstairs, the kids will have their own space to play in the oversized game room with a homework desk and French Doors that close for sound control. Check out this amazing backyard! The extended patio offers loads of room for outdoor entertaining with grassy space left where the kids and pets can play. Sprinkler system. Close to Auburn Lakes Rec Center w a pool, splash-zone, and park!' ,`Acres` = '0.2646' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 11 BLK 1 AUBURN LAKES RETREAT SEC 1' ,`LotDesciption` = 'Cul-De-Sac,In Golf Course Community,Subdivision Lot' ,`LotSize` = '11524' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '680' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'FRENCH ELEMENTARY SCHOOL (KLEIN)' ,`SchoolHigh` = 'KLEIN OAK HIGH SCHOOL' ,`SchoolMiddle` = 'HOFIUS INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Auburn Lakes Retreat Sec 1' ,`TaxAmount` = '13431' ,`TaxRate` = '2.914' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663949696' WHERE `Matrix_Unique_ID` = '211430841' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-23T07:59:59.053' ,`MLSNumber` = '14899874' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'HomesUSA.com' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.442911' ,`Longitude` = '-95.401351' ,`PhotoCount` = '7' ,`PostalCode` = '77578' ,`RoomCount` = '9' ,`ListPrice` = '899621.00' ,`Status` = 'Active' ,`StreetName` = 'Arbor Park' ,`StreetNumber` = '4510' ,`StreetSuffix` = '' ,`City` = 'Manvel' ,`BathsFull` = '5' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4639' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 14899874 - Built by Drees Custom Homes - December completion! ~ The Briargate is a stylish home designed for your lifestyle. The open living triangle features a cozy fireplace, large kitchen island and dining room with access to the covered porch. The kitchen connects to the garage through the convenient family ready room, the ideal space to keep a busy family organized. The main level also includes a media room for family movie night or the big game.' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Drees Custom Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot - 14 / Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '14767' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1050' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Meridiana' ,`TaxAmount` = '' ,`TaxRate` = '3.67' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663949696' WHERE `Matrix_Unique_ID` = '211437888' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-23T07:42:57.590' ,`MLSNumber` = '68677990' ,`ListAgentFullName` = 'Victoria Vecchio' ,`ListOfficeName` = 'Vicki Vecchio Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.714586' ,`Longitude` = '-98.152441' ,`PhotoCount` = '8' ,`PostalCode` = '78130' ,`RoomCount` = '3' ,`ListPrice` = '369900.00' ,`Status` = 'Active' ,`StreetName` = 'Canyon' ,`StreetNumber` = '1191' ,`StreetSuffix` = 'Drive' ,`City` = 'New Braunfels' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1500' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great price reductuin out of town onwer will look at all reasonable offers!!! A great home on the \"Hill in New Braunfels! Traditional mid-century home maybe it! Surrounded by trophy oaks! Beautiful lot private feeling. Perfect to live in now, add your personal touches or investment and retire later. Roof 2019, newer high-efficiency central air and heat 2019. Open and bright floor plan oriented to the back yard. French patio doors lead to large screened in porch. Easy to view!! call today for your appointment' ,`Acres` = '0.3388' ,`Area` = '83' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'WOODLAND HEIGHTS EXTENSION 3, BLOCK 8, LOT 9' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '14760' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '142 - New Braunfels' ,`SchoolElementary` = 'SEELE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NEW BRAUNFELS HIGH SCHOOL' ,`SchoolMiddle` = 'OAKRUN MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Woodland Heights Ext 3' ,`TaxAmount` = '7032' ,`TaxRate` = '2.0267' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663949696' WHERE `Matrix_Unique_ID` = '211464853' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-23T06:47:30.083' ,`MLSNumber` = '78037300' ,`ListAgentFullName` = 'Kathryn Jean' ,`ListOfficeName` = 'TexasLife Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.215241' ,`Longitude` = '-95.661792' ,`PhotoCount` = '50' ,`PostalCode` = '77354' ,`RoomCount` = '8' ,`ListPrice` = '649990.00' ,`Status` = 'Active' ,`StreetName` = 'Acorn' ,`StreetNumber` = '33302' ,`StreetSuffix` = 'Court' ,`City` = 'Magnolia' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2738' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to 33302 Acorn Court in the gated community of Thousand Oaks, conveniently located to Tomball, The Woodlands, and the Aggie Expressway. The home is situated on an amazing, private 1.492 acre cul-de-sac lot with exceptional landscaping around the home and pool. The long driveway leads to your 3 car garage and storage building for all of your hobby and equipment storage needs. The home has a beautiful kitchen, dining room, office and primary bedroom downstairs with your game room & 3 bedrooms upstairs for a wonderful layout. The covered back porch overlooks your heated saltwater pool (brand new pump) & fenced backyard space for a serene setting. Primary bath has dual vanities, jacuzzi tub, separate shower, & walk in closet. Home also has - beautiful plantation shutters throughout, lovely ironwork on the stairs, built ins on the side of your limestone fireplace, wood floors, chef\'s kitchen, spacious laundry room. Come see what this home has to offer - it\'s beautiful!' ,`Acres` = '1.492' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'THOUSAND OAKS 01, BLOCK 3, LOT 7, ACRES 1.492' ,`LotDesciption` = 'Cleared,Cul-De-Sac,Subdivision Lot,Wooded' ,`LotSize` = '64992' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Heated,In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'MAGNOLIA PARKWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Thousand Oaks 01' ,`TaxAmount` = '7150' ,`TaxRate` = '1.8587' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663949696' WHERE `Matrix_Unique_ID` = '211469600' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-23T07:05:47.517' ,`MLSNumber` = '88022257' ,`ListAgentFullName` = 'Maggie McFarland' ,`ListOfficeName` = 'Re/Max Pearland Home Team' ,`SellingAgentFullName` = 'Misty Watkins' ,`SellingOfficeName` = 'Realty Associates' ,`Latitude` = '29.558044' ,`Longitude` = '-95.411860' ,`PhotoCount` = '29' ,`PostalCode` = '77584' ,`RoomCount` = '7' ,`ListPrice` = '314990.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Gentlebrook' ,`StreetNumber` = '12407' ,`StreetSuffix` = 'Drive' ,`City` = 'Pearland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1688' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Well kept single story home located in the master planned community of Shadow Creek Ranch. Home features beautiful laminate flooring in family room, dining and hall. Formal dining room with easy access to kitchen. Kitchen offers ample counter/cabinet space, breakfast bar & breakfast room which opens to family room. Spacious family room with fireplace and views of the lake and walking trails. Primary bedroom with walk-in closet, en-suite bath with double sinks, garden tub & separate shower. Generous size secondary bedrooms with walk-in closets. Large concrete patio, all brick exterior and no back neighbors. Short commute to downtown & medical center and within close proximity to area schools. Move-in ready! Schedule your private tour today.' ,`Acres` = '0.1377' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SHADOW CREEK RANCH SF-30 (PEARLAND), BLOCK 1, LOT 62' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '5998' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '999' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'BROTHERS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SHADOW CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MCNAIR JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Shadow Creek Ranch' ,`TaxAmount` = '6054' ,`TaxRate` = '2.9209' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663949697' WHERE `Matrix_Unique_ID` = '211558621' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-23T07:41:47.843' ,`MLSNumber` = '71488637' ,`ListAgentFullName` = 'Jennifer Zweiacker' ,`ListOfficeName` = 'Zweiacker & Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.686699' ,`Longitude` = '-96.244854' ,`PhotoCount` = '32' ,`PostalCode` = '77808' ,`RoomCount` = '11' ,`ListPrice` = '731000.00' ,`Status` = 'Active' ,`StreetName` = 'McCrae' ,`StreetNumber` = '6822' ,`StreetSuffix` = 'Lane' ,`City` = 'Bryan' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2842' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This majestic home on a landscaped 1.18 acre corner lot in Heritage Lakes Estates offers a 3-way split floor plan, exposed wooden beams & cathedral ceilings. Your inner chef will appreciate the smooth flow of the kitchen w/ neutral tones, immense eating island w/ microwave & sink, & built-in SS appliances. The relaxing living area showcases a stone fireplace flanked by built-in cabinetry w/ granite countertops. Primary suite offers a cozy sitting area & includes en suite bath w/ separate granite vanities, tiled walk-in shower w/ bench, soaking tub, & abundant natural light. 2 guest BRs share a Jack-and-Jill bathroom w/ walk-in shower, & a third guest BR has access to its own full bath w/ walk-in shower. The beadboard finished back porch overlooks the sprawling backyard oasis. 3-car garage has Stampede flooring & additional side entry & extra room for appliances & tool storage. Minutes from Bryan/College Station, this custom home offers convenience in a quiet country setting.' ,`Acres` = '1.18' ,`Area` = '61' ,`BuilderName` = 'Irongate Custom Home' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'HERITAGE LAKE ESTATES PH 1, BLOCK 2, LOT 48' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '51401' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '148 - Bryan' ,`SchoolElementary` = 'SAM HOUSTON ELEMENTARY SCHOOL (BRYAN)' ,`SchoolHigh` = 'BRYAN HIGH SCHOOL' ,`SchoolMiddle` = 'STEPHEN F. AUSTIN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Heritage Lake Estates Ph 1' ,`TaxAmount` = '12169' ,`TaxRate` = '1.7488' ,`WaterSewer` = 'Aerobic,Other Water/Sewer' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663949697' WHERE `Matrix_Unique_ID` = '211636745' --> 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','211682838','1663949697','211682838','2022-09-23T07:58:26.793','81788456','Julie Atlas Taylor','Compass RE Texas, LLC','','','29.730451','-95.508992','35','77063','11','634900.00','Active','Beverlyhill','8002','Street','Houston','2','1','2','2776','Single-Family','Amazing opportunity to own one of the newer homes in Briarmeadow. This home was custom built in 2003 by John Wawrose of Brookstone Homes and offers a very spacious, one story floor plan with 2 large bedrooms with ensuite baths and a beautiful office with ½ bath. The primary bedroom has wood floors, high ceilings and a very nice primary bathroom with a jetted tub, walk in shower and walk-in closet. The large kitchen features granite counters, stainless appliances and an oversized island open to the living area for easy entertaining. The living room has high ceilings, a gas burning fireplace & built in shelves and cabinets on each side. French doors lead to the wonderful back patio with a beautiful garden and a large grass yard behind the patio for pets or a pool. 2 car attached garage. This home has been freshly painted and has been meticulously maintained and is move in ready for the next lucky buyer.','0.2101','22','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gas Connections','1','Briarmeadow/Tanglewilde','Central Gas,Zoned','1','LT 30 BLK 14 BRIARMEADOW SEC 1','Subdivision Lot','9150','Appraisal District','','755','0','','2','Convection Oven,Double Oven,Electric Oven','0','','','Gas Cooktop','','Composition','27 - Houston','PINEY POINT ELEMENTARY SCHOOL','WISDOM HIGH SCHOOL','REVERE MIDDLE SCHOOL','Appointment Required,Request Online Appointment,Supra Keybox','Appraisal District','1','Traditional','Briarmeadow Sec 01','18459','2.3307','Public Sewer,Public Water','2003','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-23T07:30:55.787' ,`MLSNumber` = '90352147' ,`ListAgentFullName` = 'Wyman Farr' ,`ListOfficeName` = 'Fathom Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.334802' ,`Longitude` = '-95.504496' ,`PhotoCount` = '36' ,`PostalCode` = '77304' ,`RoomCount` = '7' ,`ListPrice` = '309999.00' ,`Status` = 'Active' ,`StreetName` = 'Kimberly Dawn' ,`StreetNumber` = '2605' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1931' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This Beauty is back on the market, buyer had a change of heart. This beautiful 3-bedroom 2 bath home with open concept living, offers easy access to Lake Conroe, shopping, dining and entertainment. This home is beautifully maintained and is in pristine condition. Located in a cul-de-sac with mature trees a large front porch with a fully fenced backyard for the pets and a large deck for entertaining your family and friends. The large, oversized garage has room for all your toys. With fresh paint inside and out this one is move in ready. The only thing missing is you! Make an appoint to view this one today!' ,`Acres` = '0.1661' ,`Area` = '19' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S327800 - CANYON CREEK 01, BLOCK 4, LOT 10' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '7234' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'GIESINGER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Canyon Creek' ,`TaxAmount` = '4919' ,`TaxRate` = '2.1863' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663949697' WHERE `Matrix_Unique_ID` = '211696950' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-23T06:37:00.757' ,`MLSNumber` = '3584691' ,`ListAgentFullName` = 'Alexandra McCauley' ,`ListOfficeName` = 'Keller Williams Realty - Memorial' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.672154' ,`Longitude` = '-95.516615' ,`PhotoCount` = '50' ,`PostalCode` = '77071' ,`RoomCount` = '12' ,`ListPrice` = '549000.00' ,`Status` = 'Active' ,`StreetName` = 'Braesview' ,`StreetNumber` = '7830' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3938' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to 7830 Braesview Ln, in highly sought after Braeburn Valley. This fully remodeled 2 story home, sits on an oversized lot boasting 5 beds (primary down) & 2.5 baths. This charming cottage style property is conducive to anyone looking to entertain. Formal living area overlooks the street & can easily be converted to a home office or play room. Open floor plan leads into a massive formal dining space, living area & expansive chefs kitchen. Kitchen features a center island, white shaker cabinets, quartz counter tops & ample upper & lower cabinet storage & built in pantry. Primary bed located downstairs. Secondary bedroom down as well. 3 generous sized bedrooms upstairs. Middle bedroom includes a gas log fireplace. Easily convert this room to a 2nd playroom, workout area, etc. All beds up are extremely spacious. Full bath w/tub & shower combo up. Lovely backyard w/patio & ample room to build a pool. Close proximity to hike & bike trails, entertainment, local eateries & more!' ,`Acres` = '0.2112' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Brays Oaks' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 19 BLK 1 BRAEBURN VALLEY SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'MILNE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SHARPSTOWN HIGH SCHOOL' ,`SchoolMiddle` = 'WELCH MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Braeburn Valley Sec 03' ,`TaxAmount` = '6065' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663949697' WHERE `Matrix_Unique_ID` = '211713483' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-23T06:07:00.300' ,`MLSNumber` = '55151324' ,`ListAgentFullName` = 'Debra Osborn-Camino' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.061825' ,`Longitude` = '-95.220320' ,`PhotoCount` = '30' ,`PostalCode` = '77339' ,`RoomCount` = '13' ,`ListPrice` = '259900.00' ,`Status` = 'Active' ,`StreetName` = 'Little Cedar' ,`StreetNumber` = '2074' ,`StreetSuffix` = 'Drive' ,`City` = 'Kingwood' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2115' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Love entertaining? Gardening? This backyard oasis is waiting for you! No back neighbors, Never flooded, this original owner\'s home backs up to the greenbelt, 4 areas for entertaining, a patio, a porch with a hot tub, a patio with a gazebo, & french doors to the screened garden room. Parklike backyard. Enjoy your morning coffee under the front porch by the waterfall pond with goldfish. This all brick 3/4 bedroom home with formal dining, formal living, butler\'s pantry, breakfast bar, and kitchen opens to the family room with high ceilings &breakfast room. The Kitchen has a gas cooktop, double ovens, microwave, & dishwasher. Custom blinds, windows have been replaced except for the primary room & formal living room. The seller loves natural light & had 5 sunlights installed. Gas fireplace in family rm with french doors to the back patio. Double-wide driveway with plenty of parking. 8/22 Electrical panel was replaced. Priced well below market value to reflect any paint and carpet needed' ,`Acres` = '0.1869' ,`Area` = '32' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Kingwood West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 101 BLK 37 WOODLAND HILLS VILLAGE SEC 7' ,`LotDesciption` = 'Greenbelt,Subdivision Lot,Wooded' ,`LotSize` = '8142' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'WOODLAND HILLS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KINGWOOD PARK HIGH SCHOOL' ,`SchoolMiddle` = 'KINGWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodland Hills Village' ,`TaxAmount` = '4614' ,`TaxRate` = '2.5839' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1977' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663949697' WHERE `Matrix_Unique_ID` = '211759275' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-23T07:20:14.790' ,`MLSNumber` = '35274408' ,`ListAgentFullName` = 'Scott Laird' ,`ListOfficeName` = 'Keller Williams Woodlands' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.381749' ,`Longitude` = '-95.306603' ,`PhotoCount` = '36' ,`PostalCode` = '77303' ,`RoomCount` = '8' ,`ListPrice` = '438246.00' ,`Status` = 'Active' ,`StreetName` = 'Crosby' ,`StreetNumber` = '16645' ,`StreetSuffix` = 'Street' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2174' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Make way for a little elbow room!!! NEW HOME OPPORTUNITY located on 1 ACRE LOT and just minutes from Lake Conroe and the upcoming HEB shopping center just minutes away! Enjoy a quick commute to The Woodlands with easy access to I-45. This 5 bed, 3 bath home w/ 3-CAR GARAGE is a must have!! Featuring -- an OPEN family room with HIGH 12\' ceilings and LUXURY vinyl plank flooring throughout! GOURMET granite island kitchen with breakfast bar, stainless steel appliances, TONS of cabinet space and breakfast nook! PRIVATE primary retreat with DUAL granite vanity, separate glass shower + soaking tub and WALK-IN closet! SPACIOUS secondary bedrooms AND formal dining!! GORGEOUS brick & stone elevation with front porch! Covered back patio with plenty of backyard space for entertaining all year round! Community features a super low TAX RATE and LOW HOA dues!' ,`Acres` = '1' ,`Area` = '19' ,`BuilderName` = 'First America Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Conroe Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Deer Pines 03, Block 1, Lot 12' ,`LotDesciption` = 'Cleared' ,`LotSize` = '43800' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'AUSTIN ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CANEY CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MOORHEAD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Deer Pines' ,`TaxAmount` = '' ,`TaxRate` = '1.94' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663949698' WHERE `Matrix_Unique_ID` = '211771877' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-23T06:42:55.463' ,`MLSNumber` = '10559664' ,`ListAgentFullName` = 'Emily Dieckmann' ,`ListOfficeName` = 'Keller Williams Realty C. P.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.434509' ,`Longitude` = '-98.010961' ,`PhotoCount` = '40' ,`PostalCode` = '78645' ,`RoomCount` = '5' ,`ListPrice` = '715000.00' ,`Status` = 'Active' ,`StreetName` = 'High' ,`StreetNumber` = '21200' ,`StreetSuffix` = 'Drive' ,`City` = 'Lago Vista' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2439' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'VIEWS!! This beautiful homes sits on over half an acre and offers spectacular lake and hill country views! When you walk in you are greeted with amazing Hill country views, then once you venture out onto the large covered balcony you can take in views of lake Travis! This home has an open concept living and eat-in kitchen with a separate formal dining room for those special occasions. The master and laundry are located on the main level for convenience. Downstairs you have another living area and two more bedrooms with a full bathroom. You can also access the peaceful screened in porch, the perfect place to take in the breathtaking sunsets or sunrises!The lakeside community of Lago Vista includes 9 private waterfront parks, boat ramps, pool, tennis courts, gym, playgrounds and more!' ,`Acres` = '0.6984' ,`Area` = '83' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 1730A COUNTRY CLUB ESTATES SEC 8 AMENDED PLAT OF LOTS 17' ,`LotDesciption` = 'Other' ,`LotSize` = '30422' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '150' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '114 - Lago Vista' ,`SchoolElementary` = 'LAGO VISTA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAGO VISTA HIGH SCHOOL' ,`SchoolMiddle` = '' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Country Club Estates Sec 8 Ame' ,`TaxAmount` = '9772' ,`TaxRate` = '2.4782' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663949698' WHERE `Matrix_Unique_ID` = '211850971' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-23T07:32:00.290' ,`MLSNumber` = '39611334' ,`ListAgentFullName` = 'Daisy Lopez' ,`ListOfficeName` = 'Move Up America' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.953099' ,`Longitude` = '-95.192987' ,`PhotoCount` = '34' ,`PostalCode` = '77396' ,`RoomCount` = '5' ,`ListPrice` = '320865.00' ,`Status` = 'Active' ,`StreetName` = 'Black Grouse' ,`StreetNumber` = '15847' ,`StreetSuffix` = 'Drive' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1474' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WELCOME HOME TO THE STOREYBROOKE PLAN in beautiful Balmoral! This home is part of Chesmar\'s BRAND NEW TOWN SQUARE SERIES. The Storybook features a beautiful open concept second-floor living and kitchen space with tons of natural light and windows. This home showcases TWO Covered Outdoor Living Space (Ground floor and second floor Balcony off living room!)+ 2 Car Attached Garage. Stainless Steel Appliances, 2\" Blinds, Upgraded wood-look tile, on-trend white quartz counters in the kitchen, Sprinkler System, Fully Sodded Yard + Landscaping Pkg all included! **HOME IS UNDER CONSTRUCTION. For more info, contact Chesmar Homes in BALMORAL community. OCTOBER 2022 estimated completion.**' ,`Acres` = '' ,`Area` = '1' ,`BuilderName` = 'Chesmar Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Summerwood/Lakeshore' ,`HeatSystem` = 'Central Electric,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot:12 Block:1 Section:26' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1150' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'CENTENNIAL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'AUTUMN RIDGE MIDDLE SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Balmoral' ,`TaxAmount` = '' ,`TaxRate` = '3.55735' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663949698' WHERE `Matrix_Unique_ID` = '211965507' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-23T06:15:57.653' ,`MLSNumber` = '89428996' ,`ListAgentFullName` = 'Judith Lisac' ,`ListOfficeName` = 'Redfin Corporation' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.543146' ,`Longitude` = '-96.097297' ,`PhotoCount` = '50' ,`PostalCode` = '77435' ,`RoomCount` = '11' ,`ListPrice` = '534000.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 278' ,`StreetNumber` = '17108' ,`StreetSuffix` = '' ,`City` = 'East Bernard' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2864' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'You\'re warmly welcomed the moment you step inside this stunning 3 Bedroom, 2 bath better than new East Bernard home with ADU potential! The unique open floor plan is ideal for entertaining guests! The inviting living sits at the heart of the home with access to the amazing backyard. The modern eat-in kitchen offers built-in stainless steel appliances, a Texas-size island with seating, designer touches, soft closing cabinets, and a walk-in pantry. Elegant formal dining with gorgeous built-ins and crown molding. Large secluded primary suite with an enviable ensuite bath and private access to the back patio. Spacious home office. The picturesque backyard oasis with a sparkling pool, spa, and large covered patio provides additional outdoor living and entertaining space. Extra features include an RV pad, security system, updated pool controller, well pump motor, and security lighting. Quick 20 minute trip to the city for an easy commute. New drainage installed to move any unwanted water.' ,`Acres` = '1.594' ,`Area` = '55' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas,Heat Pump' ,`HOAMandatory` = '0' ,`Legal` = 'A20027 ABST.27 TRACT 21A-7H' ,`LotDesciption` = 'Corner' ,`LotSize` = '69435' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '145 - East Bernard' ,`SchoolElementary` = 'EAST BERNARD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'EAST BERNARD HIGH SCHOOL' ,`SchoolMiddle` = 'EAST BERNARD J H' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Abstract 27' ,`TaxAmount` = '7559' ,`TaxRate` = '1.9194' ,`WaterSewer` = 'Aerobic,Well' ,`YearBuilt` = '1990' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663949698' WHERE `Matrix_Unique_ID` = '211967581' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-23T07:33:31.287' ,`MLSNumber` = '81378841' ,`ListAgentFullName` = 'Daisy Lopez' ,`ListOfficeName` = 'Move Up America' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.953285' ,`Longitude` = '-95.192987' ,`PhotoCount` = '29' ,`PostalCode` = '77396' ,`RoomCount` = '6' ,`ListPrice` = '376040.00' ,`Status` = 'Active' ,`StreetName` = 'Black Grouse' ,`StreetNumber` = '15843' ,`StreetSuffix` = 'Drive' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1907' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WELCOME HOME TO THE THREE STORY HAWKINS PLAN in beautiful Balmoral! Enter the Hawkins foyer with half bath and large flex room with double doors that could be a 4th bedroom, home office, playroom, or whatever you might need it to be! Then step up to open concept living with tons of natural light, spacious kitchen, and your primary bedroom located on the main central floor. Head upstairs again to 2 additional Bedrooms and hall Bathroom. This home showcases TWO Covered Outdoor Living Space (Ground floor and second floor Balcony off kitchen!)+ 2 Car Attached Garage with additional storage space for hobby items or an extra long truck! Stainless Steel Appliances, 2\" Blinds, Upgraded Wood-Look Tile Flooring, on-trend grey quartz counters and white cabinets in the kitchen, Fully Sodded Yard + Landscaping Pkg all included! **HOME IS UNDER CONSTRUCTION. For more info, contact Chesmar Homes in BALMORAL community. OCT/NOV 2022 est. completion.**' ,`Acres` = '' ,`Area` = '1' ,`BuilderName` = 'Chesmar Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Summerwood/Lakeshore' ,`HeatSystem` = 'Central Electric,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot:11 Block:1 Section:26' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1150' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'CENTENNIAL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'AUTUMN RIDGE MIDDLE SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Balmoral' ,`TaxAmount` = '' ,`TaxRate` = '3.55735' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663949698' WHERE `Matrix_Unique_ID` = '211972566' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-23T07:33:43.890' ,`MLSNumber` = '47105336' ,`ListAgentFullName` = 'Tina Hagger' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = 'Bennie Chukwurah' ,`SellingOfficeName` = 'Compass Realty & Associates LL' ,`Latitude` = '29.677118' ,`Longitude` = '-95.640398' ,`PhotoCount` = '50' ,`PostalCode` = '77083' ,`RoomCount` = '8' ,`ListPrice` = '340000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Andrea Way Lane' ,`StreetNumber` = '14431' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2716' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to this spacious 4/5 bedroom and 2.5 bath fully updated house located on a cul-de-sac street in the Fort Bend School District! Many upgraded and newly updated features include new paint throughout, new granite counters, new stove and vent hood, new water heater, new lighting, and new blinds. The huge game room has been converted to a room with closets so it can be used as a 5th bedroom. The fence was upgraded from a 6 foot fence to a 7 foot fence. The 2 A/C units are approximately 5-6 years old. The roof is approximately 12 years old. There is a side entry door in the garage for convenience. Home features huge back yard large enough for family pool! Sub-division has newly installed fiber optics! Conveniently located near Hwy 6. Easy access to US 59 via Westpark Toll Road and I-10 via Hwy 6. OPEN HOUSE ON SUNDAY FROM 2-4 PM.' ,`Acres` = '' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Kingsbridge Park Sec 3, Block 1, Lot 22' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6321' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '575' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'FLEMING ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'KEMPNER HIGH SCHOOL' ,`SchoolMiddle` = 'HODGES BEND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Kingsbridge Park' ,`TaxAmount` = '5569' ,`TaxRate` = '2.33' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663949698' WHERE `Matrix_Unique_ID` = '211981984' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-23T06:35:47.810' ,`MLSNumber` = '87788502' ,`ListAgentFullName` = 'Cyril Okeke' ,`ListOfficeName` = 'Keller Williams Hou Preferred' ,`SellingAgentFullName` = 'Cyril Okeke' ,`SellingOfficeName` = 'Keller Williams Hou Preferred' ,`Latitude` = '29.748278' ,`Longitude` = '-95.032621' ,`PhotoCount` = '33' ,`PostalCode` = '77520' ,`RoomCount` = '9' ,`ListPrice` = '249900.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Bayway' ,`StreetNumber` = '5701' ,`StreetSuffix` = 'Drive' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2019' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A beautiful 3 bedrooms/2 baths home on a bulkheaded, wooded, waterfront a little over an acre awaits you to make it the home of your dreams. The dwelling sits at the end of a deep front yard shaded by pecan trees. The back yard offers sweeping views of Scott Bay, the San Jacinto Monument, and the Fred Hartman Bridge. The interior offers spacious rooms, wood floors and ceilings, a breakfast alcove with 2 china cabinets, a wood burning fireplace, and so much more. So don’t delay; make an appointment to see this lovely property to be sold AS IS today!' ,`Acres` = '1.0399' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 6 BLK K WOOSTER B & I' ,`LotDesciption` = 'Subdivision Lot,Waterfront' ,`LotSize` = '45300' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'TRAVIS ELEMENTARY SCHOOL (GOOSE CREEK)' ,`SchoolHigh` = 'LEE HIGH SCHOOL (GOOSE CREEK)' ,`SchoolMiddle` = 'BAYTOWN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Brown & Iddings' ,`TaxAmount` = '3773' ,`TaxRate` = '2.97' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1941' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663949699' WHERE `Matrix_Unique_ID` = '212016488' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-23T07:23:39.757' ,`MLSNumber` = '81682585' ,`ListAgentFullName` = 'Renee Davy' ,`ListOfficeName` = 'The Davy Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.761835' ,`Longitude` = '-95.532065' ,`PhotoCount` = '50' ,`PostalCode` = '77024' ,`RoomCount` = '15' ,`ListPrice` = '2995000.00' ,`Status` = 'Active' ,`StreetName` = 'Bayhurst' ,`StreetNumber` = '11842' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '5' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '6206' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Majestic Bunker Hill Estate tucked on just under 20,000sqft lot at the quiet end of cul-de-sac. Traditional elegance w/open feel. Gracious entry, open formals, perfect for entertaining w/wine grotto, ELEVATOR/ 2 BEDS DOWN/Executive Study/Formals/Wine grotto/Luxurious private Primary w/elegant marble bath, walk-in shower/soaking tub & private access to pool. Fully equip\'d Thermador Kitchen +Subzero. Dual staircases to large Game room w/billiard table/Large Theater Lounge w/all seating, drinks bar, high def equip + full bath/3 more large bedrooms w/2 baths & Home office. Outdoor living, expansive outdoor entertaining, lounging & dining areas surrounding heated pool & spa, summer kitchen/climate controlled interior storage prvt gate, 3 car garage, GENERATOR, NEW ROOF, incredible storage, award winning trifecta schools - Bunker Hill Elementary, Memorial Middle & MHS. Feel safe & secure w/ the Village Police. One of the finest Executive family estates available in the Memorial Villages.' ,`Acres` = '0.4471' ,`Area` = '23' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Memorial Villages' ,`HeatSystem` = 'Central Electric,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'LT 8 BLK A BAYHURST OAKS' ,`LotDesciption` = 'Corner,Cul-De-Sac,Subdivision Lot,Wooded' ,`LotSize` = '19475' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum,Composition,Other' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'BUNKER HILL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'MEMORIAL MIDDLE SCHOOL (SPRING BRANCH)' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Bunker Hill' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663949699' WHERE `Matrix_Unique_ID` = '212022271' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-23T07:07:58.743' ,`MLSNumber` = '59158108' ,`ListAgentFullName` = 'Kelly Kelley' ,`ListOfficeName` = 'RE/MAX Leading Edge' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.219974' ,`Longitude` = '-94.936790' ,`PhotoCount` = '48' ,`PostalCode` = '77554' ,`RoomCount` = '8' ,`ListPrice` = '1625000.00' ,`Status` = 'Active' ,`StreetName` = 'Moyenne' ,`StreetNumber` = '13419' ,`StreetSuffix` = 'Place' ,`City` = 'Galveston' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2834' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Sprawling waterfront home has been expertly crafted for the avid entertainer whether you want to sip cocktails poolside, take in a stunning sunset from your gazebo or take the boat out for a day on the water. Impressive open floor plan includes a sprawling living area, separate dining, gourmet kitchen, office/den & 4 large bedrooms with 4 full bathrooms. Lower level houses the entertainment hub with plenty of room for gathering with friends & family poolside, sidle up to the built-in bar, relax by the fire pit or dine outdoors on warm summer nights. Up above a jetty takes you past the glistening pool & down to your gazebo. Perfect place to relax with a glass of wine at the end of a long day out on the boat. A boat lift is housed below along with a charming deck where you can sit with your morning coffee & watch the canal come to life as the boaters take just minutes to get to West Bay. Freshly painted interior. This must see home conveys furnished.' ,`Acres` = '0.3868' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'West End' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 121 PAGE 44 LOT 5 BLK 6 PIRATES COVE SEC 6 REPLAT' ,`LotDesciption` = 'In Golf Course Community,Water View,Waterfront' ,`LotSize` = '16850' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '765' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Laffites Cove' ,`TaxAmount` = '' ,`TaxRate` = '2.03' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663949699' WHERE `Matrix_Unique_ID` = '212093495' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-23T07:26:44.753' ,`MLSNumber` = '88080551' ,`ListAgentFullName` = 'Ann Bragg' ,`ListOfficeName` = 'Bayou, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.460982' ,`Longitude` = '-95.079685' ,`PhotoCount` = '29' ,`PostalCode` = '77539' ,`RoomCount` = '9' ,`ListPrice` = '335000.00' ,`Status` = 'Active' ,`StreetName` = 'Olde Oaks' ,`StreetNumber` = '709' ,`StreetSuffix` = 'Drive' ,`City` = 'Dickinson' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2242' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous 4 bedroom 2 bath 2 car garage in the sought after Sherwood Forest West Subdivision in the heart of Dickinson. The open floor plan is perfect for entertaining with a huge living room with wet bar, beautiful kitchen, formal dining room, breakfast area over looking the amazing backyard. Primary bathroom proovides disabled access. This one won\'t last long. Call today for a private tour of this home.' ,`Acres` = '0.2991' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Dickinson' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 19 PERRY & AUSTIN SUR BLK 5 LOT 1 SHERWOOD FOREST WEST' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '13028' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '144' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'BAY COLONY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'DUNBAR MIDDLE SCHOOL (DICKINSON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sherwood Forest West' ,`TaxAmount` = '4960' ,`TaxRate` = '2.5214' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663949699' WHERE `Matrix_Unique_ID` = '212097663' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-23T07:21:08.047' ,`MLSNumber` = '24879783' ,`ListAgentFullName` = 'Alisha Osborne' ,`ListOfficeName` = 'First Millennium Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.531222' ,`Longitude` = '-95.543413' ,`PhotoCount` = '19' ,`PostalCode` = '77459' ,`RoomCount` = '6' ,`ListPrice` = '375000.00' ,`Status` = 'Active' ,`StreetName` = 'Golden Harbor' ,`StreetNumber` = '8118' ,`StreetSuffix` = '' ,`City` = 'Missouri City' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2457' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Breathtaking lakefront 1 1/2 story, 2457 square foot Plantation home! 3 spacious bedrooms, formal dining with built-ins, 2 1/2 baths, hardwoods, ceramic tile and designer paint colors, high ceilings through-out, upstairs bonus room with powder bath is perfect for home office or gameroom. New A/C & water heater & gorgeous 8k deck added so you can sit out over the water! New interior paint & flooring coming at the end of September! Covered back porch, Decorative brick accent on exterior. Premium lot...this is a must see!' ,`Acres` = '0.1822' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SIENNA VILLAGE OF ANDERSON SPRINGS SEC 1-A, BLOCK 4, LOT 3' ,`LotDesciption` = 'Subdivision Lot,Water View,Waterfront' ,`LotSize` = '7936' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1280' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'SCHIFF ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'BAINES MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Sienna Village Of Anderson Spgs Sec 1-A' ,`TaxAmount` = '7922' ,`TaxRate` = '2.8129' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663949699' WHERE `Matrix_Unique_ID` = '212105534' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-23T07:37:01.837' ,`MLSNumber` = '27985996' ,`ListAgentFullName` = 'Kiriaki Koymarianos' ,`ListOfficeName` = 'Keller Williams Woodlands' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.102193' ,`Longitude` = '-95.389491' ,`PhotoCount` = '28' ,`PostalCode` = '77386' ,`RoomCount` = '8' ,`ListPrice` = '400000.00' ,`Status` = 'Active' ,`StreetName` = 'Peper Hollow' ,`StreetNumber` = '28319' ,`StreetSuffix` = 'Lane' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2874' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 1 story 4 bedroom, 2 bath home on a corner lot in the sought-out neighborhood of Sprig Trails. Impressive entry with crown molding and an open-concept living floor plan. The kitchen comes with granite countertops, a breakfast area, and an abundance of cabinet and counter space. The primary suite is large w/ spacious walk-in closet. Great floor plan featuring an open concept living and large primary suite w/Texas sized closet, separate shower & jetted garden tub, family room w/ fireplace, and formal dining. The Study w/ a large walk-in closet can be used as a 5th bedroom. In the Primary Bath, you will find a separate his and hers vanity, a separate shower, and a jetted tub you can relax in. The Study w/ a large walk-in closet can be used as a 5th bedroom. Great amenities include Tennis, Multi-Sport Court, multiple Playgrounds, and scenic Jogging Paths with Exercise Stations. Conveniently located close to shopping/dining options and great schools. Come home to Spring Trails!' ,`Acres` = '0.192' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SPRING TRAILS 04, BLOCK 2, LOT 1' ,`LotDesciption` = 'Corner' ,`LotSize` = '8365' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '720' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Wood Shingle' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'BROADWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GRAND OAKS HIGH SCHOOL' ,`SchoolMiddle` = 'YORK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Spring Trails 04' ,`TaxAmount` = '7177' ,`TaxRate` = '2.6137' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663949700' WHERE `Matrix_Unique_ID` = '212111341' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-23T07:49:37.243' ,`MLSNumber` = '53291535' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'Highland Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.444538' ,`Longitude` = '-95.401850' ,`PhotoCount` = '12' ,`PostalCode` = '77578' ,`RoomCount` = '12' ,`ListPrice` = '714990.00' ,`Status` = 'Active' ,`StreetName` = 'Coronado' ,`StreetNumber` = '4614' ,`StreetSuffix` = '' ,`City` = 'Iowa Colony' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3926' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 53291535 - Built by Highland Homes - October completion! ~ This beautiful model home floor plan boasts a grand entryway with two bedrooms, study, and the media downstairs. The open kitchen with cabinets galore is perfect for entertaining. With two toned cabinets, a stainless steel venthood and backsplash going u to the ceiling, it\'s a dream kitchen. On a cul de sac street with no back neighbors provide the serenity everyone is in search for!' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'L 36 B 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10198' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1050' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Meridiana 65s' ,`TaxAmount` = '' ,`TaxRate` = '3.63' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663949700' WHERE `Matrix_Unique_ID` = '212162306' --> 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','212192254','1663949700','212192254','2022-09-23T07:37:19.870','11716692','Roman Rodriguez','Green Residential','','','29.726950','-95.502448','41','77063','9','535000.00','Active','Freshmeadows','3515','Drive','Houston','2','1','3','2293','Single-Family','Spectacular gem located in the Briarmeadow subdivision. This home has new roof, new A/C, foundation with warranty ($125 to transfer), new flooring, updated bathroom, and other details that you will love. As you enter the home, you are greeted by an elegant den that flows into the large formal dining space. New hand-sculpted wood flooring gives a timeless aesthetic to this space. The living room has beautiful high vaulted beamed ceilings, a cozy brick fireplace (gas or wood), original wood paneling, and built in shelving. The kitchen walls were opened to create an open concept layout and added breakfast bar. Kitchen has been fully renovated with 2 toned cabinetry, granite countertops, gorgeous backsplash, and new appliances. New tile flooring has been installed throughout the home. Guest bedroom was converted into second primary bedroom. This room has been opened to have a seating space and opens into the renovated bathroom. This property is a must see and will not last long!','0.2388','22','','','Electric Dryer Connections,Washer Connections','','Estate,Sellers Disclosure','1','','1','Briarmeadow/Tanglewilde','Central Gas','1','LT 1 BLK 17 BRIARMEADOW SEC 1 PAR R/P','Corner','10400','Appraisal District','','762','0','','3','Electric Oven','0','','','Gas Cooktop','','Composition','27 - Houston','PINEY POINT ELEMENTARY SCHOOL','WISDOM HIGH SCHOOL','REVERE MIDDLE SCHOOL','Appointment Required','Appraisal District','1','Traditional','Briarmeadow Sec 1 Pt Rp','9258','2.3307','Public Sewer,Public Water','1967','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','212228341','1663949700','212228341','2022-09-23T07:04:47.583','48730387','Miriam Brassfield','BHGRE Gary Greene','','','30.293567','-95.556447','45','77316','6','335900.00','Active','Brow Pines','409','Court','Montgomery','2','0','3','1500','Single-Family','OPEN HOUSE SUNDAY SEPTEMBER 25 2-4 LOCATION!!!! Backs to a lush greenspace. What a wonderful backdrop to your backyard! Beautiful home that shows like a model. Wood look tile floor in entry, kitchen and living area. Beautiful granite counters. Gas range!\r\nWalls of windows letting in lots of natural light. 3 bedrooms with wonderful closets. Yard is beautifully landscaped. Backyard patio has been extended.\r\nAll of this in highly sought out Woodforest.','0.1321','39','Perry','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','','0','Conroe Southwest','Central Gas','1','S965276 - WOODFOREST 76, BLOCK 2, LOT 12','Subdivision Lot,Wooded','5754','Appraisal District','','1265','0','','2','Single Oven','0','','','Gas Range','','Composition','11 - Conroe','STEWART ELEMENTARY SCHOOL (CONROE)','CONROE HIGH SCHOOL','PEET JUNIOR HIGH SCHOOL','Appointment Required,Supra Keybox','Appraisal District','1','Traditional','Woodforest 76','4273','1.8488','Public Sewer,Water District','2020','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-23T06:30:09.793' ,`MLSNumber` = '27331104' ,`ListAgentFullName` = 'Tod Franklin' ,`ListOfficeName` = 'DFWCityhomes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.181760' ,`Longitude` = '-95.157527' ,`PhotoCount` = '48' ,`PostalCode` = '77357' ,`RoomCount` = '11' ,`ListPrice` = '630000.00' ,`Status` = 'Active' ,`StreetName` = 'Colosseum' ,`StreetNumber` = '2642' ,`StreetSuffix` = 'Court' ,`City` = 'New Caney' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '3306' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous bedroom home with so much space! Move in ready! Beautiful granite counter tops, Harwood floors, tile and carpet throughout out the home. Each bedroom has its own walk-in closet and ceiling fans. So much storage space! Very well kept and clean. The yard is landscaped up front and partial in the back. There is so much potential you could install a pool. There is a back up generator that provides for the entire house. Two AC/heat units.' ,`Acres` = '0.4711' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Porter/New Caney East' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'Roman Forest 02, BLOCK 4, LOT 6' ,`LotDesciption` = 'Corner,Subdivision Lot,Wooded' ,`LotSize` = '20520' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Built Up,Composition,Wood Shingle' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'DOGWOOD ELEMENTARY SCHOOL (NEW CANEY)' ,`SchoolHigh` = 'NEW CANEY HIGH SCHOOL' ,`SchoolMiddle` = 'KEEFER CROSSING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Ranch' ,`Subdivision` = 'Roman Forest SEC #02' ,`TaxAmount` = '9848' ,`TaxRate` = '2.9064' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663949700' WHERE `Matrix_Unique_ID` = '212284039' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-23T06:52:01.350' ,`MLSNumber` = '73603318' ,`ListAgentFullName` = 'Livee Gao' ,`ListOfficeName` = 'RE/MAX Fine Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.775583' ,`Longitude` = '-95.418632' ,`PhotoCount` = '14' ,`PostalCode` = '77007' ,`RoomCount` = '6' ,`ListPrice` = '419000.00' ,`Status` = 'Active' ,`StreetName` = 'Inker' ,`StreetNumber` = '5408' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2313' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful updated, well-kept home on corner lot. Spacious 2 story home has 3 bdrm at 1st floor. living area and master at 2nd floor. Granite countertop. Wood floor. New master shoer, floor. 9/2022 water heater, kitchen sink, disposal, carpet and paint. 2 car garage. Washer, dryer and refr, are included.' ,`Acres` = '0.0562' ,`Area` = '16' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Rice Military/Washington Corridor' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 9 BLK 1 CONTEMPORARY PARK SEC 3' ,`LotDesciption` = 'Corner' ,`LotSize` = '2450' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'MEMORIAL ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Contemporary Park' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663949700' WHERE `Matrix_Unique_ID` = '212335427' --> 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','212401772','1663949700','212401772','2022-09-23T07:56:54.070','45490176','Jamie Kastens','Keller Williams Realty -SW','','','29.644773','-95.696546','50','77407','15','1550000.00','Active','Westmoor','11534','Drive','Richmond','7','0','6','5254','Single-Family','ONE-OF-A-KIND J.Patrick LUXURY HOME w/ 6 BR & 7 full baths. Move-in ready, North-facing, w/ tons of amenities including a space for wine enthusiasts, a private home office, and a relaxing self-cleaning pool equipped with a jacuzzi, firepit, and heated for cooler Texas nights. Perfect for entertaining! There\'s no back neighbors, a gourmet outdoor kitchen w/ broiler, 2 ceiling fans, & travertine deck. The wide open floorplan has 2-story ceilings in the living room w/ plenty of natural light, motorized blinds, built-in shelves, & a stone-front fireplace. The modern chef\'s kitchen has a water softener, Quartz countertops, & sleek under-cabinet lighting. The opulent owner\'s suite is huge, with a bay window & sitting area. One room was converted into a huge walk-in closet or \"She Shed.\" There is a spacious game room and media room w/ projector, large screen, & 5-point surround sound. It\'s zoned to top A-rated schools in Fort Bend ISD. The 20,000+ sq. ft lot is among the largest in Aliana.','0.473','37','JPatrick','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Gas Connections','1','Sugar Land West','Central Gas','1','ALIANA SEC 51, BLOCK 2, LOT 1','Subdivision Lot','20603','Appraisal District','','1250','0','','3','Gas Oven','1','Gunite','','Gas Cooktop','','Composition','19 - Fort Bend','MALALA ELEMENTARY SCHOOL','AUSTIN HIGH SCHOOL (FORT BEND)','GARCIA MIDDLE SCHOOL (FORT BEND)','Appointment Required','Appraisal District','2','Contemporary/Modern,Traditional','Aliana Sec 51','19515','3.0329','Water District,Well','2019','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-23T07:33:02.347' ,`MLSNumber` = '72777060' ,`ListAgentFullName` = 'Darren Tidwell' ,`ListOfficeName` = 'Keller Williams Realty - Clear Lake/ NASA' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.447706' ,`Longitude` = '-95.102967' ,`PhotoCount` = '24' ,`PostalCode` = '77539' ,`RoomCount` = '7' ,`ListPrice` = '283000.00' ,`Status` = 'Active' ,`StreetName` = 'Hidden Colony' ,`StreetNumber` = '6712' ,`StreetSuffix` = 'Lane' ,`City` = 'Dickinson' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1696' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'OPEN HOUSES THIS SATUDAY 12-3PM & SUNDAY 1-4pm. Immaculate 3/2/2 1-story with very nice updates throughout - 2021 new roof & HVAC, 2020 - new toilets, fence, hot water heater, garage door opener & keypad, 2022 new blinds and mailbox. Enter this home and step on to the wood-look tile that runs through all the main living areas. The kitchen is nicely updated with granite countertops and stainless steel appliances. Formal dining. Master bedroom has a very nice en suite bath, garden tub and a walk-in closet. 2 additional bedrooms share a guest bath that is also nicely updated. Oversized back patio for grilling and entertainment along with nice yard and optional playground set to stay. Close proximity to community pool/park that is undergoing expansion. Close proximity to shopping and restaurants. This home shows pride of ownership and is immaculate!' ,`Acres` = '0.1377' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'BAY COLONY POINTE WEST SEC 2 (2005) ABST 19, BLOCK 2, LOT 22' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '560' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'CALDER ROAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'LOBIT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Bay Colony Pointe West' ,`TaxAmount` = '6144' ,`TaxRate` = '3.4497' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663949700' WHERE `Matrix_Unique_ID` = '212437673' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-23T07:53:09.073' ,`MLSNumber` = '91412096' ,`ListAgentFullName` = 'Jeremy Foreman' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.816276' ,`Longitude` = '-95.791370' ,`PhotoCount` = '25' ,`PostalCode` = '77493' ,`RoomCount` = '5' ,`ListPrice` = '399900.00' ,`Status` = 'Active' ,`StreetName` = 'Morrison' ,`StreetNumber` = '24107' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2840' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 24107 Morrison Lane! Located in the highly sought-after community of Katy Oaks, this spacious home has it all with 3 bedrooms, 2.5 bathrooms, home office, game room and an open floor plan! The Primary bedroom is located upstairs and features a massive walk-in closet and en suite bathroom with double vanities, separate shower and soaking tub. The second full bath also has a rare double vanity and oversized shower! The extended back patio is definitely a MUST SEE! Katy Oaks offers fabulous community amenities including a dog park and beautiful playground with pond and stream, just steps from your front door! Nearby you\'ll find the Mason Creek South Hike and Bike Trail, baseball and soccer fields, and tons of restaurants and shopping options. The Grand Parkway and I-10 are just minutes away and provide an easy commute no matter where you are headed! This property is also zoned to great schools within award-winning Katy ISD.' ,`Acres` = '0.1469' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 89 BLK 3 KATY OAKS SEC 1 AMEND' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '625' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'WINBORN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Katy Oaks Sec 1' ,`TaxAmount` = '6823' ,`TaxRate` = '2.6083' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663949700' WHERE `Matrix_Unique_ID` = '212464957' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-23T06:57:56.917' ,`MLSNumber` = '96173105' ,`ListAgentFullName` = 'Frederick Richards' ,`ListOfficeName` = 'Keller Williams Realty - Memorial' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.829595' ,`Longitude` = '-95.530931' ,`PhotoCount` = '29' ,`PostalCode` = '77080' ,`RoomCount` = '7' ,`ListPrice` = '364000.00' ,`Status` = 'Active' ,`StreetName` = 'Springview' ,`StreetNumber` = '9655' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1566' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Newly renovated 3 bed 2 bath traditional home positioned in a quiet community minutes from the beltway. This home has nice sized rooms (room sizes are estimates) and backyard. Upgrades include new countertops in the kitchen, new kitchen cabinets, new oven, brand new carpet throughout the home, hot water heater, internal paint, new vinyl plank flooring, new windows, and upgraded fixtures. AC added 2 years ago with updated ducts, and roofing is 5 years old. This beginner home for the ideal family will provide the comfort of a homeowner. Great location for anyone who is looking to reside in the Spring Branch area. Schedule your showing today. This beautiful home won’t last long on the market.' ,`Acres` = '0.1567' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 3 BLK 4 KEMPWOOD NORTH' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6825' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'TERRACE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTHBROOK HIGH SCHOOL' ,`SchoolMiddle` = 'NORTHBROOK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Kempwood North' ,`TaxAmount` = '5278' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663949701' WHERE `Matrix_Unique_ID` = '212532377' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-23T07:54:02.020' ,`MLSNumber` = '44626498' ,`ListAgentFullName` = 'Suzy Pittman' ,`ListOfficeName` = 'Texas Made Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.531197' ,`Longitude` = '-95.198183' ,`PhotoCount` = '28' ,`PostalCode` = '77546' ,`RoomCount` = '8' ,`ListPrice` = '339900.00' ,`Status` = 'Active' ,`StreetName` = 'Glenlea' ,`StreetNumber` = '414' ,`StreetSuffix` = 'Drive' ,`City` = 'Friendswood' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1650' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'STUNNING recently RENOVATED 1-story cozy home nestled in the highly desirable subdivision of Harwood. The home features 3 bedrooms, 2 bathrooms, open plan family room, kitchen and breakfast area. The formal dining room could also make a home study or playroom. The upgraded kitchen is every chef\'s dream with recent STAINLESS STEEL appliances, PURE WHITE QUARTZ countertops and gorgeous Shaker cabinets. LUXURY VINYL PLANK flooring continues throughout the main living areas. The breakfast area has a large bay window and is spacious and cheerful. All windows and doors have been replaced including the garage doors. All bedroom have plush carpet and both bathrooms have Quartz countertops with upgraded hardware. The backyard has a patio area which is ideal for summer barbecues. ROOF AND HOT WATER HEATER WERE REPLACED in June 2022! The home is located near I45 with easy access to downtown Houston and Galveston Island. This BEAUTIFULLY UPGRADED home will sell fast so make an appointment today!' ,`Acres` = '0.1703' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Friendswood' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 151 S MCKISSICK SUR LOT 16 BLK 2 HARWOOD' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7420' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '20 - Friendswood' ,`SchoolElementary` = 'WESTWOOD ELEMENTARY SCHOOL (FRIENDSWOOD)' ,`SchoolHigh` = 'FRIENDSWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'FRIENDSWOOD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Harwood' ,`TaxAmount` = '4547' ,`TaxRate` = '2.2832' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1971' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663949701' WHERE `Matrix_Unique_ID` = '212556005' --> 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','212604372','1663949701','212604372','2022-09-23T06:19:39.763','97512502','BJ Smith','Compass RE Texas, LLC','','','29.518784','-95.041477','27','77573','9','395000.00','Active','Ravens Lake Cir','3119','Circle','League City','2','0','4','2125','Single-Family','Welcome Home! This beautiful one story home is tucked away on a quiet street in the sought after neighborhood of South Shore Village. The spacious family room has custom built-in cabinetry & a fireplace with windows looking out onto the backyard, pool & hot tub. This split plan home is perfect. The expansive cabinet filled kitchen with granite counter tops opens to the living room making it the ideal layout for gatherings with friends and family. The backyard oasis is a great place for entertaining or to just sit in peace and gaze up at the stars. This home is located in a highly rated school district, near grocery stores, schools, restaurants, and minutes from the Kemah Boardwalk. Don\'t let this one get away. Come make this house your home!','0.1796','33','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gas Connections,Wood Burning Fireplace','1','League City','Central Gas','1','ABST 18 PAGE 11 & 12 LOT 34 BLK 6 SOUTH SHORE VILLAGE SEC 3','Cul-De-Sac','7825','Appraisal District','','560','0','','2','Gas Oven','1','Gunite','','','','Composition','9 - Clear Creek','HYDE ELEMENTARY SCHOOL','CLEAR FALLS HIGH SCHOOL','LEAGUECITY INTERMEDIATE SCHOOL','Appointment Required','Appraisal District','1','Traditional','South Shore Village Sec 3 93','5960','2.0697','Public Sewer,Public Water','1996','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','212623482','1663949701','212623482','2022-09-23T07:32:48.900','2885450','Hector Alpuing','Keller Williams Professionals','','','30.029765','-95.534238','42','77379','9','349900.00','Active','Ralick','7502','Court','Spring','2','1','4','2704','Single-Family','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!','0.5234','13','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Wood Burning Fireplace','1','Champions Area','Central Electric','1','LT 3 BLK 1 017*M1876900-001-001-003 MEMORIAL NORTHWEST SEC 1','Corner','22800','Appraisal District','','693','0','','2','Double Oven,Electric Oven','0','','','Electric Cooktop','','Composition','32 - Klein','THEISS ELEMENTARY SCHOOL','KLEIN HIGH SCHOOL','DOERRE INTERMEDIATE SCHOOL','Appointment Required,Supra Keybox','Appraisal District','2','Traditional','Memorial Northwest Sec 01','5117','2.3213','Water District','1971','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-23T07:23:12.487' ,`MLSNumber` = '11996939' ,`ListAgentFullName` = 'Jen McMahon' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.064613' ,`Longitude` = '-95.193632' ,`PhotoCount` = '29' ,`PostalCode` = '77339' ,`RoomCount` = '7' ,`ListPrice` = '285000.00' ,`Status` = 'Active' ,`StreetName` = 'River Valley' ,`StreetNumber` = '3107' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1860' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Look no further! Your home with a huge POOL has officially hit the market! Nestled in the well established village of Hunter\'s Ridge, 3107 River Valley Drive welcomes you to life in the \"livable forest\" of Kingwood. Enjoy hours in your pool/spa or sitting in the screened patio overlooking your lush and sizable back yard! Well maintained and never flooded, this 2 story home features 3 bedrooms and 2.5 baths, granite counters, new luxury vinyl plank floors, beautiful wood stairs, dual primary closets, spacious bedrooms, gas fireplace, NEW ROOF in 2021, interior and exterior paint 2022, the list goes on! Walk or bike to all the local shops surrounded by the Kingwood trails. Easy access to I-59/69, 99 Grand Parkway, and 20 minutes to IAH. This home is a MUST SEE!' ,`Acres` = '0.1708' ,`Area` = '32' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Kingwood West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 15 BLK 6 HUNTERS RIDGE VILLAGE SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7440' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '375' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'GREENTREE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KINGWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'CREEKWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox,Temporarily No Showings' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Hunters Ridge Village' ,`TaxAmount` = '4996' ,`TaxRate` = '2.5839' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663949701' WHERE `Matrix_Unique_ID` = '212649560' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-23T07:35:24.337' ,`MLSNumber` = '42041062' ,`ListAgentFullName` = 'Karlee Thoem' ,`ListOfficeName` = 'Compass RE Texas, LLCKaty' ,`SellingAgentFullName` = ' Non-MLS Agent' ,`SellingOfficeName` = 'Non-MLS ' ,`Latitude` = '27.754198' ,`Longitude` = '-97.118925' ,`PhotoCount` = '50' ,`PostalCode` = '78373' ,`RoomCount` = '7' ,`ListPrice` = '2695000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Lakeshore' ,`StreetNumber` = '218' ,`StreetSuffix` = 'Drive' ,`City` = 'Port Aransas' ,`BathsFull` = '5' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '3228' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Custom lake front home located in the highly sought after community of Cinnamon Shore South in Port Aransas! Featuring 5 en-suite bedrooms with sleep accommodations up to 18, this home offers 2 primary suites, 1 king guest suite and 2 bunk suites. Experience the open concept floor plan with 2 separate living rooms and 2 primary suites with private access to the porch overlooking the lake on the 1st and 2nd floor. Luxury high end furnishings with custom details throughout the entire home, showcasing the fine attention to detail this home offers. Designed for entertaining, the open concept kitchen overlooking the living room and 2nd floor balcony is equipped with 2 dishwashers, beverage refrigerator, high end gas range and large island that will accommodate up to 6 and adjoining dining room with seating for 10. Unique opportunity to purchase a completed home in Cinnamon Shore South on the lake ,ready for move in and currently in the rental program generating income!' ,`Acres` = '0.1043' ,`Area` = '85' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'CINNAMON SHORE SOUTH UNIT 1 BLK 4 LOT 14' ,`LotDesciption` = 'Water View,Waterfront' ,`LotSize` = '4543' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '5172' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '829 - Port Aransas' ,`SchoolElementary` = 'OLSEN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PORT ARANSAS HIGH SCHOOL' ,`SchoolMiddle` = 'BRUNDRETT MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Other Style,Traditional' ,`Subdivision` = 'Cinnamon Shore South Un 1' ,`TaxAmount` = '17365' ,`TaxRate` = '1.6032' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663949701' WHERE `Matrix_Unique_ID` = '212652391' --> 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','212693989','1663949701','212693989','2022-09-23T06:03:44.290','57172907','Jenifer Duguay','RE/MAX Space Center-Clear Lake','','','29.574866','-95.277061','32','77581','9','315000.00','Active','Lazy Hollow','1904','Lane','Pearland','2','0','3','1843','Single-Family','A place to call home. Located in the highly desirable community of The Lakes at Highland Glen features community lakes, parks, pool and walking trails. Zoned to top rated schools. Originally built by Plantation homes offers 3 bedrooms with a home office or 4th bedroom. Tile flooring in entry/kitchen/backsplash/breakfast/baths/laundry. Upgraded items include: Nov. \'21 replaced HVAC unit with ultraviolet lighting for improving health, vinyl plank flooring throughout main areas, 42\" cabinets in kitchen & master bath, granite counters in kitchen & primary bath, backsplash with granite inserts, stainless steel stove, dishwasher and microwave. Black side-by-side fridge is included. 2 \'\'blinds,crown molding, doors,fixtures, ceiling fans, faucets, recessed lighting, shower & glass door, tiled shower in guest, mirrors and so much more! Solar screens on back! 4 sided brick. No back neighbors. 2.9 Tax Rate.','0.1768','5','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Freestanding,Gaslog Fireplace','1','Pearland','Central Electric','1','THE LAKES AT HIGHLAND GLEN SEC 8 (A0076)(PEARLAND) BLK 2 LOT','Subdivision Lot','7701','Appraisal District','','795','0','','2','Freestanding Oven,Gas Oven','0','','','Gas Range','','Composition','42 - Pearland','BARBARA COCKRELL ELEMENTARY SCHOOL','PEARLAND HIGH SCHOOL','PEARLAND JUNIOR HIGH WEST','Appointment Required','Appraisal District','1','Ranch','The Lakes At Highland Glen Sec','7283','2.9952','Public Sewer,Public Water,Water District','2004','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-23T07:03:22.080' ,`MLSNumber` = '26149209' ,`ListAgentFullName` = 'Oscar Martinez' ,`ListOfficeName` = 'Texas Sol Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.535331' ,`Longitude` = '-95.392285' ,`PhotoCount` = '43' ,`PostalCode` = '77578' ,`RoomCount` = '5' ,`ListPrice` = '469999.00' ,`Status` = 'Active' ,`StreetName` = 'Southworth' ,`StreetNumber` = '3022' ,`StreetSuffix` = 'Lane' ,`City` = 'Manvel' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3388' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Enjoy an abundance of everyday luxury in this glamorous The upstairs retreat and downstairs study provide sunny spaces to craft your ideal special-purpose rooms. Unique personalities and growing minds can flourish in the delightful spare bedrooms. Soaring ceilings and sleek spaces for living and dining make the open floor plan a beautiful place to play host. Share your cuisine creations on the presentation island in the modern kitchen. Withdraw to the elegant Owner’s Retreat, which includes the closet and bathroom features to pamper your wardrobe and yourself. The covered porches present remarkable opportunities for outdoor relaxation accompanied by a gorgeous heated swimming pool which can be indulged year round.' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Southfork Sec 2B Blk 1 Lot 7' ,`LotDesciption` = 'Water View' ,`LotSize` = '8115' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'RED DUKE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SHADOW CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MCNAIR JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Southfork section' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663949701' WHERE `Matrix_Unique_ID` = '212699212' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-23T06:59:10.063' ,`MLSNumber` = '19166534' ,`ListAgentFullName` = 'Rubi Longoria' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = 'Giannina Hadfield' ,`SellingOfficeName` = 'HomeSmart' ,`Latitude` = '29.737232' ,`Longitude` = '-95.365527' ,`PhotoCount` = '6' ,`PostalCode` = '77004' ,`RoomCount` = '3' ,`ListPrice` = '225000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Hutchins' ,`StreetNumber` = '2902' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1400' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Build or remodel, use your imagination. Welcome to Emancipation Heights. Across from Emancipation Park and easy access to Houston\'s major highways and business/entertainment districts.' ,`Acres` = '0.1148' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'University Area' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 3 BLK 1 PARK COURT' ,`LotDesciption` = 'Corner' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BLACKSHEAR ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'YATES HIGH SCHOOL' ,`SchoolMiddle` = 'CULLEN MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Park Court' ,`TaxAmount` = '3615' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663949702' WHERE `Matrix_Unique_ID` = '212712238' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-23T06:23:54.150' ,`MLSNumber` = '11744355' ,`ListAgentFullName` = 'James Polomsky' ,`ListOfficeName` = 'Red Door Realty & Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.065986' ,`Longitude` = '-95.217550' ,`PhotoCount` = '9' ,`PostalCode` = '77339' ,`RoomCount` = '8' ,`ListPrice` = '250000.00' ,`Status` = 'Active' ,`StreetName` = 'Fir Springs' ,`StreetNumber` = '2118' ,`StreetSuffix` = 'Drive' ,`City` = 'Kingwood' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1843' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '1 story home located in the Front of Kingwood with easy access to Hwy 59. 3 bedroom 2 full bath that part of the garage has been converted into a living space/media room. Still plenty of room in garage for storage or could be converted back into a 2 car garage. Additional storage shed located on the side of the house. Area pool and playground just a short walk down the street.' ,`Acres` = '0.1983' ,`Area` = '32' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Kingwood West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 61 WOODLAND HILLS VILLAGE SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8640' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '475' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'WOODLAND HILLS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KINGWOOD PARK HIGH SCHOOL' ,`SchoolMiddle` = 'KINGWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodland Hills Village' ,`TaxAmount` = '4464' ,`TaxRate` = '2.5839' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1976' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663949702' WHERE `Matrix_Unique_ID` = '212728421' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-23T07:05:55.473' ,`MLSNumber` = '80736056' ,`ListAgentFullName` = 'Mary Huber' ,`ListOfficeName` = 'CB&A, Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.079416' ,`Longitude` = '-95.479278' ,`PhotoCount` = '9' ,`PostalCode` = '77388' ,`RoomCount` = '4' ,`ListPrice` = '255000.00' ,`Status` = 'Active' ,`StreetName` = 'Mossy Spring' ,`StreetNumber` = '4055' ,`StreetSuffix` = 'Lane' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1518' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Excellent Investment Opportunity! Tenant occupied. Lease ends May 2023. Great location convenient to 2920, 45, and 99/Grand Parkway. Tucked away in a quiet subdivision, but close to shopping, groceries and restaurants. This home has a stable rental history for the investor or can be a great first home for a home buyer. Zoned to excellent schools in the Klein School District. Downstairs is an open layout. Kitchen with black appliances/cherry cabinets. Upstairs are four bedrooms and two full baths. Good sized fenced in yard and the neighborhood has a playground for the kiddos!' ,`Acres` = '0.0645' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring/Klein' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 7 BLK 1 PARK AT MEADOWHILL RUN SEC 2 PAR R/P' ,`LotDesciption` = 'Cleared' ,`LotSize` = '2808' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '338' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'ZWINK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN COLLINS HIGH SCHOOL' ,`SchoolMiddle` = 'SCHINDEWOLF INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Park/Meadowhill Run Sec 2 Pt' ,`TaxAmount` = '4469' ,`TaxRate` = '2.804' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2010' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663949702' WHERE `Matrix_Unique_ID` = '212728470' --> 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','212729334','1663949702','212729334','2022-09-23T06:56:38.043','89408758','Calvin Davis','Texas Premier Realty','','','30.015983','-95.552782','1','77379','8','330000.00','Active','Megan Springs','17314','Drive','Spring','2','0','4','2346','Single-Family','Welcome home to this elegant One story home on a beautiful lot, boasting 4 bedrooms. Located in the highly sought after neighborhood of Champion Springs Village! From the moment you enter, you will be amazed at all the upgrades this lovely home has to offer, including crown molding and stunning lighting throughout. Formal dining room is right off the kitchen....No need for formal dining, no problem you can turn this into a study. The kitchen has plenty of room to entertain and is open to the living room. The owners suite is privately tucked away in the back corner of the home, which includes an oversized ensuite. Fresh paint on all the walls and trims to make this an easy move in. The large backyard has a covered and extended patio, which is great for entertaining. This family friendly neighborhood features excellent schools, a community pool, catch and release pond, park, trails, restraunts close by & more! Open house this Saturday 24th and Sunday 25th from 1-4pm during estate sale.','0.1653','13','Pulte Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gas Connections,Gaslog Fireplace','1','Champions Area','Central Gas','1','LT 7 BLK 2 CHAMPION SPRINGS VILLAGE','Other','7200','Appraisal District','','680','0','','2','Gas Oven','0','','','Gas Cooktop','','Composition','32 - Klein','KRAHN ELEMENTARY SCHOOL','KLEIN CAIN HIGH SCHOOL','KLEB INTERMEDIATE SCHOOL','Appointment Required,Supra Keybox','Appraisal District','1','Traditional','Champion Spgs Village','4995','2.3266','Public Sewer,Public Water','2005','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-23T07:56:00.717' ,`MLSNumber` = '46143676' ,`ListAgentFullName` = 'Edward McClintick' ,`ListOfficeName` = 'Joseph Walter Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.517050' ,`Longitude` = '-94.447214' ,`PhotoCount` = '29' ,`PostalCode` = '77663' ,`RoomCount` = '6' ,`ListPrice` = '210000.00' ,`Status` = 'Active' ,`StreetName` = 'Paw Paw' ,`StreetNumber` = '406' ,`StreetSuffix` = '' ,`City` = 'Village Mills' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2262' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'AWESOME LAKEFRONT HOME IN THE COVETED WILDWOOD RESORT SUBDIVISION. 3/2/2 LOOKING FOR A GREAT NEW OWNER, LARGE LIVING ROOM, SUPERIOR VIEWS OF THE LAKE, FORMAL DINING ROOM. KITCHEN HAS BEEN UPGRADED AND FEATURES A DOUBLE OVEN, DISHWASHER, AND REFRIGERATOR. SERENE 18 HOLE GOLF COURSE. VOLLEYBALL, BASKETBALL AND TENNIS COURTS, LOCATED IN THE COMMUNITY. THIS HOME HAS NEVER FLOODED. THE LAKE IS CURRENTLY DRAINED FOR REPAIR HOWEVER IT WILL BE BACK. GREAT FOR AIRBNB, VRBO, RENTAL, VACATION HOME, OR PERSONAL HOME. SELLING AS IS.' ,`Acres` = '0.1637' ,`Area` = '49' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LOT 4 BLK 111 WILDWOOD P# WW111-4 I# 1696/365 8/20/08' ,`LotDesciption` = 'Water View,Waterfront' ,`LotSize` = '7131' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '1012 - Warren' ,`SchoolElementary` = 'WARREN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KOUNTZE HIGH SCHOOL' ,`SchoolMiddle` = 'KOUNTZE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Wildwood Residence City' ,`TaxAmount` = '3563' ,`TaxRate` = '1.9244' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1996' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663949702' WHERE `Matrix_Unique_ID` = '212773296' --> 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','212773752','1663949702','212773752','2022-09-23T07:46:49.513','64217528','Cris Reyna','JAM Real Estate, LLC','','','29.795666','-95.813251','14','77493','6','294999.00','Active','Chilton','1631','Lane','Katy','2','0','4','1602','Single-Family','Welcome to OLD TOWN KATY! This cozy 4-bedroom home is ready for a new loving family with a newly updated kitchen, flooring, and A/C system in June 2020. You will have easy access to I-10, Grand Parkway, and close proximity to Katy Mills, Typhoon Texas, plenty of restaurants and not to mention being Zoned to Katy ISD. Are you ready to take a look? Schedule your showing today!','0.1656','25','','','','','Sellers Disclosure','','','','Katy - Old Towne','Central Electric','1','LT 11 BLK G KATYLAND SEC 2','Subdivision Lot','7215','Appraisal District','','125','0','','2','','0','','','','','Composition','30 - Katy','HUTSELL ELEMENTARY SCHOOL','KATY HIGH SCHOOL','KATY JUNIOR HIGH SCHOOL','Accompany,Appointment Required,Leave Business Card,Lockbox Front','Appraisal District','1','Traditional','Katyland','4531','2.3852','Public Sewer,Public Water','1976','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212800812','1663949702','212800812','2022-09-23T07:33:25.543','4926170','Rosanna Valenzuela','FYI Realty','','','29.809847','-94.995965','20','77521','5','225000.00','Active','Breda','7802','Drive','Baytown','2','0','3','1520','Single-Family','Welcome Home! Fall in love with this lovely 3 bedroom 2 bathroom beauty that sits on a beautiful corner lot in the established neighborhood of Meadow Lake subdivision. This home features a large living area with high ceilings, an updated kitchen with stainless steel appliances, updated bathrooms, and new interior paint throughout. The primary bedroom features an en suite bathroom and a walk in closet. Secondary bedrooms are spacious and have nice sized closets. The backyard is generously sized and has a covered patio. Enjoy easy access to I-10 and everything Baytown has to offer! Don\'t miss out! Schedule your private showing today!','0.2007','2','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Gaslog Fireplace','1','Baytown/Harris County','Central Electric','1','LT 71 BLK 2 MEADOW LAKE SEC 2','Corner,Subdivision Lot','8742','Appraisal District','','400','0','','2','Gas Oven','0','','','Gas Cooktop','','Composition','23 - Goose Creek Consolidated','BANUELOS ELEMENTARY SCHOOL','GOOSE CREEK MEMORIAL','HIGHLANDS JUNIOR HIGH SCHOOL','Accompany,Appointment Required,Supra Keybox','Appraisal District','1','Ranch','Meadow Lake Sec 02','3946','2.755','Water District','1984','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-23T07:03:11.877' ,`MLSNumber` = '95888376' ,`ListAgentFullName` = 'Rubi Longoria' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = 'Adam Lambert' ,`SellingOfficeName` = 'Real Equity TX LLC' ,`Latitude` = '29.728638' ,`Longitude` = '-95.358454' ,`PhotoCount` = '5' ,`PostalCode` = '77004' ,`RoomCount` = '2' ,`ListPrice` = '150000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Reeves' ,`StreetNumber` = '3225' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '800' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'buyer to confirm room sizes; selling as is.' ,`Acres` = '0.0918' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'University Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 16 BLK 5 FOREST HOME' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BLACKSHEAR ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'YATES HIGH SCHOOL' ,`SchoolMiddle` = 'CULLEN MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Forest Home' ,`TaxAmount` = '2304' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1936' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663949702' WHERE `Matrix_Unique_ID` = '212801577' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-23T07:59:17.773' ,`MLSNumber` = '94681012' ,`ListAgentFullName` = 'Evan Ballew' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.333290' ,`Longitude` = '-95.621271' ,`PhotoCount` = '40' ,`PostalCode` = '77316' ,`RoomCount` = '4' ,`ListPrice` = '269900.00' ,`Status` = 'Active' ,`StreetName` = 'Stinson' ,`StreetNumber` = '16821' ,`StreetSuffix` = '' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1820' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BRAND NEW and ready for move-in! This 4 bedroom, 2.5 bath, 2 story home sits on approximately .3 acre is located in Lake Bonanza and zoned to highly acclaimed MISD. Inside you will find an open floorplan with beautiful LVP flooring in the living and dining that leads to the kitchen with stainless steel appliances (including a refrigerator), granite counters, gorgeous white cabinets, and a separate pantry. The master suite is located on the first floor with an attached ensuite with double sinks and an large walk-in closet. A half bath is also on the first floor located just off the living space. Upstairs are 3 guest suites, all generous in size with large closets. Out back is a concrete porch, ready for the grill! Plenty of room for a shop or pool! Low HOA, low tax rate... Don\'t miss out on this gem' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'Starter Homes of TX' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 9 Block 4 Lake Bonanza 01' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '13068' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '243' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'LONE STAR ELEMENTARY SCHOOL (MONTGOMERY)' ,`SchoolHigh` = 'LAKE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'OAK HILL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lake Bonanza' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663949703' WHERE `Matrix_Unique_ID` = '212829394' --> 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','212829725','1663949703','212829725','2022-09-23T07:38:22.630','85893830','Jared Turner','LennarVillageBldr-JaredTurner','','','29.518620','-95.437221','15','77583','6','310000.00','Active','Walworth Creek','14243','Court','Rosharon','2','0','3','1485','Single-Family','NEW Lennar Homes, Wildflower Collection, \'\'Honeysuckle II\" Plan, Elevation \"A\" in Lakes of Savannah. This single-story 3-2-2 home enjoys an open-concept layout that’s ideal for modern family living. A spacious kitchen overlooks the family room and attached covered patio, ready for indoor-outdoor entertaining. Two bedrooms are privately situated near the family room, while the owner’s suite boasts an en-suite bathroom and walk-in closet at the end of the home. *HOME ESTIMATED TO BE COMPLETE, DECEMBER, 2022*','','5','Lennar Homes','','','','Mud,Other Disclosures','1','','0','Alvin North','Central Gas','1','SEC 0019 BLK 002 LOT 020','Subdivision Lot','','','','950','1','To Be Built/Under Construction','2','','0','','','','','Composition','3 - Alvin','SAVANNAH LAKES ELEMENTARY SCHOOL','MANVEL HIGH SCHOOL','RODEO PALMS JUNIOR HIGH SCHOOL','Appointment Required','Builder','1','Traditional','Lakes of Savannah','','3.42','Water District','2022','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212833067','1663949703','212833067','2022-09-23T07:37:13.257','38917456','Jared Turner','LennarVillageBldr-JaredTurner','','','29.510814','-95.444946','16','77583','8','270000.00','Active','Woodcott Warren','14506','Way','Rosharon','2','0','3','1186','Single-Family','NEW! Lennar Cottage Collection \"Brook\" Plan with Elevation \"C\" in Lakes of Savannah! This single-story layout makes great use of the space available and features the convenience of having everything you need on one level. The main living area features an open layout among the kitchen with a wraparound countertop, dining room and family room. The owner\'s suite with its own bathroom and two closets is located in the back, while two bedrooms are located near the front. *HOME IS ESTIMATED TO BE COMPLETE, DECEMBER, 2022.','','38','Lennar','','','','Mud,Other Disclosures','1','','0','Missouri City Area','Central Gas','1','SEC 0021 BLK 003 LOT 006','Subdivision Lot','','','','950','1','To Be Built/Under Construction','2','','0','','','','','Composition','19 - Fort Bend','HERITAGE ROSE ELEMENTARY SCHOOL','RIDGE POINT HIGH SCHOOL','BAINES MIDDLE SCHOOL','Appointment Required','Builder','1','Traditional','Lakes of Savannah','','3.093','Water District','2022','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212834836','1663949703','212834836','2022-09-23T07:51:40.327','34443917','Enrique Buenrostro','Coldwell Banker Realty','','','29.812714','-94.899518','25','77523','4','275000.00','Active','Palm','8306','Circle','Baytown','2','0','3','1825','Single-Family','Welcome Home! This charming one story home sitting on an oversized culdesac lot is ready for its next owners. Tall ceilings, large open floorpan, and a huge skylight in the kitchen are just some of the many features of this home. The large open areas and functional floor-plan give plenty of flexibility to use spaces as desired.','0.3085','53','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','Baytown/Chambers County','Central Electric,Central Gas','1','LT 69 PINE MEADOWS S/D','Cul-De-Sac,Subdivision Lot','13438','Appraisal District','','250','0','','2','Gas Oven','0','','','Gas Range','','Composition','23 - Goose Creek Consolidated','CLARK ELEMENTARY SCHOOL (GOOSE CREEK)','STERLING HIGH SCHOOL (GOOSE CREEK)','GENTRY JUNIOR HIGH SCHOOL','Accompany,Appointment Required,Lockbox Front','Appraisal District','1','Other Style,Traditional','Pine Meadows Sub','5794','2.8882','Public Sewer,Public Water','2011','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-23T07:54:10.723' ,`MLSNumber` = '67065456' ,`ListAgentFullName` = 'Jimmy Jones' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = 'Jimmy Jones' ,`SellingOfficeName` = 'eXp Realty, LLC' ,`Latitude` = '29.626853' ,`Longitude` = '-95.734884' ,`PhotoCount` = '0' ,`PostalCode` = '77406' ,`RoomCount` = '11' ,`ListPrice` = '440000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Rambling Stone' ,`StreetNumber` = '1727' ,`StreetSuffix` = 'Drive' ,`City` = 'Richmond' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3076' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'GOLF COURSE living on a large corner lot in the neighborly community of Pecan Grove. This property offers 2 driveways, 4 bedrooms, 3.5 bathrooms, a gameroom, a flex room above the garage, and a sunroom. The formal dining features crown molding, chair molding and elegant wood flooring. The large island kitchen boasts a breakfast bar, granite countertops, stainless steel appliances and tile flooring. The breakfast room has a study nook with built-in cabinets and luxury wainscoting. Enjoy gathering in the spacious family room with a stonefaced gaslog fireplace, high ceilings, and wetbar. 3 guest rooms, a gameroom and flex room are upstairs. The backyard has gorgeous golf course views of the #2 tee box, a large side yard, pergola on extended concrete patio, wrap around sunroom and plenty of lush grass and trees. Book your personal tour today!' ,`Acres` = '0.257' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'PECAN GROVE PLANTATION SEC 7, BLOCK 3, LOT 1' ,`LotDesciption` = 'Corner,In Golf Course Community,On Golf Course,Subdivision Lot' ,`LotSize` = '11195' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '209' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'PECAN GROVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TRAVIS HIGH SCHOOL (FORT BEND)' ,`SchoolMiddle` = 'BOWIE MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Pecan Grove Plantation Sec 7' ,`TaxAmount` = '7436' ,`TaxRate` = '2.2979' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1989' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663949703' WHERE `Matrix_Unique_ID` = '212834970' --> 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','212840346','1663949703','212840346','2022-09-23T07:40:01.420','83629259','Jared Turner','LennarVillageBldr-JaredTurner','','','29.518499','-95.784274','7','77471','11','475000.00','Active','Paloma Falls','3620','Lane','Rosenberg','4','1','5','3126','Single-Family','NEW! Lennar Fairway Collection Next Gen \"Oak Hill III\" Plan with Elevation \"D\" in Sendero! The versatile two-story Oak Hill III Next Gen® floor plan by Lennar features a HOME OFFICE SUITE with a built-in coffee bar, a private front entrance, and a single bay garage. The main home features an island kitchen with a walk-in pantry, an open dining room and family room, a relaxing covered rear patio, and a walk-in utility room. The first floor primary bedroom features an en suite bathroom with dual sinks, stand-up shower, private toilet enclosure, and a spacious walk-in closet. The second floor features three additional bedrooms, two full bathrooms, and a spacious game room. *HOME ESTIMATED TO BE COMPLETE, FEBRUARY, 2023*','','30','Lennar','','','','Mud,Other Disclosures','1','','0','Fort Bend South/Richmond','Central Gas','1','SEC 0005 BLK 001 LOT 018','Subdivision Lot','','','','756','1','To Be Built/Under Construction','3','','0','','','','','Composition','33 - Lamar Consolidated','MEYER ELEMENTARY SCHOOL (LAMAR)','RANDLE HIGH SCHOOL','WRIGHT JUNIOR HIGH SCHOOL','Appointment Required','Builder','2','Traditional','Sendero','','3.09','Water District','2022','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212840850','1663949703','212840850','2022-09-23T07:46:51.043','25362423','Gayle Kennedy','Keller Williams Metropolitan','','','29.714362','-95.352826','12','77004','7','309700.00','Active','Rosedale','3837','Street','Houston','2','0','3','1342','Single-Family','Just minutes to Downtown, the Med Center, U of H, TSU, Hermann Park and more. Bright, open floorplan with no carpet. This home was taken to the studs and fully renovated in 2018 and 2019. The foundation was leveled, plumbing replaced, electrical replaced, new double pane vinyl windows, roof replaced, new flooring and new driveway. The kitchen includes a generous pantry, granite counters, recent cabinets and stainless steel appliances - refrigerator included. Just beautiful and waiting for you! The HVAC is a 16 SEER rated Carrier system to help lower the electrical bills. There are generous closets in each bedroom and the utility room is in the house with washer and dryer included in the sale. Come take a look today!','0.1543','4','','','Gas Dryer Connections,Washer Connections','','Owner/Agent,Sellers Disclosure','1','','','University Area','Central Gas','0','LT 25 BLK 5 OAK MANOR SEC 1','Subdivision Lot','6720','Appraisal District','','','0','','0','Single Oven','0','','','Gas Range','','Composition','27 - Houston','LOCKHART ELEMENTARY SCHOOL','YATES HIGH SCHOOL','CULLEN MIDDLE SCHOOL (HOUSTON)','Appointment Required','Appraisal District','1','Traditional','Oak Manor 1','3035','2.6454','Public Sewer,Public Water','1951','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','212844910','1663949703','212844910','2022-09-23T07:39:04.373','19361881','Jared Turner','LennarVillageBldr-JaredTurner','','','29.518559','-95.783973','6','77471','8','345990.00','Active','Rushing Brook','5308','Lane','Rosenberg','2','0','4','1922','Single-Family','NEW! Lennar Wildflower Collection \"Brenham II\" Plan with Elevation \"A\" in Sendero! This spacious, single-story home features a large family room, a kitchen with a center island and an adjoining breakfast space that overlooks a covered patio. The owner’s suite enjoys a large walk-in closet and a private entry that leads to a second walk-in closet and a laundry room. *HOME ESTIMATED TO BE COMPLETE, NOVEMBER, 2022*','','30','Lennar','','','','Mud,Other Disclosures','1','','0','Fort Bend South/Richmond','Central Gas','1','SEC 0004 BLK 001 LOT 021','Subdivision Lot','','','','756','1','To Be Built/Under Construction','2','','0','','','','','Composition','33 - Lamar Consolidated','MEYER ELEMENTARY SCHOOL (LAMAR)','RANDLE HIGH SCHOOL','WRIGHT JUNIOR HIGH SCHOOL','Appointment Required','Builder','1','Traditional','Sendero','','3.09','Water District','2022','Builder'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-23T07:17:27.997' ,`MLSNumber` = '32179807' ,`ListAgentFullName` = 'Yelena Grinina' ,`ListOfficeName` = 'Keller Williams Metropolitan' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.766424' ,`Longitude` = '-95.480206' ,`PhotoCount` = '43' ,`PostalCode` = '77057' ,`RoomCount` = '16' ,`ListPrice` = '3575000.00' ,`Status` = 'Active' ,`StreetName` = 'Bayou Glen' ,`StreetNumber` = '5804' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '7' ,`BathsHalf` = '2' ,`BedsTotal` = '6' ,`SqFtTotal` = '8788' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Impressive masterpiece by Stacey Fine Homes nestled in a beautiful & quiet part of Tanglewood. Family room with Wall of Windows and door that leads to patio; Chef\'s kitchen with full Thermador appliance package and island opens to a large living area viewing heated, salt water pool, spa, and water feature. Australian cypress flooring throughout. Central wet bar, butler’s pantry, wine room & formal dining room are designed for family gathering and entertaining. Guest bedroom, study, home office, air conditioned outdoor kitchen w/fireplace all on the first floor. Game room has powder room + wet bar, media room, and primary bedroom + 4 bedrooms up. Primary suite Includes separate coffee bar with microwave, ice maker & fridge, fireplace, two huge closets, oversized Bain Ultra Air Tub & Walk-in Shower. Fully air-conditioned sunroom features beamed ceiling, fireplace, and pool bath; air conditioned 3 car oversized garage has gated motor court. Elevator' ,`Acres` = '' ,`Area` = '22' ,`BuilderName` = 'Stacey Fine Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '3' ,`GeoMarketArea` = 'Tanglewood Area' ,`HeatSystem` = 'Central Electric,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'TR 6 BLK 53 TANGLEWOOD SEC 11' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot' ,`LotSize` = '14250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground,Salt Water' ,`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,No Photos/No Videos' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Mediterranean' ,`Subdivision` = 'Tanglewood Sec 11' ,`TaxAmount` = '69942' ,`TaxRate` = '2.3994' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663949703' WHERE `Matrix_Unique_ID` = '212848720' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-23T06:24:01.047' ,`MLSNumber` = '19994001' ,`ListAgentFullName` = 'Samuel Garcia' ,`ListOfficeName` = 'RE/MAX Grand' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.901903' ,`Longitude` = '-95.486946' ,`PhotoCount` = '30' ,`PostalCode` = '77086' ,`RoomCount` = '5' ,`ListPrice` = '369000.00' ,`Status` = 'Active' ,`StreetName` = 'Spindle' ,`StreetNumber` = '6602' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1783' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.5' ,`Area` = '11' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TR 17A BLK 2 RECREATION FARMS SEC 1 ABST 222 T M DORSETT' ,`LotDesciption` = 'Other' ,`LotSize` = '21781' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'EILAND ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN FOREST HIGH SCHOOL' ,`SchoolMiddle` = 'KLEIN INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Recreation Farms' ,`TaxAmount` = '1933' ,`TaxRate` = '2.1885' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663949703' WHERE `Matrix_Unique_ID` = '212848737' --> Updated record success