Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-16T09:32:32.523' ,`MLSNumber` = '23999580' ,`ListAgentFullName` = 'Michael Alexander' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.819412' ,`Longitude` = '-95.437276' ,`PhotoCount` = '27' ,`PostalCode` = '77018' ,`RoomCount` = '0' ,`ListPrice` = '449999.00' ,`Status` = 'Active' ,`StreetName` = 'Oatfield' ,`StreetNumber` = '2116' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2112' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Your palace awaits! Newly constructed. The perfect blend of City and Suburban living right in the heart of the beloved community of Oak Forest. This elegant home includes 3 bedrooms, 3.5 baths, 3 story living, a 2-car garage, and an open floor plan with ample natural lighting. Inside this one-of-a-kind home you will find huge walk-in closets, High ceilings, a Gourmet kitchen with an abundance of solid wood Cabinets, Calacatta Quartz countertops and over-sized island, Bamboo and Porcelain flooring, sleek and modern fixtures and features, and covered balconies. Location! Only a few minutes away from freeway access which places you less than 10 mi. from popular areas like the Medical Center, Heights, the Galleria, Energy Corridor, and Downtown Houston. Both Airports are less than 20 mi. away and there are also plenty of local restaurants, bars and attractions within walking distance. Video Tour: https://youtu.be/1WI8i386J6M' ,`Acres` = '0.0359' ,`Area` = '9' ,`BuilderName` = 'Fisher Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Oak Forest East Area' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 8 BLK 1 FISHER ESTATES AT OAK FOREST' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '1562' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '150' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'OAK FOREST ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'BLACK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Other Style' ,`Subdivision` = 'Fisher Ests/Oak Forest' ,`TaxAmount` = '4263' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665936111' WHERE `Matrix_Unique_ID` = '207102911' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-16T09:42:12.760' ,`MLSNumber` = '18484641' ,`ListAgentFullName` = 'Sammy Younis' ,`ListOfficeName` = 'RE/MAX Southwest' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.747938' ,`Longitude` = '-95.537091' ,`PhotoCount` = '34' ,`PostalCode` = '77063' ,`RoomCount` = '7' ,`ListPrice` = '585000.00' ,`Status` = 'Active' ,`StreetName` = 'Bayou Brook' ,`StreetNumber` = '9613' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '4068' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous 2 story townhome 3 bedrooms with the primary room are downstairs. Completely remodeled tiles downstairs and wood floor upstairs. Spacious living room with high ceiling, great patio overlooking the bayou. Just a few steps from the community swimming pool and tennis courts. minuets to I 10, Beltway 8, and Memorial City Medical Center. New AC, water heater 2022, roof 2017. A two-car garage is attached. Lots of natural lights and skylights.' ,`Acres` = '0.0688' ,`Area` = '22' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Memorial West' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 10 WOODLAKE FOREST SEC 4B R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2998' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2000' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'EMERSON ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WISDOM HIGH SCHOOL' ,`SchoolMiddle` = 'REVERE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodlake Forest' ,`TaxAmount` = '13258' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665936112' WHERE `Matrix_Unique_ID` = '208384161' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-16T08:25:54.927' ,`MLSNumber` = '95887668' ,`ListAgentFullName` = 'Patrick Burbridge' ,`ListOfficeName` = 'CitiQuest Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.801127' ,`Longitude` = '-95.480466' ,`PhotoCount` = '42' ,`PostalCode` = '77055' ,`RoomCount` = '3' ,`ListPrice` = '464900.00' ,`Status` = 'Active' ,`StreetName` = 'Jacquelyn Grove' ,`StreetNumber` = '7612' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2047' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Introducing VILLAS De Marbella | A community of two & three level contemporary residences. Four open floor plan options designed for the modern lifestyle, with living areas on the main level, 10’ ceilings & sliding glass doors opening to a sizable porch/private yard. Level I is complete w/ wide-plank luxury vinyl flooring, dine-in kitchen garnished w/ SS appliances, select plumbing fixtures, modern quartz countertops & euro style cabinetry. Level II features the Owners Primary Suite, two guest suites, & a vast utility room. The expansive window lined primary bedroom is complete w/ luxury vinyl flooring, a stunning bath complete with dual vanities, freestanding soaking tub, glass enclosed shower & a massive walk-in closet with built-ins. Substantial secondary bedrooms are both en-suite with walk-in closets & tub/shower combos. Construction is underway, with the first phase of homes estimated to be ready by Summer 2022. *THIS HOME IS MOVE IN READY*' ,`Acres` = '' ,`Area` = '24' ,`BuilderName` = 'Marbella / Greyden' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 2 BLOCK 1 ESTATES AT JACQUELYN' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '110' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'TREASURE FOREST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTHBROOK HIGH SCHOOL' ,`SchoolMiddle` = 'LANDRUM MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Spring Branch' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665936112' WHERE `Matrix_Unique_ID` = '209710682' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-16T09:34:55.700' ,`MLSNumber` = '40929527' ,`ListAgentFullName` = 'Grace Harris' ,`ListOfficeName` = 'RE/MAX Grand' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.370869' ,`Longitude` = '-95.307093' ,`PhotoCount` = '23' ,`PostalCode` = '77303' ,`RoomCount` = '9' ,`ListPrice` = '449990.00' ,`Status` = 'Active' ,`StreetName` = 'Crosby' ,`StreetNumber` = '16612' ,`StreetSuffix` = '' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2084' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 3 bedroom 2 bath w/study & 3rd car garage on just under an acre lot! Elegant entry with crown molding that leads you into an open kitchen with an oversized family room! Kitchen includes white cabinets, silestone countertops w/undermount sink, designer backsplash, Stainless steel appliances, 9 ft long center island overlooking the extra large family room with plenty of windows! Owner suite has high ceilings with a large bath, separate tub & shower and his & her vanity w/silestone countertops! Big secondary bedrooms with plenty of space and the 2nd bath offers 2 sinks for the kids to share! Not to mention a covered patio and a 3 car Garage with space for a SHOP AREA! Ladies bring your hubby, because he will love it! ! Home sits on just under an acre of land where you can build a shop, store your boat, RV, trailer etc. all on your property! Conroe ISD schools and Low Tax rate! Hurry, Call today, this won\'t last long!' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = 'KENDALL HOMES' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Northeast' ,`HeatSystem` = 'Propane' ,`HOAMandatory` = '1' ,`Legal` = 'Deer Pines Lot 3 Block 3 Section 23' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '43292' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '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' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Deer Pines' ,`TaxAmount` = '' ,`TaxRate` = '1.8488' ,`WaterSewer` = 'Aerobic,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665936112' WHERE `Matrix_Unique_ID` = '209987584' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-16T08:43:47.633' ,`MLSNumber` = '59134515' ,`ListAgentFullName` = 'Becky Nigrelle' ,`ListOfficeName` = 'Gulf Coast, Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.420857' ,`Longitude` = '-94.919886' ,`PhotoCount` = '48' ,`PostalCode` = '77590' ,`RoomCount` = '4' ,`ListPrice` = '875000.00' ,`Status` = 'Active' ,`StreetName` = '17th' ,`StreetNumber` = '4202' ,`StreetSuffix` = 'Street' ,`City` = 'Texas City' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2818' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.1769' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 204 PAGE 2 LOT 1 LAKESHORES ADDN NO 2' ,`LotDesciption` = 'Cleared,Corner,Waterfront' ,`LotSize` = '7705' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Freestanding Oven,Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Fiberglass,Heated' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '52 - Texas City' ,`SchoolElementary` = 'GUAJARDO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TEXAS CITY HIGH SCHOOL' ,`SchoolMiddle` = 'BLOCKER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakeshore 2' ,`TaxAmount` = '8654' ,`TaxRate` = '2.5335' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1975' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665936112' WHERE `Matrix_Unique_ID` = '210340506' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-16T09:27:42.617' ,`MLSNumber` = '59478510' ,`ListAgentFullName` = 'Fran Summey' ,`ListOfficeName` = 'NextHome Top Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.952353' ,`Longitude` = '-95.265318' ,`PhotoCount` = '31' ,`PostalCode` = '77396' ,`RoomCount` = '8' ,`ListPrice` = '249000.00' ,`Status` = 'Active' ,`StreetName` = 'Catbird' ,`StreetNumber` = '16106' ,`StreetSuffix` = 'Court' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2194' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This 4 bedroom 2.5 baths on a corner lot is move-in ready. Three bedrooms are upstairs including the primary bedroom and game room. One bedroom is downstairs could be the perfect mother-in-law suite. The kitchen has two dining areas. There is crown molding in almost every room in the house. Updates include electrical, plumbing, new appliances, new carpet and vinyl flooring, new granite countertops, new sinks, new faucets, new water heater, new garbage disposal, new toilets, new A/C & furnace. This home is convenient to Hwy 59/I69, Beltway 8, downtown Houston, Bush Airport, shopping and dining.' ,`Acres` = '0.1815' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Humble Area East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 20 BLK 5 AUDUBON PARK SEC 2 R/P' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '7906' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '353' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'JACK M. FIELDS SR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HUMBLE HIGH SCHOOL' ,`SchoolMiddle` = 'HUMBLE MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Audubon Park' ,`TaxAmount` = '4635' ,`TaxRate` = '2.7373' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665936112' WHERE `Matrix_Unique_ID` = '210530304' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-16T09:27:25.863' ,`MLSNumber` = '64785944' ,`ListAgentFullName` = 'Sharon Ballas' ,`ListOfficeName` = 'Greenwood King Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.765584' ,`Longitude` = '-95.538800' ,`PhotoCount` = '44' ,`PostalCode` = '77024' ,`RoomCount` = '14' ,`ListPrice` = '2795000.00' ,`Status` = 'Active' ,`StreetName` = 'Surrey' ,`StreetNumber` = '12014' ,`StreetSuffix` = 'Lane' ,`City` = 'Bunker Hill Village' ,`BathsFull` = '5' ,`BathsHalf` = '3' ,`BedsTotal` = '5' ,`SqFtTotal` = '6494' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Incredible home w/ handsome stone façade, Whole house generator, Lutron lighting system, French white oak flooring, beamed ceilings, fabulous staircase & beautifully proportioned rooms. The dramatic entry opens to the dining room w/ temperature controlled wine room. The exceptional study w/ a wall of bookcases, abundant storage & French doors opens to backyard activities. The well-equipped kitchen features a large gathering island w/ breakfast bar, Wolf range, 3 ovens, SubZero refrigerator, warming drawer, walk-in pantry & breakfast room. Adjoining family room w/ fireplace & beamed ceiling opens to the pavilion & summer kitchen w/ half bath. Elegant primary suite features a sitting area overlooking the backyard & a beautiful bath w/ claw foot tub, spa shower, coffee bar & great closet! Wonderful secondary bedrooms w/ private baths. Gameroom & separate media room w/bar. Large light-filled utility room. Lockers. Circle drive. Porte cochere. Extra parking & gated drive. Cul-de-sac street.' ,`Acres` = '0.4369' ,`Area` = '23' ,`BuilderName` = 'Silverwood Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Memorial Villages' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'LT G SURREY LANE PLACE' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '19035' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'FROSTWOOD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'MEMORIAL MIDDLE SCHOOL (SPRING BRANCH)' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Bunker Hill Village' ,`TaxAmount` = '60358' ,`TaxRate` = '2.1656' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665936112' WHERE `Matrix_Unique_ID` = '210671684' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-16T09:56:27.757' ,`MLSNumber` = '68968454' ,`ListAgentFullName` = 'Kamilah Sage' ,`ListOfficeName` = 'CR Elite Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.729668' ,`Longitude` = '-95.359225' ,`PhotoCount` = '24' ,`PostalCode` = '77004' ,`RoomCount` = '6' ,`ListPrice` = '230000.00' ,`Status` = 'Active' ,`StreetName` = 'Sauer' ,`StreetNumber` = '3305' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '890' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This gorgeous 2 bedroom, 1 Bath has everything you need to feel right at home! FULLY RENOVATED!! Everything New!! Brand new energy efficient appliances, Energy efficient HVAC, and Attic Insulation!! Has original real wood accent walls, Brand new carpet, Tech Shield, and Quartz counter tops!! Centrally located in the heart of The University Area, minutes from TSU and UH, 10 mins from Rice U, and medical center, Emancipation Park, and has backyard access to a 20 mile bike trail that extends from Herman Park all the way to The Heights! This home is waiting for YOU!!' ,`Acres` = '0.0594' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'University Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'TRS 3B & 4A BLK 4 FOREST HOME' ,`LotDesciption` = 'Patio Lot' ,`LotSize` = '2586' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BLACKSHEAR ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'YATES HIGH SCHOOL' ,`SchoolMiddle` = 'CULLEN MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Forest Home' ,`TaxAmount` = '1934' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1936' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1665936113' WHERE `Matrix_Unique_ID` = '210790328' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-16T08:13:44.653' ,`MLSNumber` = '97034404' ,`ListAgentFullName` = 'Ken Lewis' ,`ListOfficeName` = 'RE/MAX Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.643270' ,`Longitude` = '-95.357567' ,`PhotoCount` = '18' ,`PostalCode` = '77047' ,`RoomCount` = '6' ,`ListPrice` = '210000.00' ,`Status` = 'Active' ,`StreetName` = 'Duane' ,`StreetNumber` = '10702' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1600' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'FOUNDATION REPAIRES FLOORING GOING BACK DOWN BE CAREFUL .HOUSE WAS GUTTED AND REBUILT NEW ELECTRICAL, PLUMBING, FIXTURES, BATHROOMS, NEW KITCHEN WITH NEW APPLIANCES ISLAND WITH GRANITE COUONTERS 3 FULL BATHS 3 BEDROOM WITH 2 PRIMARY BEDROOMS, NEW A/C, HEAT. JUST MIVE IN. HARDI PLANK SIDING NEW PAINT IN AND OUT.' ,`Acres` = '0.1735' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Medical Center South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 25 BLK 5 SOUTH ACRES ESTATES SEC 5' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '7558' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WOODSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WORTHING HIGH SCHOOL' ,`SchoolMiddle` = 'THOMAS MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'South Acres Estates Sec 05' ,`TaxAmount` = '2494' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665936113' WHERE `Matrix_Unique_ID` = '210811793' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-16T08:16:48.747' ,`MLSNumber` = '37604680' ,`ListAgentFullName` = 'Johna McCormick' ,`ListOfficeName` = 'Keller Williams Metropolitan' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.810837' ,`Longitude` = '-95.406761' ,`PhotoCount` = '20' ,`PostalCode` = '77008' ,`RoomCount` = '3' ,`ListPrice` = '813500.00' ,`Status` = 'Active' ,`StreetName` = '27th St' ,`StreetNumber` = '535' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3005' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Spacious home with timeless architecture by Titan Homes. Thoughtful design, exquisite finishes, tastefully executed intricate craftsmanship. This is a hardworking, functional yet elegant show home. \r\n\r\nIndependent drive, expansive first floor living, elevator capable, oversize backyard, chef’s kitchen, grand master suite and massive game room. Let this elegant home showcase your lifestyle.' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = 'Titan Homes' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LOT 31, BLK 18' ,`LotDesciption` = 'Other' ,`LotSize` = '3275' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '' ,`OvenType` = 'Electric Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HELMS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,French,Mediterranean,Spanish' ,`Subdivision` = 'Heights' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665936113' WHERE `Matrix_Unique_ID` = '211135755' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-16T08:24:25.743' ,`MLSNumber` = '55102884' ,`ListAgentFullName` = 'Patrick Burbridge' ,`ListOfficeName` = 'CitiQuest Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.801149' ,`Longitude` = '-95.480397' ,`PhotoCount` = '41' ,`PostalCode` = '77055' ,`RoomCount` = '3' ,`ListPrice` = '469000.00' ,`Status` = 'Active' ,`StreetName` = 'Jacquelyn Grove' ,`StreetNumber` = '7614' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2000' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Introducing VILLAS De Marbella | A community of two & three level contemporary residences. Four open floor plan options designed for the modern lifestyle, with living areas on the main level, 10’ ceilings & sliding glass doors opening to a sizable porch/private yard. Level I is complete w/ wide-plank luxury vinyl flooring, dine-in kitchen garnished w/ SS appliances, select plumbing fixtures, modern quartz countertops & euro style cabinetry. Level II features the Owners Primary Suite, two guest suites, & a vast utility room. The expansive window lined primary bedroom is complete w luxury vinyl flooring, a stunning bath complete with dual vanities, freestanding soaking tub, glass enclosed shower & a massive walk-in closet with built-ins. Substantial secondary bedrooms are both en-suite with walk-in closets & tub/shower combos. MOVE IN READY' ,`Acres` = '' ,`Area` = '24' ,`BuilderName` = 'Marbella / Greyden' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 1 BLOCK 1 ESTATES AT JACQUELYN' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '110' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'TREASURE FOREST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTHBROOK HIGH SCHOOL' ,`SchoolMiddle` = 'LANDRUM MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Spring Branch' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665936113' WHERE `Matrix_Unique_ID` = '211394449' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-16T09:09:10.677' ,`MLSNumber` = '4638626' ,`ListAgentFullName` = 'Adam Hunt' ,`ListOfficeName` = 'Hunt Commercial & Housing' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.830584' ,`Longitude` = '-95.469774' ,`PhotoCount` = '18' ,`PostalCode` = '77092' ,`RoomCount` = '11' ,`ListPrice` = '432999.00' ,`Status` = 'Active' ,`StreetName` = 'Libbey' ,`StreetNumber` = '5233' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '1452' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully Restored home with Original Hardwood Floors. This home has been completely refinished both inside and out. Designer Finishes through out the property with an updated floor plan. This home now features 5 Bedrooms and three full baths. There\'s a separate mother-in law suite that\'s integrated into the property with private access from exterior of home. Home has updated plumbing, Electrical, hvac and has been fully modernized.\n\nNo SD as home was not occupied. Can provide list of renovations. Home has not flooded per seller’s knowledge.' ,`Acres` = '0.1702' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Oak Forest West Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 1 BLK 25 OAK FOREST SEC 16' ,`LotDesciption` = 'Other' ,`LotSize` = '7416' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WAINWRIGHT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SCARBOROUGH HIGH SCHOOL' ,`SchoolMiddle` = 'CLIFTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Accompany,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Oak Forest Sec 16' ,`TaxAmount` = '5114' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1665936113' WHERE `Matrix_Unique_ID` = '211394846' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-16T08:41:13.913' ,`MLSNumber` = '73966648' ,`ListAgentFullName` = 'Jorge Tenorio' ,`ListOfficeName` = 'Maxima Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.779914' ,`Longitude` = '-95.189339' ,`PhotoCount` = '37' ,`PostalCode` = '77015' ,`RoomCount` = '7' ,`ListPrice` = '221900.00' ,`Status` = 'Active' ,`StreetName` = 'Emporia' ,`StreetNumber` = '13335' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1609' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MOTIVATED SELLER, REMODELED HOME THROUGHOUT, SUPER NICE PROPERTY AND READY TO BE SOLD four bedrooms two full bathrooms, new flooring, new kitchen, cabinets and pantry, tile work in master bath, freshly painted in and out, new water heather, brand new SS appliances, low maintenance, solar panels working perfect and saving a lot in energy (sellers got a check back from their energy company every year), large backyard ready to build your outdoor kitchen or pool NEVER FLOODED, send your offer now.' ,`Acres` = '0.1928' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 1096 BLK 35 HOME OWNED ESTATES SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '21 - Galena Park' ,`SchoolElementary` = 'CIMARRON ELEMENTARY SCHOOL (GALENA PARK)' ,`SchoolHigh` = 'NORTH SHORE SENIOR HIGH SCHOOL' ,`SchoolMiddle` = 'NORTH SHORE MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Home Owned Estates' ,`TaxAmount` = '3026' ,`TaxRate` = '2.7702' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665936114' WHERE `Matrix_Unique_ID` = '211418499' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-16T08:33:10.710' ,`MLSNumber` = '47192392' ,`ListAgentFullName` = 'Razelle Smith' ,`ListOfficeName` = 'RE/MAX Integrity' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.180820' ,`Longitude` = '-95.521803' ,`PhotoCount` = '48' ,`PostalCode` = '77381' ,`RoomCount` = '9' ,`ListPrice` = '515000.00' ,`Status` = 'Active' ,`StreetName` = 'Hidden View' ,`StreetNumber` = '37' ,`StreetSuffix` = 'Circle' ,`City` = 'The Woodlands' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2540' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Prime Location!!! in Cochrans Crossing is ready for your family with 4 bedrooms, 2 1/2 baths, and a 3-car oversized garage. Large lot big enough for a pool!! It has a covered front porch and a HUGE backyard with a fire pit. Large bedrooms Huge Primary and bath, predominately Tile/wood flooring. Gorgeous renovated kitchen with tall cabinets & Premium Acacia wood countertops (2022).Renovated Primary Bath (2021)Huge walk in shower/dressing area/tall counter tops One owner home, middle of The Woodlands. The community features parks, lakes, and playgrounds. A pond is just across the street, a short walk to fishing and canoeing. Welcome home!' ,`Acres` = '0.2504' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'WDLNDS VIL COCHRANS CR 17, BLOCK 1, LOT 41' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10907' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'GALATAS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'THE WOODLANDS HIGH SCHOOL' ,`SchoolMiddle` = 'MCCULLOUGH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Wdlnds Village Cochrans Cr 17' ,`TaxAmount` = '5455' ,`TaxRate` = '2.1319' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1990' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665936114' WHERE `Matrix_Unique_ID` = '211432674' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-16T08:58:59.367' ,`MLSNumber` = '58410912' ,`ListAgentFullName` = 'Sergio Paredes' ,`ListOfficeName` = 'Kodu Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.793188' ,`Longitude` = '-95.700383' ,`PhotoCount` = '22' ,`PostalCode` = '77084' ,`RoomCount` = '6' ,`ListPrice` = '312000.00' ,`Status` = 'Active' ,`StreetName` = 'Park Harbor Estates' ,`StreetNumber` = '1603' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2011' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this charming home located at 1603 Park Harbor Estates Dr! This home sits on a large corner lot with fantastic curb appeal zoned to highly acclaimed Katy ISD! It features spacious bedrooms, a large living area, a formal dining and breakfast nook, and a private study with large French doors. The kitchen boasts 42\" cabinets, island kitchen and a lot of storage and counter-space. The living area opens to the kitchen making it perfect for entertaining friends and family. The master suite features a large walk-in closet and the master bath includes a large soaking tub and separate shower. The backyard has no rear neighbors and a nice covered patio. This home is located close to medical facilities, various restaurants and shopping centers, I-10 and is across Cullen park. All measurements are approximate. Buyer to verify all measurements. BRAND NEW AC. High and dry. Never flooded!' ,`Acres` = '0.1991' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 37 BLK 2 PARK HARBOR ESTATES' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8674' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'MAYDE CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAYDE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MAYDE CREEK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Park Harbor Estates' ,`TaxAmount` = '5701' ,`TaxRate` = '2.4889' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665936114' WHERE `Matrix_Unique_ID` = '211563160' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-16T09:55:24.873' ,`MLSNumber` = '24980033' ,`ListAgentFullName` = 'William Fisher' ,`ListOfficeName` = 'Wyebrook Realty, LLC' ,`SellingAgentFullName` = 'Mustafa Shekhani' ,`SellingOfficeName` = 'NXTSQFT.COM' ,`Latitude` = '29.675310' ,`Longitude` = '-95.648537' ,`PhotoCount` = '28' ,`PostalCode` = '77498' ,`RoomCount` = '5' ,`ListPrice` = '355900.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Worfield' ,`StreetNumber` = '9414' ,`StreetSuffix` = 'Court' ,`City` = 'Sugar Land' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2704' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 5 bedroom, 3 Full bath home located in the desirable Kingsbridge Place neighborhood. Large corner lot with fruit trees, patio and fenced back yard make for a relaxing oasis for friends and family. Two primary suites with adjoining full baths allow for a large upstairs primary suite, with a downstairs guest suite or home office. Zoned to Top Ranked FBISD schools and located close to restaurants, shopping, and quick access to Westpark toll, US-59, or HWY 90.' ,`Acres` = '0.2562' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Mission Bend Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'KINGSBRIDGE PLACE SEC 1, BLOCK 2, LOT 26' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '11159' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '544' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`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,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Kingsbridge Place Sec 1' ,`TaxAmount` = '5232' ,`TaxRate` = '2.3389' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1993' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665936114' WHERE `Matrix_Unique_ID` = '211605821' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-16T08:14:02.500' ,`MLSNumber` = '12233316' ,`ListAgentFullName` = 'Juan Badillo' ,`ListOfficeName` = 'Berkshire Hathaway Home Svs.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.874418' ,`Longitude` = '-95.636735' ,`PhotoCount` = '35' ,`PostalCode` = '77084' ,`RoomCount` = '6' ,`ListPrice` = '300000.00' ,`Status` = 'Active' ,`StreetName` = 'Falmouth' ,`StreetNumber` = '15206' ,`StreetSuffix` = 'Avenue' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2352' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful two stories well maintained home is ready for a Family. House is ready to Move in and can obtain a fast-closing period. This house is very well located in the west side of Houston. Minutes from major shopping areas Home Depot and Lowes are down the street from the neighborhood. Great restaurants and shopping centers nearby. This home is located in the cy-fairs school district. This home is a gorgeous 3 bedroom 2 and half baths. Home has been newly updated with flooring, threw out the entire house and newly installed roof in 2021. Schedule you\'re showing today... You won\'t be disappointed! this home is ready to move in and enjoy.' ,`Acres` = '0.1249' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Eldridge North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 17 BLK 4 MAPLE TRACE SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5442' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '275' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'HORNE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'TRUITT MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Maple Trace Sec 01' ,`TaxAmount` = '5556' ,`TaxRate` = '2.591' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665936114' WHERE `Matrix_Unique_ID` = '211678006' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-16T08:26:38.997' ,`MLSNumber` = '65041817' ,`ListAgentFullName` = 'Patrick Burbridge' ,`ListOfficeName` = 'CitiQuest Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.801127' ,`Longitude` = '-95.480466' ,`PhotoCount` = '38' ,`PostalCode` = '77055' ,`RoomCount` = '3' ,`ListPrice` = '479000.00' ,`Status` = 'Active' ,`StreetName` = 'Jacquelyn Springs' ,`StreetNumber` = '1714' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2051' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Introducing VILLAS De Marbella | A community of two & three level contemporary residences. Four open floor plan options designed for the modern lifestyle, with living areas on the main level, 10’ ceilings & sliding glass doors opening to a sizable porch/private yard. Level I is complete w/ wide-plank luxury vinyl flooring, dine-in kitchen garnished w/ SS appliances, select plumbing fixtures, modern quartz countertops & euro style cabinetry. Level II features the Owners Primary Suite, two guest suites, & a vast utility room. The expansive window lined primary bedroom is complete w/ luxury vinyl flooring, a stunning bath complete with dual vanities, freestanding soaking tub, glass enclosed shower & a massive walk-in closet with built-ins. Substantial secondary bedrooms are both en-suite with walk-in closets & tub/shower combos. Please use 1720 Jacquelyn as address for GPS navigation. *THIS HOME IS MOVE IN READY*' ,`Acres` = '' ,`Area` = '24' ,`BuilderName` = 'Marbella / Greyden' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 10 BLOCK 1 ESTATES AT JACQUELYN' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '110' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'TREASURE FOREST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTHBROOK HIGH SCHOOL' ,`SchoolMiddle` = 'LANDRUM MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Spring Branch' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665936114' WHERE `Matrix_Unique_ID` = '211833856' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-16T09:48:59.120' ,`MLSNumber` = '55863045' ,`ListAgentFullName` = 'Denise Martinez' ,`ListOfficeName` = 'Keller Williams Laredo' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.638578' ,`Longitude` = '-96.061983' ,`PhotoCount` = '17' ,`PostalCode` = '77485' ,`RoomCount` = '5' ,`ListPrice` = '115000.00' ,`Status` = 'Active' ,`StreetName` = 'Margie' ,`StreetNumber` = '705' ,`StreetSuffix` = 'Street' ,`City` = 'Wallis' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '652' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The property sits on an oversized lot in a quiet neighborhood. Has great potential and space to add square footage to this property. An Investor’s gem! Located 30 minutes away from Katy Mills Mall. Call to schedule your showing today!!!' ,`Acres` = '0.29' ,`Area` = '57' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'HRANICKY SUB (OUT OF ABST 71) LOT 31' ,`LotDesciption` = 'Cleared' ,`LotSize` = '12810' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '54 - Brazos' ,`SchoolElementary` = 'BRAZOS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRAZOS HIGH SCHOOL' ,`SchoolMiddle` = 'BRAZOS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Temporarily No Showings' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Hranicky Sub' ,`TaxAmount` = '1273' ,`TaxRate` = '2.5395' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '0' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1665936115' WHERE `Matrix_Unique_ID` = '211858917' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-16T09:19:30.287' ,`MLSNumber` = '61353523' ,`ListAgentFullName` = 'Sally Beck' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.822317' ,`Longitude` = '-95.537763' ,`PhotoCount` = '40' ,`PostalCode` = '77080' ,`RoomCount` = '5' ,`ListPrice` = '385000.00' ,`Status` = 'Active' ,`StreetName` = 'Spring Shadows Park' ,`StreetNumber` = '9910' ,`StreetSuffix` = 'Circle' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2170' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'October 9th Open House Cancelled. Rescheduled for October 16th. Stunning three-story home in private gated community in desirable Spring Branch. Beautiful and spacious, energy efficient and low maintenance - this home has it all! The island kitchen is an entertainer’s dream that opens to the dining area and light-filled living room. Primary suite offers views of lush trees and the bath features separate tub and shower, two vanities, and a huge walk-in closet. First floor bedroom, with full bath, could be a great home office. Private fenced backyard with no back neighbors. Plenty of room for pets and children to play. Community offers abundant walking trails. Minutes away from 290, I-10 and Beltway 8, and close to upscale shopping and dining in City Centre.' ,`Acres` = '0.0596' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 53 BLK 1 PARK AT SPRING SHADOWS' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2594' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'SPRING SHADOW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTHBROOK HIGH SCHOOL' ,`SchoolMiddle` = 'SPRING WOODS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Park at Spring Shadows' ,`TaxAmount` = '7784' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665936115' WHERE `Matrix_Unique_ID` = '212316759' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-16T09:32:20.980' ,`MLSNumber` = '989522' ,`ListAgentFullName` = 'Bobbie Alexander' ,`ListOfficeName` = 'Alexander Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.687291' ,`Longitude` = '-95.714176' ,`PhotoCount` = '38' ,`PostalCode` = '77407' ,`RoomCount` = '10' ,`ListPrice` = '569041.00' ,`Status` = 'Active' ,`StreetName` = 'Hampden Meadow' ,`StreetNumber` = '17906' ,`StreetSuffix` = 'Circle' ,`City` = 'Richmond' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3254' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'REPRESENTATIVE PHOTOS ADDED. October Completion! The Cabernet in Grand Vista is an entertainer’s dream! Perfectly sized the home features five bedrooms, three and a half baths, a study, game room, and three car garage. The open concept layout has dining area, island kitchen, and great room flow seamlessly together to comfortably fit all your guests. With a courtyard and covered patio there is also plenty of space to dine and relax outside. Retreat to the spacious first-floor owner\'s suite that is perfectly tucked away for privacy with a large walk-in closet and spa-inspired bath! Upstairs are three secondary bedrooms, two baths, and a huge game room! Structural options include: study, extended owner\'s suite, open railing, bedroom five downstairs, 8’ interior doors on first floor and covered outdoor living 1.' ,`Acres` = '0.29' ,`Area` = '37' ,`BuilderName` = 'Taylor Morrison' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Mission Bend Area' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'GRAND VISTA SEC 18, BLOCK 3, LOT 4' ,`LotDesciption` = 'Cul-De-Sac,Greenbelt,Other,Water View' ,`LotSize` = '12993' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '850' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'PATTERSON ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'BUSH HIGH SCHOOL' ,`SchoolMiddle` = 'CROCKETT MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Grand Vista 50s' ,`TaxAmount` = '' ,`TaxRate` = '2.52' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665936115' WHERE `Matrix_Unique_ID` = '212348008' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-16T09:05:35.650' ,`MLSNumber` = '41975505' ,`ListAgentFullName` = 'Tanesha McKinley' ,`ListOfficeName` = 'Premier Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.542351' ,`Longitude` = '-95.173559' ,`PhotoCount` = '28' ,`PostalCode` = '77546' ,`RoomCount` = '10' ,`ListPrice` = '355000.00' ,`Status` = 'Active' ,`StreetName` = 'Sugar Bars' ,`StreetNumber` = '4415' ,`StreetSuffix` = 'Drive' ,`City` = 'Friendswood' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2499' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Back on the Market! Beautiful 2 Story, 4 Bedroom, 2.5 Bath, w/ Game Room, Formal Dining, Study and a Stunning Backyard Oasis Complete with a Pool, Covered Patio and Outdoor Kitchen! Tile and Wood Floors Throughout Downstairs, Open Concept Kitchen to the Family Room. Island Kitchen w/ Lots of Cabinet Space, Granite Counters and Stainless Steel Appliances. Large Primary Suite w/ His and Hers Closets and a Spacious En-suite Bath w/ a Garden Tub, Stand-up Shower and SO MUCH MORE!' ,`Acres` = '0.1515' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'HOA First Right of Refusal,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Friendswood' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 46 BLK 5 HERITAGE PARK SEC 18' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '256' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'LANDOLT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR BROOK HIGH SCHOOL' ,`SchoolMiddle` = 'WESTBROOK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Heritage Park' ,`TaxAmount` = '6294' ,`TaxRate` = '2.166' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1993' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665936115' WHERE `Matrix_Unique_ID` = '212385435' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-16T09:31:50.763' ,`MLSNumber` = '58965361' ,`ListAgentFullName` = 'Rachael Garnett' ,`ListOfficeName` = 'Malone Real Estate Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.510960' ,`Longitude` = '-95.184249' ,`PhotoCount` = '39' ,`PostalCode` = '77546' ,`RoomCount` = '6' ,`ListPrice` = '389000.00' ,`Status` = 'Active' ,`StreetName` = 'Pine Creek' ,`StreetNumber` = '302' ,`StreetSuffix` = 'Drive' ,`City` = 'Friendswood' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1725' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Set your eyes on this rare find in a quiet, gated community. Newly updated and situated on a corner lot with a circle driveway. The kitchen features a high end sub-zero fridge, room for an island and a two seat desk area with shelving above. The primary bedroom is spacious with vaulted ceilings and a walk in closet. Another bedroom connects via French doors, perfect for a flex space with access to the backyard. Roomy en-suite primary bath with a separate tub and new all glass enclosed shower. This house is in a rarely available neighborhood with nearby highly rated Friendswood ISD. If you\'re looking to downsize or are first time homebuyers this is the home for you! Easy access to highway, shopping, restaurants and nearby activities.' ,`Acres` = '0.162' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Friendswood' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 151 PAGE 11 LOT 1 BLK 4 PARKWOOD VILLAGE SEC 2' ,`LotDesciption` = 'Corner,Patio Lot,Subdivision Lot' ,`LotSize` = '7055' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '380' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas 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` = 'Accompany,Appointment Required,Lockbox Front,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Parkwood Village Sec 2 98' ,`TaxAmount` = '5698' ,`TaxRate` = '2.2832' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1997' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665936115' WHERE `Matrix_Unique_ID` = '212392807' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-16T08:05:46.907' ,`MLSNumber` = '60718182' ,`ListAgentFullName` = 'David Johnston' ,`ListOfficeName` = 'BHGRE Gary GreeneLeague City' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.546051' ,`Longitude` = '-95.404573' ,`PhotoCount` = '50' ,`PostalCode` = '77584' ,`RoomCount` = '15' ,`ListPrice` = '669000.00' ,`Status` = 'Active' ,`StreetName` = 'Linden Walk' ,`StreetNumber` = '11906' ,`StreetSuffix` = 'Lane' ,`City` = 'Pearland' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4407' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous Aston Woods home with private gated driveway. The grand foyer boasts 20\' ceilings with a spiral staircase and wrought iron spindles. The formal dining room and private office/study are to the right and left. A massive wall of windows greet your entrance to the living area which is open to an amazing chefs kitchen with an enormous island perfect for entertaining. The primary bedroom is a place of solitude and retreat with sitting area and extra large en-suite. Upstairs there is a massive game room complete with wet bar and a media room that is adjacent pre wired for sound. Beautiful nooks and works stations abound throughout the home. The back yard boasts a 20\' covered patio and large back yard perfect for activities. 3 additional bedrooms can accommodate all the family. Beautiful Plantation Shutters and hard wood floors are abundant. Front Door faces North. Builder Upgrades attached! Award winning schools. Located in one of the most desirable areas of Southern Trails.' ,`Acres` = '0.268' ,`Area` = '5' ,`BuilderName` = 'Ashton Woods' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SOUTHERN TRAILS SEC 14 (A0564 HT&BRR)(PEARLAND) BLK 2 LOT 22' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11674' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '908' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition,Tile' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'BROTHERS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SHADOW CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MCNAIR JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Back,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Southern Trails Sec 14' ,`TaxAmount` = '17782' ,`TaxRate` = '3.5109' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665936116' WHERE `Matrix_Unique_ID` = '212463616' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-16T08:38:50.770' ,`MLSNumber` = '41190913' ,`ListAgentFullName` = 'Cari Frazey' ,`ListOfficeName` = 'Keller Williams RealtyNortheast' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.188243' ,`Longitude` = '-95.156452' ,`PhotoCount` = '31' ,`PostalCode` = '77357' ,`RoomCount` = '7' ,`ListPrice` = '499000.00' ,`Status` = 'Active' ,`StreetName` = 'Constantine' ,`StreetNumber` = '2711' ,`StreetSuffix` = 'Street' ,`City` = 'New Caney' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2750' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful single story 4 bedroom 2.5 bath home in Roman Forest. Large kitchen island open to living room. Walk in pantry. This home features granite countertops throughout, tile flooring in main living areas, crown molding and trim. Large primary bath with dual sinks, oversized shower and freestanding soaking tub. Custom cabinets in master closet. Spacious secondary bedrooms with walk-in closets. Large secondary bath with dual sink and garden tub. Spacious laundry room with stainless utility sink. This home rests on a large, wooded lot, fully fenced back yard, with plenty of room to build your swimming pool or just enjoy the view from the covered patio. Texas sized garage will accommodate your vehicles and toys. Beautifully landscaped front yard. Easy access to Eastex Freeway and Grand Parkway 99. Short drive to Valley Ranch Town Center for great dining and shopping.' ,`Acres` = '0.4191' ,`Area` = '40' ,`BuilderName` = 'Gregory and Cari Fra' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Owner/Agent' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Porter/New Caney East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ROMAN FOREST 02, BLOCK 18, LOT 34' ,`LotDesciption` = 'Cleared' ,`LotSize` = '18258' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'DOGWOOD ELEMENTARY SCHOOL (NEW CANEY)' ,`SchoolHigh` = 'NEW CANEY HIGH SCHOOL' ,`SchoolMiddle` = 'KEEFER CROSSING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Roman Forest' ,`TaxAmount` = '531' ,`TaxRate` = '2.9064' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665936116' WHERE `Matrix_Unique_ID` = '212469465' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-16T08:47:43.037' ,`MLSNumber` = '95284889' ,`ListAgentFullName` = 'Paige Reinhard' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.533238' ,`Longitude` = '-95.023389' ,`PhotoCount` = '1' ,`PostalCode` = '77565' ,`RoomCount` = '7' ,`ListPrice` = '309000.00' ,`Status` = 'Active' ,`StreetName` = 'Oak Briar' ,`StreetNumber` = '615' ,`StreetSuffix` = 'Drive' ,`City` = 'Kemah' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1823' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to Kemah Oaks! Great location and zoned to desirable CCISD Education Village with a low tax rate. The neighborhood offers a community pool and great recreation park for all ages! This open concept home features 3 bedrooms with a study that can be used as a 4th bedroom. A large living and dining area with easy access to the kitchen, featuring an island and breakfast area, and a HUGE pantry you will not believe. The primary bedroom features an ensuite with double sinks, a garden tub, and separate shower. The home also features high ceilings, french doors leading to the patio with a pergola, great for those nights grilling in the backyard. And no need to worry about watering the yard with a sprinkler system on the property. Easy access to shopping, restaurants and Galveston Bay. This one is a must see!' ,`Acres` = '0.1446' ,`Area` = '33' ,`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` = 'League City' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 18 PAGE 15 LOT 18 BLK 9 KEMAH OAKS SUB' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6300' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '484' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'STEWART ELEMENTARY SCHOOL (CLEAR CREEK)' ,`SchoolHigh` = 'CLEAR FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'BAYSIDE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Kemah Oaks Sub 92' ,`TaxAmount` = '4662' ,`TaxRate` = '2.0134' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665936116' WHERE `Matrix_Unique_ID` = '212574879' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-16T08:27:34.300' ,`MLSNumber` = '71052295' ,`ListAgentFullName` = 'Tracy Roushey' ,`ListOfficeName` = 'Key 2 Texas Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.892978' ,`Longitude` = '-95.703394' ,`PhotoCount` = '33' ,`PostalCode` = '77433' ,`RoomCount` = '9' ,`ListPrice` = '290900.00' ,`Status` = 'Active' ,`StreetName` = 'Cholla Canyon' ,`StreetNumber` = '8118' ,`StreetSuffix` = 'Lane' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2548' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEWLY LISTED...***homes is also for Lease***Price Improvement. COME BY And SEE your new FAMILY gathering place!! Spacious home in the family friendly community of Yaupon Ranch. Near Towne Lake. Entertain in this gorgeous 3 bedroom, 2.5 bath home with plenty of living space. LIGHT and airy with an abundance of windows & OPEN concept to both living areas. Spacious bedrooms upstairs including a HUGE primary bedroom with en-suite bath/ walk-in closet. Upstairs Large Game room/Den for entertaining. Laundry room & Half bath located on first floor. WASHER/DRYER/FRIDGE included! NEW vinyl plank flooring throughout both upstairs and down. NEW carpet on stairs. Updated vanities & showers. Fresh paint. Walking distance to community pool! Located in an up-and-coming area, conveniently close to Houston Premium Outlets and Towne Lake Boardwalk near by. Easy access and short drive to HWY 290, 99, I-10.' ,`Acres` = '0.1427' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 3 BLK 2 YAUPON RANCH SEC 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6215' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '477' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'JOWELL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS SPRINGS HIGH SCHOOL' ,`SchoolMiddle` = 'HOPPER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Yaupon Ranch Sec 07' ,`TaxAmount` = '6380' ,`TaxRate` = '3.041' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665936116' WHERE `Matrix_Unique_ID` = '212661629' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-16T09:08:02.817' ,`MLSNumber` = '35289504' ,`ListAgentFullName` = 'Regina Davis Salinas' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.901358' ,`Longitude` = '-95.706602' ,`PhotoCount` = '40' ,`PostalCode` = '77433' ,`RoomCount` = '9' ,`ListPrice` = '340000.00' ,`Status` = 'Active' ,`StreetName` = 'Dunlay Springs' ,`StreetNumber` = '19514' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2542' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Schedule your appointment to view this immaculate 4 bedroom, 2.5 bath home. This home features an open concept. The spacious kitchen and breakfast room flows into a spacious family room with high ceilings. Primary suite is on the first floor with a walk-in closet and primary bath with dual sinks, garden tub and separate shower. \r\nThere are 3 bedrooms on second floor with a game room overlooking the family room. Schedule your appointment TODAY to view this beautiful home!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate,Mud' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 12 BLK 7 GATES AT CANYON LAKES WEST SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1140' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'ANDRE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS SPRINGS HIGH SCHOOL' ,`SchoolMiddle` = 'ANTHONY MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Gates/Canyon Lakes West' ,`TaxAmount` = '7158' ,`TaxRate` = '3.041' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665936116' WHERE `Matrix_Unique_ID` = '212663533' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-16T09:09:50.440' ,`MLSNumber` = '82156880' ,`ListAgentFullName` = 'Thomas Sharpe' ,`ListOfficeName` = 'Texas Shoreline Properties' ,`SellingAgentFullName` = 'Katherine Bahardoust' ,`SellingOfficeName` = 'FYI Realty' ,`Latitude` = '30.016906' ,`Longitude` = '-95.177881' ,`PhotoCount` = '39' ,`PostalCode` = '77346' ,`RoomCount` = '12' ,`ListPrice` = '359900.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Kings Clover' ,`StreetNumber` = '20918' ,`StreetSuffix` = 'Court' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2626' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful home in sought after Kings River Village and the perfect home & community to raise a family. Easy access to the greenbelts from it\'s quiet cul-de-sac location. Enter the home and be wowed by the open concept and soaring ceilings. Spacious home to entertain family and friends. Large media room and gameroom upstairs. New Hardy siding and exterior paint 2021 & new primary bedroom floors 2020. Step outback to enjoy your favorite beverage and a ball game on your covered patio. Location, location, location, short commute to schools, shopping, restaurants and entertainment. Conveniently located to W. Lake Houston Pky., IH-69 & the Grand Parkway. Minutes from Lake Houston for fishing and summer fun. Simply just a great Kingwood home and a great community to live in.' ,`Acres` = '0.1672' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Kingwood South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 18 BLK 1 KINGS RIVER VILLAGE SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7284' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '475' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'GREENTREE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KINGWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'CREEKWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Kings River Village' ,`TaxAmount` = '5962' ,`TaxRate` = '2.453' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '1994' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665936117' WHERE `Matrix_Unique_ID` = '212698955' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-16T09:21:36.193' ,`MLSNumber` = '45660688' ,`ListAgentFullName` = 'Janis Adams' ,`ListOfficeName` = 'RE/MAX Associates Northeast' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.057741' ,`Longitude` = '-95.199374' ,`PhotoCount` = '21' ,`PostalCode` = '77339' ,`RoomCount` = '8' ,`ListPrice` = '349000.00' ,`Status` = 'Active' ,`StreetName` = 'Willow Ridge' ,`StreetNumber` = '3418' ,`StreetSuffix` = 'Drive' ,`City` = 'Kingwood' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2422' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'AWESOME custom home in Bear Branch Village where every inch has been updated inc. lighting & hardware. Located on a quiet U shape street w/in walking distance to greenbelt and schools. Gated & walled front courtyard area, offers a great spot to wind down/start the day. Family room has high ceilings, an abundance of windows that let in the natural light & a beautiful fireplace feature. The formal dining (used now as office) is also light & bright. Kitchen has plenty of cabinets, updated SS appliances, and convenient breakfast nook overlooking the great backyard w/huge covered patio(comprising of wood ceiling and composite floor), a wonderful place for family time/entertaining. The primary suite is large & private, the ensuite has dual sinks, a separate vanity & huge shower w/seat. The good sized secondary bedrooms share the upstairs bathroom, the sink area is separated from the tub by a door. Walking distance to elementary & middle schools, greenbelt, pool & shopping. Storage shed.' ,`Acres` = '0.2306' ,`Area` = '32' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Kingwood West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 13 BLK 42 BEAR BRANCH VILLAGE SEC 4' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot,Wooded' ,`LotSize` = '10043' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '475' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'BEAR BRANCH ELEMENTARY SCHOOL (HUMBLE)' ,`SchoolHigh` = 'KINGWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'CREEKWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Bear Branch Village' ,`TaxAmount` = '5685' ,`TaxRate` = '2.5839' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665936117' WHERE `Matrix_Unique_ID` = '212733017' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-16T09:24:06.670' ,`MLSNumber` = '58870989' ,`ListAgentFullName` = 'Cortni Emanuel' ,`ListOfficeName` = 'Peters Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.511649' ,`Longitude` = '-95.518203' ,`PhotoCount` = '40' ,`PostalCode` = '77459' ,`RoomCount` = '12' ,`ListPrice` = '1284000.00' ,`Status` = 'Active' ,`StreetName` = 'Westpoint' ,`StreetNumber` = '23' ,`StreetSuffix` = 'Drive' ,`City` = 'Missouri City' ,`BathsFull` = '4' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '4920' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous home in the prestigious Westpoint Estates in Sienna. This home offers spectacular living in a secluded location. Situated on just under 2 acres. This property is for buyers that love elegance. As you enter this beauty, you are met with a dramatic grand entrance and high ceilings. SWEEPING views from every angle of the house. Over 350k worth of upgrades! Relax and entertain in the extravagant wet bar. The chef’s kitchen is finished with quartz countertops and state-of-the-art appliances. Designer custom features are throughout the home. This home offers a luxurious grand master bedroom and ensuite with a fireplace, lighted mirrors, and seamless shower glass with his and her closets. Additional bedroom and ensuite on the first floor for guests. As you make your way up the custom spiral staircase to the multipurpose game room, the views over the home are breathtaking. While in the game room, walk out on your new balcony and imagine your lavish Infinity Edge Pool & Jacuzzi.' ,`Acres` = '1.831' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'WESTPOINT ESTATES SEC 1, BLOCK 1, LOT 1, ACRES 1.831' ,`LotDesciption` = 'Corner,In Golf Course Community,Water View' ,`LotSize` = '79758' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'SIENNA CROSSING ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'BAINES MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Westpoint Estates Sec 1' ,`TaxAmount` = '15296' ,`TaxRate` = '2.34' ,`WaterSewer` = 'Aerobic' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665936117' WHERE `Matrix_Unique_ID` = '212746061' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-16T09:58:03.197' ,`MLSNumber` = '29733019' ,`ListAgentFullName` = 'Robert Downey' ,`ListOfficeName` = 'Benevides & Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.635529' ,`Longitude` = '-95.762591' ,`PhotoCount` = '32' ,`PostalCode` = '77406' ,`RoomCount` = '8' ,`ListPrice` = '557000.00' ,`Status` = 'Active' ,`StreetName` = 'Cooper Hawk' ,`StreetNumber` = '2907' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3410' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Like new home with many sought after upgrades (see attachment)! Located in the bustling and building community of McCrary Meadows, this 2-story has a brick and stone façade with a covered front porch and large back patio. Sporting a tandem garage this space proves practical as a work or 3rd vehicle area . Coming inside , the flooring is all ceramic tile downstairs and carpet in bedrooms upstairs. Counters in primary bath and kitchen are quartz. Utility room, 2nd, 3rd, and half baths all have granite counters. Located in the LCISD school district, the feed provides well-respected schools. Come check out this beauty!' ,`Acres` = '0.1722' ,`Area` = '37' ,`BuilderName` = 'Devon Street' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'MCCRARY MEADOWS SEC 2 PARTIAL REPLAT NO 1 AND EXTENSION, BLO' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'FROST ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'FOSTER HIGH SCHOOL' ,`SchoolMiddle` = 'WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Mccrary Meadows Sec 2 Pt Rep 1 & Ext' ,`TaxAmount` = '3030' ,`TaxRate` = '2.8548' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665936117' WHERE `Matrix_Unique_ID` = '212782836' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-16T09:55:22.703' ,`MLSNumber` = '78813332' ,`ListAgentFullName` = 'Hung Dang' ,`ListOfficeName` = 'The Realty' ,`SellingAgentFullName` = 'Hai Huynh' ,`SellingOfficeName` = 'Keller Williams Signature' ,`Latitude` = '29.928267' ,`Longitude` = '-95.667191' ,`PhotoCount` = '43' ,`PostalCode` = '77095' ,`RoomCount` = '4' ,`ListPrice` = '409999.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Lyndon Meadows' ,`StreetNumber` = '10626' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2841' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Say less... and come view this luxury listing. Nested in the beautiful subdivision of Stone gate. The gated community offers 18 hole golf course, two swimming pools, full size basketball court, tennis court, and park. The property offers fresh paint, soaring ceilings, laminate/tile flooring, recessed lighting and granite counter tops. Not only invest in this beautiful residence but also your children, schools of all tiers are 5 star rating and above. Conveniently located near by eateries, entertainment, shopping malls, and major roads such as Highway 6, 290 and Barker Cypress Rd.' ,`Acres` = '0.1427' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Copperfield Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 7 BLK 2 STONE GATE SEC 16' ,`LotDesciption` = 'Cleared' ,`LotSize` = '6216' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'BIRKES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'SPILLANE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Stone Gate Sec 16' ,`TaxAmount` = '6445' ,`TaxRate` = '2.561' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665936117' WHERE `Matrix_Unique_ID` = '212801646' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-16T08:51:04.540' ,`MLSNumber` = '36095477' ,`ListAgentFullName` = 'Michelle Hinton' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.761232' ,`Longitude` = '-95.593765' ,`PhotoCount` = '50' ,`PostalCode` = '77079' ,`RoomCount` = '13' ,`ListPrice` = '1698900.00' ,`Status` = 'Active' ,`StreetName` = 'Rancho Bauer' ,`StreetNumber` = '409' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '8' ,`BathsHalf` = '0' ,`BedsTotal` = '6' ,`SqFtTotal` = '7704' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Surrounded by mature foliage and characterized by its clean lines and seamless integration w/ nature, this custom-built modern masterpiece sits on a secluded cul-de-sac in west Memorial. Bathed in natural light featuring walls of glass that perfectly fuse the sleek interior with the wooded exterior. Tastefully updated with a modern flare, this impressive home features a floating staircase, hardwood floors, soaring ceilings, stunning chandeliers & ample space for entertaining. Renovated kitchen w/ Miele appliances, wood cabinetry & breakfast bar. Oversized 2-story family rm w/ built-ins, stone fireplace, formal dining & living, bar, private study w/ fireplace. All w/ floor-to-ceiling views. Primary Suite w/ updated bath & 2nd bedroom down. Generously sized game room + 4 bedrooms w/ ensuites upstairs. Outside is a wooded backyard w/ walking access to Buffalo Bayou, 3+ car garage & additional gated parking. Dbl pane windows, well & city water. Only garage level flooding, per Seller.*' ,`Acres` = '0.7127' ,`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 West' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 20 BLK 1 MEMORIAL DRIVE ACRES' ,`LotDesciption` = 'Greenbelt,Subdivision Lot,Wooded' ,`LotSize` = '31044' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'MEADOW WOOD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'STRATFORD HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'SPRING FOREST MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Memorial Drive Acres' ,`TaxAmount` = '23763' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water,Well' ,`YearBuilt` = '1989' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665936118' WHERE `Matrix_Unique_ID` = '212841666' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-16T08:34:41.047' ,`MLSNumber` = '17223679' ,`ListAgentFullName` = 'Tri Tran' ,`ListOfficeName` = 'Coldwell Banker Realty, Cy-Fair Office' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.014377' ,`Longitude` = '-95.420631' ,`PhotoCount` = '47' ,`PostalCode` = '77073' ,`RoomCount` = '7' ,`ListPrice` = '315000.00' ,`Status` = 'Active' ,`StreetName` = 'Mission Ridge' ,`StreetNumber` = '16943' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '3592' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to the gorgeous 5 bed & 3 bath home, Tile & Laminate are in the living area, spacious kitchen has tones of cabinet space, granite countertops. Large master bedroom suite, with 2 walk-in closets, separate shower, double sinks and whirlpool tub, plus with 3 additional bedrooms upstairs & a game room make the home being exclusive when having 2 living spaces, one for adults and one for kids. 5th bedroom could turn into the study/office- working from home would be a great idea.' ,`Acres` = '0.132' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Aldine Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 11 BLK 9 IMPERIAL RIDGE SEC 1' ,`LotDesciption` = 'Cleared' ,`LotSize` = '5750' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'CAROLEE BOOKER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ANDY DEKANEY H S' ,`SchoolMiddle` = 'RICKY C BAILEY M S' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Imperial Ridge' ,`TaxAmount` = '6496' ,`TaxRate` = '2.7292' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665936118' WHERE `Matrix_Unique_ID` = '212872516' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-16T08:11:07.797' ,`MLSNumber` = '92655091' ,`ListAgentFullName` = 'Brian Kuhn' ,`ListOfficeName` = 'Coldwell Banker TGRE' ,`SellingAgentFullName` = 'Diane Moore' ,`SellingOfficeName` = 'BHGRE Gary Greene' ,`Latitude` = '29.276127' ,`Longitude` = '-94.837263' ,`PhotoCount` = '50' ,`PostalCode` = '77551' ,`RoomCount` = '6' ,`ListPrice` = '385000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Heards Lane' ,`StreetNumber` = '2015' ,`StreetSuffix` = 'Circle' ,`City` = 'Galveston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1690' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Remarkable split level home on a quiet cul de sac conveniently located close to 61st St, Moody Gardens, and Offat\'s Bayou. This home sits on a huge lot with lots of yard space, a circle drive in the front and private driveway access in the rear. Recently updated kitchen with stylish quartz countertops, a large central island, and stainless steel appliances. Spacious living room for your sectional and entertainment set. Upstairs primary with ensuite bathroom and private deck to enjoy your morning coffee. Downstairs the garage has been converted into a garage apartment or guest suite with its own bathroom and kitchenette. This could provide additional rental income or a great place for the in laws to stay. It could also be converted back into garage space.' ,`Acres` = '0.1651' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Near West End' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 121 HALL & JONES SUR LOT 5 HEARDS LANE SUB REPLAT' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '7191' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`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' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Other Style' ,`Subdivision` = 'Heards Lane Circle' ,`TaxAmount` = '2595' ,`TaxRate` = '2.0662' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665936118' WHERE `Matrix_Unique_ID` = '212873997' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-16T08:56:08.843' ,`MLSNumber` = '78196599' ,`ListAgentFullName` = 'Roseann Johnson' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.501111' ,`Longitude` = '-95.533820' ,`PhotoCount` = '50' ,`PostalCode` = '77459' ,`RoomCount` = '11' ,`ListPrice` = '575000.00' ,`Status` = 'Active' ,`StreetName` = 'Dewalt Way' ,`StreetNumber` = '3806' ,`StreetSuffix` = '' ,`City` = 'Missouri City' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '4432' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Meticulously cared for home with 2 primary bedrooms, one down & and one up. 2 bedrooms downstairs, both with full baths. Barn doors separate the downstairs guest bedroom for complete privacy & upstairs primary bedroom suite as well. Fresh interior paint. 3 year old roof. Hot water heaters & AC units 2021. Carpet up only. Oversized kitchen & eating area with tile floors, SS appliances, granite counters, double ovens, custom pantry. Formal dining room & designated study with wood floors & plantation shutters. Primary bedroom down has closet with built-in storage. Primary bath with double sinks, separate tub & shower. Primary bedroom up has added huge closet with built ins, vinyl plank floors. Recently Updated primary bath features huge walk- in shower. Secondary bedroom up with full bath & flex room can be used as 5th bedroom. Large stone patio & pergola cover. 3 car garage. Tree shaded lot.' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'Newmark' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Levee District,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Sienna Steep Bank Village blk 2 lot 7' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot' ,`LotSize` = '13924' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'SIENNA CROSSING ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'BAINES MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sienna' ,`TaxAmount` = '11124' ,`TaxRate` = '2.57' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665936118' WHERE `Matrix_Unique_ID` = '212955522' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-16T08:28:03.360' ,`MLSNumber` = '37728759' ,`ListAgentFullName` = 'Tisha Matticks' ,`ListOfficeName` = 'Matticks Real Estate &' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.493155' ,`Longitude` = '-95.025040' ,`PhotoCount` = '45' ,`PostalCode` = '77371' ,`RoomCount` = '7' ,`ListPrice` = '275000.00' ,`Status` = 'Active' ,`StreetName` = 'Hickory Creek' ,`StreetNumber` = '211' ,`StreetSuffix` = 'Drive' ,`City` = 'Shepherd' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1596' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Enjoy this quite Brick Single Family Home located in the serenity of Sam Houston Forest located not far away. Three bedroom, two baths, dining area with living with a wood burning fireplace and mantel. Kitchen with lots of cabinets and U-shape counter space. Fridge (dated fridge, good as a secondary fridge) will remain with property. Master Bedroom consist of a Window AC for those that like rooms extra cold without freezing the guest bedrooms.\r\nDouble vehicle garage, with a double vehicle carport. Small workshop in the rear of the garage. Lots of back yard, large enough to add a swimming pool. Back & Front Porch. Garden area around the side and front for all you Garden Growing Farmers. The owner put extra money into his driveway so it will last for many years out. This home is none restricted and easy access to Hwy 150 or FM 2025. All furniture is For Sale as well.' ,`Acres` = '0.3874' ,`Area` = '64' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Coldspring/South San Jacinto County' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'COZY FOREST, BLOCK A, LOT 10 & 11, the N 25\'' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '16875' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '130 - Shepherd' ,`SchoolElementary` = 'SHEPHERD PRIMARY SCHOOL' ,`SchoolHigh` = 'SHEPHERD HIGH SCHOOL' ,`SchoolMiddle` = 'SHEPHERD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cozy Forest' ,`TaxAmount` = '2528' ,`TaxRate` = '1.8509' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '1987' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1665936118' WHERE `Matrix_Unique_ID` = '213022055' --> 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','213035300','1665936119','213035300','2022-10-16T08:44:24.403','40669452','Cynthia Hill','Keller Williams Realty - Memorial','','','29.619546','-95.197675','21','77034','6','250000.00','Active','Garlenda','13126','Lane','Houston','2','1','3','1439','Single-Family','3/2.5/2 Move-in ready home in a cul-de-sac. All bedrooms upstairs. Great covered patio and new fence in the sweet backyard. Roof, AC, water heater, downstairs floors all replaced! New range, microwave and dishwasher. The location is incredibly convenient to hospital, schools, restaurants and shopping. Not in a flood zone. And Galveston beach is a 40 minute drive away! Welcome home!','0.0763','3','','','','','Mud,Sellers Disclosure','1','','1','Southbelt/Ellington','Central Gas','1','LT 35 BLK 1 SOUTHWAY SEC 2 AMEND','Cul-De-Sac,Subdivision Lot','3323','Appraisal District','','380','0','','2','Gas Oven','0','','','','','Composition','41 - Pasadena','GENOA ELEMENTARY SCHOOL','MEMORIAL HIGH SCHOOL (PASADENA)','BONDY INTERMEDIATE SCHOOL','Appointment Required,Lockbox Front','Appraisal District','2','Contemporary/Modern','Southway','4857','2.6863','Public Sewer,Public Water','2004','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-16T08:01:40.650' ,`MLSNumber` = '70899003' ,`ListAgentFullName` = 'Tracy Murski' ,`ListOfficeName` = 'Southern Realty Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.780096' ,`Longitude` = '-95.636538' ,`PhotoCount` = '35' ,`PostalCode` = '77079' ,`RoomCount` = '9' ,`ListPrice` = '529000.00' ,`Status` = 'Active' ,`StreetName` = 'Barkers Landing' ,`StreetNumber` = '15750' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2281' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The jewel of the highly desirable community of Barkers Landing! This beautifully remodeled one story home, on a corner lot, has been completely redone - taken down to just the walls. Spectacular kitchen, that opens to the living area, has stainless steel KitchenAid appliances - refrigerator, gas range, convection oven with cooking drawer, microwave drawer (Sharp), as well as space left for a wine fridge. New doors, windows, sliding glass doors, gutters, garage door, PEX pipe & HVAC system. High ceilings, wood-burning/gas log fireplace & recessed lighting. Bergamo French Oak flooring with decorative tile in the bathrooms and utility room. New irrigation system installed - private patio through sliding glass doors from the kitchen for alfresco dining and enjoying. Barkers Landing has it\'s own 24/7 Security Patrol. Walking distance to the neighborhood pool, tennis courts, pickleball and playground - as well as the Grigsby restaurants nearby. This house is a showplace!' ,`Acres` = '0.1376' ,`Area` = '23' ,`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` = 'Energy Corridor' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 9 BLK 3 BARKERS LANDING SEC 1' ,`LotDesciption` = 'Corner,Patio Lot,Subdivision Lot,Wooded' ,`LotSize` = '5992' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1045' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'WOLFE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TAYLOR HIGH SCHOOL (KATY)' ,`SchoolMiddle` = 'MEMORIAL PARKWAY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Barkers Landing Sec 01' ,`TaxAmount` = '7447' ,`TaxRate` = '2.4889' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665936119' WHERE `Matrix_Unique_ID` = '213047643' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-16T09:54:24.690' ,`MLSNumber` = '90413423' ,`ListAgentFullName` = 'Ryan Barker' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.950843' ,`Longitude` = '-95.514248' ,`PhotoCount` = '41' ,`PostalCode` = '77066' ,`RoomCount` = '11' ,`ListPrice` = '275000.00' ,`Status` = 'Active' ,`StreetName` = 'Sutter Park' ,`StreetNumber` = '6614' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2224' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Mature trees surround 6614 Sutter Park Ln. in the quiet, established neighborhood of Cutten Green. Zoned to excellent Klein ISD schools, this family friendly home is the epitome of comfort and affordability. The home features a spacious living room, oversized primary bedroom, tile floors for easy maintenance, new AC, fresh paint, and a serene back yard oasis! This home has 4 bedrooms and 2.5 bathrooms. Close proximity to 249, I-45, Sam Houston Tollway, and Willowbrook Mall! NEVER FLOODED! Come see this home soon, it won\'t be available for long!' ,`Acres` = '0.1667' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '1960/Cypress Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 32 BLK 4 017*C7917560-001-004-032 CUTTEN GREEN SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7260' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '525' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'KLENK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN FOREST HIGH SCHOOL' ,`SchoolMiddle` = 'WUNDERLICH INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'French' ,`Subdivision` = 'Cutten Green Sec 01' ,`TaxAmount` = '4921' ,`TaxRate` = '2.5008' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665936119' WHERE `Matrix_Unique_ID` = '213059145' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-16T09:21:33.073' ,`MLSNumber` = '68240703' ,`ListAgentFullName` = 'Gloria Nino' ,`ListOfficeName` = 'Nino Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.744282' ,`Longitude` = '-95.420023' ,`PhotoCount` = '48' ,`PostalCode` = '77019' ,`RoomCount` = '12' ,`ListPrice` = '2199000.00' ,`Status` = 'Active' ,`StreetName` = 'Reba' ,`StreetNumber` = '3023' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3460' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Lovely 4-Bedroom/3.5 Bath River Oaks area home. Walking distance and zoned to award winning River Oaks Elementary. Home updated over the years. Sold \"as is\" per seller. Wonderful opportunity to renovate home to fit your lifestyle OR build your dream home on rare oversized 11,670 sq. ft. (per HCAD) luxury site. Lovely oak floors throughout home. Lots of natural light. Garage quarters provides additonal spacious bedroom, bath & kitchenette; ideal private living for guests, nanny, caretaker or family member. Lovely craftsmanship throughout vintage home. Spacious first floor living including den/home office. Lovely flow for entertaining family and guests. Second floor living quarters and laundry with soaking sink. Premiere luxury location with new construction and beautifully renovated homes in the area. Minutes from DT, Med Ctr, Galleria & Greenway business districts. Easy access to primary arteries and highways. Walkable proximity to many parks, green spaces, shopping, and dining.' ,`Acres` = '0.2679' ,`Area` = '16' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'River Oaks Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 6 & TRS 5 & 7A BLK C AVALON PLACE SEC 2' ,`LotDesciption` = 'Wooded' ,`LotSize` = '11670' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'RIVER OAKS ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LANIER MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Avalon Place Sec 02' ,`TaxAmount` = '33506' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1935' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665936119' WHERE `Matrix_Unique_ID` = '213071327' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-16T09:13:21.053' ,`MLSNumber` = '29279167' ,`ListAgentFullName` = 'Thurman Nassoiy' ,`ListOfficeName` = 'Worth Clark Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.776551' ,`Longitude` = '-95.420673' ,`PhotoCount` = '23' ,`PostalCode` = '77007' ,`RoomCount` = '10' ,`ListPrice` = '425000.00' ,`Status` = 'Active' ,`StreetName` = 'Nolda' ,`StreetNumber` = '5516' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2000' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to your new home! You are close to everything and part of a wonderful gated community! Enter to find an open-concept living, dining, and kitchen area that\'s ideal for entertaining. The well-equipped kitchen has granite countertops, stainless appliances (including new microwave, 2022) and the refrigerator is included! Upstairs you\'ll find two spacious secondary bedrooms with a generous secondary bath. Fall in love the secluded primary suite complete with a generous bedroom area that basks in natural light, an expansive closet, and an ensuite bathroom with large tub, separate shower, and extended vanity with dual sinks. The second-floor utility room eliminates carrying laundry up and down the stairs. Outside, you\'ll find a beautiful low-maintenance patio and the patio furniture is also included! This home is everything you need and ready for you to make fabulous new memories!' ,`Acres` = '0.0471' ,`Area` = '16' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Rice Military/Washington Corridor' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 13 BLK 1 NOLDA TERRACE T/H' ,`LotDesciption` = 'Patio Lot' ,`LotSize` = '2050' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '995' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas 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` = 'Accompany,Appointment Required,Controlled Access,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Nolda Terrace Twnhms' ,`TaxAmount` = '7929' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665936119' WHERE `Matrix_Unique_ID` = '213127348' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-16T08:37:00.837' ,`MLSNumber` = '90541905' ,`ListAgentFullName` = 'Laura Truitt' ,`ListOfficeName` = 'Keller Williams Realty - Clear Lake/ NASA' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.649516' ,`Longitude` = '-95.241176' ,`PhotoCount` = '33' ,`PostalCode` = '77034' ,`RoomCount` = '7' ,`ListPrice` = '170000.00' ,`Status` = 'Active' ,`StreetName` = 'Elton' ,`StreetNumber` = '1203' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '947' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come check out this charming home boasting 1950s charm with its hard wood floors throughout and specialty elements such as the telephone nook in the hallway. This house uses every inch of its square footage to serve its owners. Spacious front and back yard. Replaced HVAC, furnace and all new duct work in December 2017. This house did not flood during Harvey!\r\n\r\nCome check out this property with great potential!' ,`Acres` = '0.1584' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Hobby Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 28 BLK 2 FREEWAY MANOR SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6900' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'MATTHYS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SOUTH HOUSTON HIGH SCHOOL' ,`SchoolMiddle` = 'SOUTHHOUSTON INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Freeway Manor Sec 01' ,`TaxAmount` = '3035' ,`TaxRate` = '2.6863' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1954' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665936119' WHERE `Matrix_Unique_ID` = '213225943' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-16T08:49:45.400' ,`MLSNumber` = '26198317' ,`ListAgentFullName` = 'Melissa Cruz' ,`ListOfficeName` = 'Keller Williams Woodlands' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.663910' ,`Longitude` = '-95.512186' ,`PhotoCount` = '16' ,`PostalCode` = '77071' ,`RoomCount` = '9' ,`ListPrice` = '350000.00' ,`Status` = 'Active' ,`StreetName` = 'Braesridge' ,`StreetNumber` = '7703' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2740' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Investor opportunity! Spacious Tudor-style home on a generous cul-de-sac lot with 3 bedrooms, 2.5 baths, and 2 car detached garage. Foyer opens to formal living and den with gas-log fireplace. Nice sized kitchen with plenty of cabinets and a corner pantry for storage. Formal dining room and separate breakfast room both located off the kitchen. Owner’s suite is downstairs with en-suite bath, dual sink vanity, and two walk-in closets. Upstairs is the large game room with built-in storage shelves and desk, 2 additional bedrooms and 1 full bath. Easy commute to Hwy 59, Beltway 8, 610 loop, NRG stadium, and Medical Center. Tenant occupied with lease ending 2/28/2023.' ,`Acres` = '0.253' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure,Tenant Occupied' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Brays Oaks' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 8 BLK 3 FONDREN SW NORTHFIELD SEC 3' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '11020' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '544' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'MILNE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SHARPSTOWN HIGH SCHOOL' ,`SchoolMiddle` = 'WELCH MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Fondren Sw Northfield' ,`TaxAmount` = '5435' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1975' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665936120' WHERE `Matrix_Unique_ID` = '213231492' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-16T08:03:15.340' ,`MLSNumber` = '10302124' ,`ListAgentFullName` = 'Jennifer Gayle Spence' ,`ListOfficeName` = 'MVP Realty & Associates' ,`SellingAgentFullName` = 'Lily Trevino' ,`SellingOfficeName` = 'MVP Realty & Associates' ,`Latitude` = '30.073740' ,`Longitude` = '-95.405915' ,`PhotoCount` = '31' ,`PostalCode` = '77373' ,`RoomCount` = '4' ,`ListPrice` = '269900.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Friar Lake' ,`StreetNumber` = '25518' ,`StreetSuffix` = 'Lane' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1844' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Seller has verbally accepted an offer. No More Showings. Beautifully updated 4 bedroom, 2 bath home in desired Lexington Woods Subdivision. This home sits on a fabulous 9,000 sq ft lot w/ established Oak trees. Recently installed tile flooring, carpet, paint, kitchen sink, fixtures throughout, lighting, remodeled bathrooms, custom Low-E windows & so much more. This well designed open floor plan offers spacious living indoors & out. Elegant entryway leads to spacious living area w/built-in cabinets & an amazing oversized window facing back patio. Kitchen has granite countertops & stainless steel dishwasher. Great room can be dedicated to office or secondary living space. Modern formal dining area w/ beautiful light fixture & accent wall. Large primary suite w/new sliding barn door. Remodeled bathroom w/glass enclosed shower & tile. Plenty of storage & closet space. Pool size backyard w/ patio. Oversize detached garage. No flooding. Nearby park w/walking trails, dog park & fishing.' ,`Acres` = '0.2213' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 6 BLK 4 LEXINGTON WOODS SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9638' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '465' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'JOHN WINSHIP ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'TWIN CREEKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lexington Woods' ,`TaxAmount` = '3696' ,`TaxRate` = '2.2769' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1971' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665936120' WHERE `Matrix_Unique_ID` = '213253736' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-16T09:44:14.237' ,`MLSNumber` = '60158521' ,`ListAgentFullName` = 'Tara Hanel' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.108080' ,`Longitude` = '-94.916147' ,`PhotoCount` = '36' ,`PostalCode` = '77535' ,`RoomCount` = '3' ,`ListPrice` = '578000.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 676' ,`StreetNumber` = '982' ,`StreetSuffix` = '' ,`City` = 'Dayton' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1674' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '25 ACRES!! This 3 bedroom 2 bath home on 25 Acres is a great opportunity for anyone looking for property with acreage. The long private drive, built to handle an 18 wheeler load, leads you back to this ranch style home.The grand wood burning fireplace is perfect for cozy winter nights, and the fence and cross fenced is ideal for any animals/livestock you would like to raise. There is a bonus outside room with electricity that would be perfect for storage, personal gym, etc, it has a 220 plug so you could easily put a hot tub inside or out. Bonus: there is a private drive, from the road, on the property that leads to a 3 bay storage building, has a slab for mobile home with septic and could easily be ready for relatives or income producing. Never flooded and not in the flood plain.' ,`Acres` = '25.03' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Dayton' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = '000849 W F FISHER, TRACT 5, ACRES 25.03' ,`LotDesciption` = 'Cleared,Wooded' ,`LotSize` = '1090306' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '74 - Dayton' ,`SchoolElementary` = 'STEPHEN F. AUSTIN ELEMENTARY SCHOOL (DAYTON)' ,`SchoolHigh` = 'DAYTON HIGH SCHOOL' ,`SchoolMiddle` = 'WOODROW WILSON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'W F Fisher' ,`TaxAmount` = '3445' ,`TaxRate` = '1.7512' ,`WaterSewer` = 'Aerobic,Well' ,`YearBuilt` = '1996' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665936120' WHERE `Matrix_Unique_ID` = '213254574' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-16T09:04:21.923' ,`MLSNumber` = '27030613' ,`ListAgentFullName` = 'Brandi Bryant' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.089212' ,`Longitude` = '-94.862091' ,`PhotoCount` = '46' ,`PostalCode` = '77535' ,`RoomCount` = '9' ,`ListPrice` = '750000.00' ,`Status` = 'Active' ,`StreetName` = 'Fm 1008' ,`StreetNumber` = '2555' ,`StreetSuffix` = '' ,`City` = 'Dayton' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2240' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home! This custom built home is luxurious. from the moment you walk in the front door the attention to detail is seen. From the vaulted ceilings to the custom cabinetry. Relax after a along day in the soaking tub or over-sized shower with custom drift wood detail. Spend your evenings working in your over sized shop with 11000 lb bi-axle lift, it is every car lovers dream! Enjoy all the benefits of country living with quick access to the city! Home is located 40 minutes from down town Houston, hop on 99 and be in the Woodlands in 40 minutes and just a 45 minute drive to Beaumont.' ,`Acres` = '5.01' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Dayton' ,`HeatSystem` = 'Propane' ,`HOAMandatory` = '0' ,`Legal` = 'WHITE OAK TRAILS, SEC 1, LOT 7, ACRES 5.01' ,`LotDesciption` = 'Wooded' ,`LotSize` = '218236' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '74 - Dayton' ,`SchoolElementary` = 'RICHTER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DAYTON HIGH SCHOOL' ,`SchoolMiddle` = 'WOODROW WILSON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Right Side,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'White Oak Trails' ,`TaxAmount` = '9708' ,`TaxRate` = '1.7512' ,`WaterSewer` = 'Aerobic' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665936120' WHERE `Matrix_Unique_ID` = '213266031' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-16T09:58:41.540' ,`MLSNumber` = '31272790' ,`ListAgentFullName` = 'Bradley Upshaw' ,`ListOfficeName` = 'Haven Realty International' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.165651' ,`Longitude` = '-95.545906' ,`PhotoCount` = '50' ,`PostalCode` = '77375' ,`RoomCount` = '10' ,`ListPrice` = '610000.00' ,`Status` = 'Active' ,`StreetName` = 'SUNDOWN RIDGE PLACE' ,`StreetNumber` = '113' ,`StreetSuffix` = '' ,`City` = 'Tomball' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3105' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'THE GORGEOUS ONE-STORY HOME YOU\'VE BEEN WAITING FOR in the private, gated enclave of Timarron Lakes-The Woodlands. The STUNNING STUCCO ELEVATION with castle-like turret is just the beginning...a wrought-iron gate opens to the covered entrance leading to an elegant leaded-glass front door PLUS a second private casita/guest entrance. The main living space in this wonderful open plan features a cathedral ceiling accentuated by wood beams, wood floors & abundant natural light streaming through a wall of glass doors & windows. The TEXAS-SIZE KITCHEN features a huge island, custom soft-close cabinets, huge walk-in pantry & gas cooking...the Study has French doors, hardwoods and octagonal tray ceiling...the PRIVATE MASTER RETREAT offers a flex space and LUXURIOUS MASTER BATH with oversized jetted tub & shower. Spacious bedrooms all with private baths & walk-in closets. Outside: a covered patio with romantic fireplace. BACKS TO A RESERVE. Take the 3D Video Tour! Schedule a private tour today!' ,`Acres` = '0.1905' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 22 BLK 1 THE WOODLANDS CREEKSIDE PARK WEST 16' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '8299' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'TIMBER CREEK ELEMENTARY SCHOOL (Tomball)' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'CREEKSIDE PARK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Lockbox Front,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Mediterranean' ,`Subdivision` = 'The Woodlands Creekside Park West 16' ,`TaxAmount` = '9714' ,`TaxRate` = '2.6895' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665936120' WHERE `Matrix_Unique_ID` = '213292469' --> 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','213320307','1665936121','213320307','2022-10-16T08:22:14.033','4892326','John Arriaga','5th Stream Realty','','','29.756630','-95.633457','48','77077','9','650000.00','Active','Briar Heath','14006','Drive','Houston','3','1','4','3519','Single-Family','Gorgeous 4 bedroom, 3.5 baths, TWO STORY home on a cul-de-sac in the heart of Energy Corridor. Former model home, in Parkway Villages in the heart of Energy Corridor. Original owners have cared for this property and now it\'s ready for it\'s second owners. This homes boasts 3,500 sq feet of living space, large bedrooms with a primary room that has their own fire place. Kitchen provides lots of counter space with cabinets to match whatever the chef needs in a kitchen. Driveway gate greets you and provides extra sense of security. Located minutes from I-10 and Memorial area shopping and dining. Zoned to great schools one being a magnet school for Intergrated Technology that provides great academics to kids. Contact you agent or myself today for private tour of this fantastic home.','0.1768','31','','','','','Sellers Disclosure','','','1','Energy Corridor','Central Gas','1','LT 10 BLK 2 PARKWAY VILLAGES SEC 5','Subdivision Lot','7700','Appraisal District','','1797','0','','1','','0','','','','','Composition','27 - Houston','BUSH ELEMENTARY SCHOOL (HOUSTON)','WESTSIDE HIGH SCHOOL','WEST BRIAR MIDDLE SCHOOL','Appointment Required','Appraisal District','2','Traditional','Parkway Villages Sec 05','11372','2.3307','Public Sewer,Public Water','1995','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-16T09:33:34.550' ,`MLSNumber` = '44673384' ,`ListAgentFullName` = 'Anansia Nobles' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.160851' ,`Longitude` = '-95.440042' ,`PhotoCount` = '44' ,`PostalCode` = '77515' ,`RoomCount` = '5' ,`ListPrice` = '199500.00' ,`Status` = 'Active' ,`StreetName` = 'Holly' ,`StreetNumber` = '628' ,`StreetSuffix` = 'Street' ,`City` = 'Angleton' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1393' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home to 628 Holly st! Newly Updated Turn KEY! Seller willing to assist with concessions towards buyers choice of closing costs, rate buy down, warranty, ect. Great location Just 2 minutes from Highway 288 and walking distance to local parks, schools, and convenience stores! PLUS, it\'s on a large corner lot with no side or back neighbors! This 3 bedroom, 2 bathroom, 2 car garage, fully fenced in home has updates to the kitchen, updated bathrooms, new carpet in bedrooms and fresh paint! NEW Roof September 2021. The dining room has double doors with built in windows leading out to the large back yard with views of the fire-pit. Perfect for enjoying these cool fall nights around the fire toasting marshmallows! New 40 gallon water heater and A.C. has been serviced and had new fans installed this year. Windows throughout the home provide plenty of natural light. CLEAN and ready for IMMEDIATE move in! Owner is an agent.' ,`Acres` = '0.2238' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Angleton' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'MUNSON PLAZA (ANGLETON), BLOCK 1, LOT 1' ,`LotDesciption` = 'Corner' ,`LotSize` = '9749' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '5 - Angleton' ,`SchoolElementary` = 'WESTSIDE ELEMENTARY SCHOOL (ANGLETON)' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Left Side,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Munson Plaza Angleton' ,`TaxAmount` = '3842' ,`TaxRate` = '2.6102' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1956' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665936121' WHERE `Matrix_Unique_ID` = '213335326' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-16T08:17:12.050' ,`MLSNumber` = '91470467' ,`ListAgentFullName` = 'Johna McCormick' ,`ListOfficeName` = 'Keller Williams Metropolitan' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.822998' ,`Longitude` = '-95.419014' ,`PhotoCount` = '21' ,`PostalCode` = '77018' ,`RoomCount` = '7' ,`ListPrice` = '655000.00' ,`Status` = 'Active' ,`StreetName` = 'Fisher St' ,`StreetNumber` = '858 #A' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2483' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Independent drive, first floor living, elevator capable, backyard, chef’s kitchen, grand master suite, large closet & game room. \r\nSpacious home with timeless architecture, thoughtful design, exquisite finishes, tastefully executed intricate craftsmanship. \r\nThis home is designed to a be hardworking, functional yet elegant show home. Let it showcase your lifestyle.' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = 'TITAN HOMES' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Oak Forest East Area' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LOT 4, BLK 1' ,`LotDesciption` = 'Other' ,`LotSize` = '2364' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'GARDEN OAKS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'BLACK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,French,Mediterranean,Spanish,Traditional' ,`Subdivision` = 'Fisher Gardens' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665936121' WHERE `Matrix_Unique_ID` = '213420369' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-16T09:47:41.310' ,`MLSNumber` = '10532834' ,`ListAgentFullName` = 'Penny Wilson' ,`ListOfficeName` = 'The Wilson Agency II' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.583837' ,`Longitude` = '-95.461451' ,`PhotoCount` = '6' ,`PostalCode` = '77053' ,`RoomCount` = '5' ,`ListPrice` = '250000.00' ,`Status` = 'Active' ,`StreetName` = 'Amy Ridge Rd' ,`StreetNumber` = '16607' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2282' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Two story 4 bedroom 2 1/2 bath with 2 car garage. Large back yard.' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot15 Block 5 Green Valley Estates Section 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6454' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'BLUE RIDGE ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'WILLOWRIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'MCAULIFFE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Green Valley Estates' ,`TaxAmount` = '4173' ,`TaxRate` = '2.21373' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665936121' WHERE `Matrix_Unique_ID` = '213428194' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-16T09:29:06.217' ,`MLSNumber` = '75460180' ,`ListAgentFullName` = 'Penny Wilson' ,`ListOfficeName` = 'The Wilson Agency II' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.591206' ,`Longitude` = '-95.476132' ,`PhotoCount` = '6' ,`PostalCode` = '77053' ,`RoomCount` = '9' ,`ListPrice` = '225000.00' ,`Status` = 'Active' ,`StreetName` = 'Angel Island' ,`StreetNumber` = '16307' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2044' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '4 Bedroom 2 1/2 Bath 2 story home with 2 car garage and nice yard.' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 2 Block 9 Briar Villa South Sec 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'RIDGEGATE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLOWRIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'MCAULIFFE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Briar Villa' ,`TaxAmount` = '4863' ,`TaxRate` = '2.21373' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665936121' WHERE `Matrix_Unique_ID` = '213432418' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-16T09:33:28.543' ,`MLSNumber` = '34848559' ,`ListAgentFullName` = 'Penny Wilson' ,`ListOfficeName` = 'The Wilson Agency II' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.602629' ,`Longitude` = '-95.516565' ,`PhotoCount` = '6' ,`PostalCode` = '77489' ,`RoomCount` = '7' ,`ListPrice` = '198000.00' ,`Status` = 'Active' ,`StreetName` = 'Summers' ,`StreetNumber` = '907' ,`StreetSuffix` = 'Drive' ,`City` = 'Missouri City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1812' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '3 Bedroom 2 bath 1800 sq ft 2 car garage with large back yard' ,`Acres` = '0.2257' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'HUNTERS GLEN SEC 1, BLOCK 1, LOT 28, (SEC 1-A)' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9831' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'HUNTERS GLEN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MARSHALL HIGH SCHOOL (FORT BEND)' ,`SchoolMiddle` = 'MISSOURI CITY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Hunters Glen Sec 1' ,`TaxAmount` = '4681' ,`TaxRate` = '2.693' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1976' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665936121' WHERE `Matrix_Unique_ID` = '213435681' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-16T09:01:46.800' ,`MLSNumber` = '77672524' ,`ListAgentFullName` = 'Rosa Wilhelm' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.137637' ,`Longitude` = '-95.390895' ,`PhotoCount` = '38' ,`PostalCode` = '77386' ,`RoomCount` = '10' ,`ListPrice` = '460000.00' ,`Status` = 'Active' ,`StreetName` = 'Orchid Trace' ,`StreetNumber` = '3315' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4116' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MUST SEE! Location, Convenience, Quality and Price: Beautiful 4/3.5/2 home Located 7.1 Miles from Exxon Campus, 6 Miles from The Woodlands Town Center, and 30 miles from Down-Town Houston. Easy access to 99 Grand Parkway, Hardy Toll Road and I45. You will love the Gourmet Kitchen w/oversized L shaped Island, spacious Dining area and oversized Laundry Room. Home office Downstairs, ceiling speakers, downstairs primary bedroom with his and hers sink and closets and separate shower and bathtub. Upstairs bedrooms are larger than usual and one w/in-suite. Gigantic game room and media room upstairs top the cake. Outside elevation is classic and impressive, 4-sided Brick, Covered patio and back yard large enough for a pool.' ,`Acres` = '0.1808' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S688601 - LEGENDS TRACE 01 PARTIAL REPLAT NO 1, BLOCK 1, LOT' ,`LotDesciption` = 'Cleared' ,`LotSize` = '7875' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '580' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'BRADLEY ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'GRAND OAKS HIGH SCHOOL' ,`SchoolMiddle` = 'YORK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Legends Trace 01 Pt Repla' ,`TaxAmount` = '10940' ,`TaxRate` = '3.1987' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665936122' WHERE `Matrix_Unique_ID` = '213454722' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-16T09:55:14.017' ,`MLSNumber` = '98552240' ,`ListAgentFullName` = 'Sapana Patel' ,`ListOfficeName` = 'Keller Williams Realty -SW' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.541776' ,`Longitude` = '-95.564899' ,`PhotoCount` = '32' ,`PostalCode` = '77479' ,`RoomCount` = '11' ,`ListPrice` = '695000.00' ,`Status` = 'Active' ,`StreetName` = 'Plum Point' ,`StreetNumber` = '5614' ,`StreetSuffix` = 'Court' ,`City` = 'Sugar Land' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4050' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Floor Plan in sought after Riverstone. Zoned to New Elementary opening Fall 2023. It\'s located in a private cul-de-sac at dead end street with no neighbors on one side. Large 4 Bedrooms and 4 Full Bathrooms ( 3 bed downstairs & 1 upstairs); Bay Window in Primary Bedroom, Sunroom, Updated extended patio with outdoor kitchen and grill, natural gas piped to both outdoor cooktop and grill. Open Kitchen with 2 dishwashers , A/C in Garage, The primary bedroom plus 2 bedrooms, formal dining, sun room, breakfast and the study are on the first floor; all bedrooms have en suite bathroom. Second floor game room, a media room and fourth bedroom with a full bath and a walk in closet. Plantation shutters throughout the house. Hard Wood & Tile floors. (Zoned to Anne Sullivan Elementary School) A must see!' ,`Acres` = '0.247' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'CREEKSTONE VILLAGE AT RIVERSTONE SEC 6 PHASE II, BLOCK 2, LO' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '10760' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'SULLIVAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ELKINS HIGH SCHOOL' ,`SchoolMiddle` = 'FIRST COLONY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'CreekStone Village at Riverstone' ,`TaxAmount` = '11339' ,`TaxRate` = '2.5104' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2010' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665936122' WHERE `Matrix_Unique_ID` = '213466906' --> 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','213491753','1665936122','213491753','2022-10-16T08:47:27.810','7006152','Gayla Gayden','REALM Real Estate Professional','','','29.841255','-95.735289','31','77449','11','295000.00','Active','Westgreen Plains','20823','Drive','Katy','2','0','3','2068','Single-Family','Stunning One Story Ranch Home quietly nestled in the MEADOWS AT WESTFIELD VILLAGE! Grand Entry with High Ceilings, Upgraded Beautiful Large Plank Wood Like Floors throughout! Huge Family Room with Walls of Widows looking out to Your Covered Patio! Family Area flows into the Casual Dining & The Gourmet Kitchen that features Tall White Cabinets, Stylish and classic, gorgeous Subway Tile Backsplash Laid in amazing Design! The Gourmet Kitchen has Stainless Steel Appliances & a Huge Breakfast Bar! Private Owner\'s Suite with Sitting Area, High Ceilings & Luxurious Bathroom with Beautiful Cultured Marble Counters, Deep His & Her Undermount Sinks, Deep Soaker Tub, Large Shower & Huge Walk In Closets! Discover tucked away the Two Guest Bedroom & Guest Bathroom with Large Vanity, Cultured Marble, Deep Undermount sink, Shower & Tub Combination! No Flooding during any of the storms! Energy Saving Home W/High-Efficiency HVAC, Insulated Doors, Insulated/Low-E Windows, Radiant Attic Barrier & More!','0.1188','25','','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','','','Bear Creek South','Central Electric','1','LT 15 BLK 4 MEADOWS AT WESTFIELD VILLAGE SEC 2','Subdivision Lot,Wooded','5175','Appraisal District','','495','0','','2','Gas Oven,Single Oven','0','','','Freestanding Range','','Composition','13 - Cypress-Fairbanks','M ROBINSON ELEMENTARY SCHOOL','CYPRESS PARK HIGH SCHOOL','THORNTON MIDDLE SCHOOL (CY-FAIR)','Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox','Appraisal','1','Ranch,Traditional','THE MEADOWS AT WESTFIELD VILLAGE','6603','2.821','Public Sewer,Public Water,Water District','2018','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-16T08:09:57.190' ,`MLSNumber` = '92518727' ,`ListAgentFullName` = 'Frank York' ,`ListOfficeName` = 'Martha Turner Sotheby\'s International Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.787325' ,`Longitude` = '-95.444236' ,`PhotoCount` = '40' ,`PostalCode` = '77055' ,`RoomCount` = '7' ,`ListPrice` = '845000.00' ,`Status` = 'Active' ,`StreetName` = 'Somerset York' ,`StreetNumber` = '3728' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3006' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 3728 Somerset York, a lovely recently constructed home located in Somerset Green noted for a great blend of European architecture and a lock & leave lifestyle. This fabulous home is one of a few to boast first floor living with an open concept kitchen with double ovens, oversized island, walk-in pantry & luxurious Benedettini cabinets. The second floor hosts the spacious owners retreat complete with a sumptuous bath with double vanity, glass framed shower, separate soaking tub and a generous walk-in closet complete with built-ins. Two secondary bedrooms highlight the third floor, one with a walk-in closet & shared hall bath. Also located on the third floor is a sizable game room or media room with gleaming windows and private patio. This lovely home also provides a private backyard perfect for furry friends. Full home generator, water booster & tankless water heater, a full third car lift in the garage and much, much more! Light and bright. Welcome Home!' ,`Acres` = '0.0517' ,`Area` = '9' ,`BuilderName` = 'Toll Brothers' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Timbergrove/Lazybrook' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 13 BLK 1 SOMERSET GREEN SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2254' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2625' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SINCLAIR ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Traditional' ,`Subdivision` = 'Somerset Green' ,`TaxAmount` = '16676' ,`TaxRate` = '2.8307' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665936122' WHERE `Matrix_Unique_ID` = '213493025' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-16T09:28:47.793' ,`MLSNumber` = '79486262' ,`ListAgentFullName` = 'Valerie Diaz' ,`ListOfficeName` = 'Keller Williams Realty -SW' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.578842' ,`Longitude` = '-95.621001' ,`PhotoCount` = '35' ,`PostalCode` = '77479' ,`RoomCount` = '12' ,`ListPrice` = '550000.00' ,`Status` = 'Active' ,`StreetName` = 'Meadow Spring' ,`StreetNumber` = '3615' ,`StreetSuffix` = 'Drive' ,`City` = 'Sugar Land' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3742' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '*** VIRTUAL TOUR AVAILABLE TO VIEW*** Welcome to this 5 bedroom, 3.5 bath home located on a lush greenbelt and zoned to sought after schools! This lovely home offers so much room including a formal dining room, formal living room, den, upstairs game room, 5 spacious bedrooms and LOTS of natural light. Kitchen has plenty of counter space for all your cooking needs, breakfast area and opens to the living room. Den and formal living room have connecting cozy fireplaces and staircase offer dual entry. Primary bedroom is spacious and offers a primary bath with dual sinks, soaking tub and separate shower. Step into the relaxing backyard that backs up to the green belt that has a walking path. This home is a must see! Close to main highways, shopping and restaurants. ***white curtains with drawings in back bedroom excluded' ,`Acres` = '0.2049' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'OAKS OF ALCORN SEC 2, BLOCK 2, LOT 15' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8925' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '812' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'COLONY MEADOWS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEMENTS HIGH SCHOOL' ,`SchoolMiddle` = 'FORT SETTLEMENT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Oaks Of Alcorn' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1990' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665936122' WHERE `Matrix_Unique_ID` = '213493552' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-16T09:29:57.197' ,`MLSNumber` = '79874041' ,`ListAgentFullName` = 'Charlotte Huwar' ,`ListOfficeName` = 'Ross & Marshall Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.025871' ,`Longitude` = '-95.520850' ,`PhotoCount` = '28' ,`PostalCode` = '77379' ,`RoomCount` = '9' ,`ListPrice` = '270000.00' ,`Status` = 'Active' ,`StreetName` = 'Clee' ,`StreetNumber` = '6906' ,`StreetSuffix` = 'Lane' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1589' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A centrally located home between Hwy 249 and Grand Parkway (99) and I45. It\'s approximately 6 miles from the Vintage Shopping Center and more shopping on Hwy 249 including Willowbrook Mall. There are several hospitals in the area. This is a well maintained 3 bedroom 2 bathroom home with a attached two car garage. Please verify all room measurments as they are approximate. The kitchen cabinets are all new, countertops, sink, faucets and disposal/plumbing and pod lights were done in 2020. The stove, microwave, dishwasher and refrigerator (that is staying) were put in in 2022. New double pane storm windows were installed in 2020 and have a transferable warranty. This home was completely painted inside and out and is ready for a family to move into. The flooring in the home is italian tile flooring in living room, dining room/kitchen, breakfast area and hallways. The rest of flooring in this home is new waterproof /scratchproof wood laminate flooring. Sits on a cul-de-sac. Come see it.' ,`Acres` = '0.2063' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 53 BLK 4 017*W5720756-000-004-053 WOODBRIAR PLACE' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '8988' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '330' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'EHRHARDT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN HIGH SCHOOL' ,`SchoolMiddle` = 'KLEB INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Woodbriar Place' ,`TaxAmount` = '4544' ,`TaxRate` = '2.5085' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665936122' WHERE `Matrix_Unique_ID` = '213525366' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-16T08:52:08.153' ,`MLSNumber` = '97716721' ,`ListAgentFullName` = 'Diane Sanders' ,`ListOfficeName` = 'Sanders Family Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.082414' ,`Longitude` = '-95.777822' ,`PhotoCount` = '29' ,`PostalCode` = '77447' ,`RoomCount` = '5' ,`ListPrice` = '239000.00' ,`Status` = 'Active' ,`StreetName` = 'Klingamans' ,`StreetNumber` = '22722' ,`StreetSuffix` = 'Way' ,`City` = 'Hockley' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1416' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'It\'s nearly impossible to find a beautiful home - AT THIS PRICE - with all these modern updates & decorator touches, high ceilings, big yard & with such easy/close access to Hwy 290 for commute - or work from home! Large backyard -- trampoline area, deck, & room for tossing the ball to Spot! Family room is HUGE & the dining room is so inviting for family meals or holiday gatherings, lots of natural light, open kitchen with views to all living areas. Lovely window treatments. Primary bdrm private away from other bdrms. Priced for those who feel like they have been priced out of the market. Full sprinkler system. Wonderful, growing Hockley & Waller area where you can still see the cows graze & horses romp & play while on your daily commute. Love the feel of country while close to the city. This home offers so much for buyers just starting out or maybe downsizing a bit. EASY to maintain - just come home from school or work & play! Low HOA & tax rate & NEVER FLOODED! (Confirm rooms sizes)' ,`Acres` = '0.1283' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hockley' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 9 BLK 6 BAUER LANDING SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5589' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '495' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'EVELYN TURLINGTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'SCHULTZ JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Bauer Landing' ,`TaxAmount` = '5225' ,`TaxRate` = '2.8556' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665936123' WHERE `Matrix_Unique_ID` = '213530793' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-16T09:17:43.583' ,`MLSNumber` = '95572970' ,`ListAgentFullName` = 'Harry Lou' ,`ListOfficeName` = 'Fidelity Realtors and Services' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.747482' ,`Longitude` = '-95.733850' ,`PhotoCount` = '39' ,`PostalCode` = '77450' ,`RoomCount` = '12' ,`ListPrice` = '599000.00' ,`Status` = 'Active' ,`StreetName` = 'Hidden Shore' ,`StreetNumber` = '2422' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4038' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW FOORING. NEW WINDING STAIRCASE/HANDRAIL! NEW ROOF! NEW INTERIOR PAINTING! LOTS OF IMPROVEMENTS IN THIS ELOQUENT KELLIWOOD LAKES HOME! LAKE VIEW, 4 BEDROOMS AND 3.5 BATHS. HIGH CEILING STUDY, FORMALS, GAMEROOM UP, MASTER DOWN W/ BAY WINDOW. MASTER BATH W/ DUAL SINKS, GARDEN TUB WITH SEPARATE SHOWER. ISLAND KITCHEN. EXCELLENT KATY ISD SCHOOLS. TWO STAIRCASES, ROOF TOP DECK / BALCONY WITH LAKE VIEW. PORTE COCHERE FOR ADDITIONAL PARKING.' ,`Acres` = '0.2296' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 BLK 1 KELLIWOOD LAKES SEC 1 PAR R/P' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '10000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2425' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Grill' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'HAYES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TAYLOR HIGH SCHOOL (KATY)' ,`SchoolMiddle` = 'MCMEANS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Kelliwood Lakes Sec 01' ,`TaxAmount` = '12473' ,`TaxRate` = '2.3333' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1994' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665936123' WHERE `Matrix_Unique_ID` = '213559518' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-16T09:39:54.390' ,`MLSNumber` = '16170226' ,`ListAgentFullName` = 'Pamela McGee' ,`ListOfficeName` = 'Greater Houston REP, Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.752180' ,`Longitude` = '-95.731385' ,`PhotoCount` = '43' ,`PostalCode` = '77450' ,`RoomCount` = '12' ,`ListPrice` = '469000.00' ,`Status` = 'Active' ,`StreetName` = 'Chadbury Park' ,`StreetNumber` = '20706' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3112' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Desirable Kelliwood Gardens, loc near quiet cul-de-sac. Impressive entry w/curved stair & natural light. Travertine flooring dn, new carpet up, plantation shutters/2\" blinds, crown & triple crown molding & upgraded lighting. Granite island kitchen w/wine fridge & stainless Bosch d/w, KitchenAid ovens & JennAir cooktop. Fireplace w/custom mesquite mantle & German smear bricks. Keyless entry. Sprinkler sys,cov back porch w/brick floor. 3 built-in desks, built-in china cabinet, display shelves in den,office & primary bedroom. Laundry w/upper/lower cabinets, granite counter, built-in ironing board & freezer space. Bedrms w/walk-in closets,some w/built-in shelving & one has toy chest. Granite in kitchen,primary bath & all secondary bathrooms for that high end feel. New A/C units \'20, coils \'19, digital thermostats w/wifi. Exterior painted 9/22. Primary bedrm w/recessed ceiling, prim bath updated w/travertine tile, granite trim & huge soaking tub. Brand new garage door/opener. One of a kind!' ,`Acres` = '0.2005' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 29 BLK 6 KELLIWOOD GARDENS SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8735' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '770' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'HAYES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TAYLOR HIGH SCHOOL (KATY)' ,`SchoolMiddle` = 'MCMEANS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Kelliwood Gardens Sec 01' ,`TaxAmount` = '7750' ,`TaxRate` = '2.3333' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1990' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665936123' WHERE `Matrix_Unique_ID` = '213576827' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-16T09:24:35.577' ,`MLSNumber` = '73612803' ,`ListAgentFullName` = 'J. Carter Breed' ,`ListOfficeName` = 'J. Carter Breed Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.774026' ,`Longitude` = '-95.586044' ,`PhotoCount` = '38' ,`PostalCode` = '77079' ,`RoomCount` = '16' ,`ListPrice` = '850000.00' ,`Status` = 'Active' ,`StreetName` = 'Taylorcrest' ,`StreetNumber` = '13802' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '6' ,`SqFtTotal` = '3461' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great project house! Lots of space on a large lot. One of the largest lots in the neighborhood. Terrazzo entry , formals, family room and game room down. 6 bedrooms up or 5 with game room. Kitchen has granite counters, stainless appliances, stained cabinets. Big walk-in closet in hall upstairs. Ready for your special touches! Memorial West Civic Club offers private pool for residents use.' ,`Acres` = '0.2707' ,`Area` = '23' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate,No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Memorial West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 17 BLK 3 NOTTINGHAM SEC 1' ,`LotDesciption` = 'Corner' ,`LotSize` = '11791' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'WILCHESTER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'STRATFORD HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'MEMORIAL MIDDLE SCHOOL (SPRING BRANCH)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Nottingham' ,`TaxAmount` = '14520' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1963' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665936123' WHERE `Matrix_Unique_ID` = '213584777' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-16T09:06:37.987' ,`MLSNumber` = '78097292' ,`ListAgentFullName` = 'Joshua Pedroso' ,`ListOfficeName` = 'Generation Realty & Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.701675' ,`Longitude` = '-95.746262' ,`PhotoCount` = '37' ,`PostalCode` = '77407' ,`RoomCount` = '8' ,`ListPrice` = '355000.00' ,`Status` = 'Active' ,`StreetName` = 'Tallow Knoll' ,`StreetNumber` = '7006' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2411' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to this HIDDEN GEM located in Lakemont. HUGE CUL-DE-SAC LOT!! BRAND NEW ROOF (2022) Tile throughout the WHOLE house, beautiful chandeliers in entry and dining, marble countertops with tile backsplash in the kitchen, top-of-the-line stainless Kitchen Aid appliances (with a double oven!), digital thermostat, Gameroom has been utilized as a 4th bedroom, large covered patio with a screened area for storage, sprinkler system and more! HOME HAS NEVER FLOODED!!' ,`Acres` = '0.2674' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LAKEMONT SEC 2, BLOCK 1, LOT 18' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '11649' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'MCNEILL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FOSTER HIGH SCHOOL' ,`SchoolMiddle` = 'WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakemont' ,`TaxAmount` = '6917' ,`TaxRate` = '2.8215' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665936123' WHERE `Matrix_Unique_ID` = '213605480' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-16T09:09:11.347' ,`MLSNumber` = '76662926' ,`ListAgentFullName` = 'Andrea Huerta' ,`ListOfficeName` = 'Keller Williams HoustonCentral' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.677076' ,`Longitude` = '-95.195019' ,`PhotoCount` = '21' ,`PostalCode` = '77502' ,`RoomCount` = '4' ,`ListPrice` = '237900.00' ,`Status` = 'Active' ,`StreetName` = 'Gary' ,`StreetNumber` = '1217' ,`StreetSuffix` = 'Avenue' ,`City` = 'Pasadena' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1505' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to beautifully renovated 4 bedroom, 2 full bath with detached garage! All new water resistant laminate flooring through out entire home, with fresh interior and exterior paint. Property comes equipped with updated plumbing, electrical with recess lighting and HVAC system fully serviced. Brand new energy efficient appliances in kitchen with brand new back splash. Custom tile and lighting in main restroom. Corner lot with detached garage. Never flooded. Schedule a private showing today!' ,`Acres` = '0.1832' ,`Area` = '6' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Pasadena' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 17 BLK 14 FRONTIER EAST SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7980' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'BAILEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SAM RAYBURN HIGH SCHOOL' ,`SchoolMiddle` = 'PARKVIEW INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Frontier East' ,`TaxAmount` = '3872' ,`TaxRate` = '2.6514' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1954' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665936124' WHERE `Matrix_Unique_ID` = '213621738' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-16T09:36:41.560' ,`MLSNumber` = '92995215' ,`ListAgentFullName` = 'Damaris Gonzalez' ,`ListOfficeName` = 'Rose Above Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.544326' ,`Longitude` = '-95.095264' ,`PhotoCount` = '15' ,`PostalCode` = '77058' ,`RoomCount` = '11' ,`ListPrice` = '385000.00' ,`Status` = 'Active' ,`StreetName` = 'Blanchmont' ,`StreetNumber` = '18222' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2233' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home!! Beautiful 4 Bedroom 2.5 Bathroom in the highly sought-after community of Nassau Bay. Formal living room, dining room, and large family room perfect for entertaining. This gorgeous home sits on the corner lot and is conveniently located near of beautiful parks and lakes. It\'s zoned to the great school district of CCISD, and is located in the community right across from NASA Space Center.' ,`Acres` = '0.2066' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Clear Lake Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 14 BLK 9 NASSAU BAY SEC 1' ,`LotDesciption` = 'Corner' ,`LotSize` = '9000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '95' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Wood Shingle' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'ROBINSON ELEMENTARY SCHOOL (CLEAR CREEK)' ,`SchoolHigh` = 'CLEAR CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'SPACE CENTER INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Nassau Bay Sec 01' ,`TaxAmount` = '7123' ,`TaxRate` = '2.4882' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1964' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665936124' WHERE `Matrix_Unique_ID` = '213666819' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-16T08:57:49.480' ,`MLSNumber` = '36430191' ,`ListAgentFullName` = 'Anisa Hoxha' ,`ListOfficeName` = 'Keller Williams Realty - Memorial' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.801453' ,`Longitude` = '-95.554534' ,`PhotoCount` = '50' ,`PostalCode` = '77043' ,`RoomCount` = '8' ,`ListPrice` = '459000.00' ,`Status` = 'Active' ,`StreetName` = 'Haddington' ,`StreetNumber` = '10410' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2069' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautifully fully remodeled home located in the sought-after neighborhood of Shadow Oaks features charm, character and many updates! The updates include fresh new exterior paint, custom kitchen cabinetry, updated bathrooms, raised ceilings, tile flooring and so much more. Throughout the home, you will find beautiful wood look tile flooring and well as double pane windows offering sunlight and a gorgeous view to the backyard garden. The garden truly is one of a kind and a must see!! The primary suite is as big as you will find in any home! Only minutes away from I-10, Memorial Mall, Town & Country City Center and the Energy Corridor makes this home a trendy and convenient location. Schedule your appointment today!' ,`Acres` = '0.2009' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 14 BLK 14 SHADOW OAKS SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8750' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'WESTWOOD ELEMENTARY SCHOOL (SPRING BRANCH)' ,`SchoolHigh` = 'SPRING WOODS HIGH SCHOOL' ,`SchoolMiddle` = 'SPRING OAKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Shadow Oaks Sec 05' ,`TaxAmount` = '9736' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1961' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1665936124' WHERE `Matrix_Unique_ID` = '213671863' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-16T09:43:34.347' ,`MLSNumber` = '18417512' ,`ListAgentFullName` = 'Tod Franklin' ,`ListOfficeName` = 'DFWCityhomes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.609258' ,`Longitude` = '-95.548375' ,`PhotoCount` = '14' ,`PostalCode` = '77477' ,`RoomCount` = '8' ,`ListPrice` = '265000.00' ,`Status` = 'Active' ,`StreetName` = 'Swords' ,`StreetNumber` = '327' ,`StreetSuffix` = 'Bend' ,`City` = 'Stafford' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1682' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming House is located in the Kingsway neighborhood of Stafford, a low tax rate City, a community with access to a pool and recreation area! The house has been renovated with brand new luxury vinyl plank flooring in Living room, kitchen, and Dining Room, and new carpet throughout bedrooms. The kitchen has been updated with quartz countertops and brand new dishwasher, gas range, and Microwave are being installed. The house has been repiped with PEX, and a brand new A/C system and water heater were installed in 2022. It is located near all the thoroughfares providing easy access into and out of town for work or play. including Hwy 90, Beltway 8, and Hwy 59.' ,`Acres` = '0.1806' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Stafford Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'KINGSWAY, BLOCK 2, LOT 31' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7869' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '50 - Stafford' ,`SchoolElementary` = 'STAFFORD ELEMENTARY SCHOOL (STAFFORD MSD)' ,`SchoolHigh` = 'STAFFORD HIGH SCHOOL' ,`SchoolMiddle` = 'STAFFORD INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Kingsway' ,`TaxAmount` = '3363' ,`TaxRate` = '1.9342' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1665936124' WHERE `Matrix_Unique_ID` = '213677473' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-16T08:45:12.263' ,`MLSNumber` = '19529751' ,`ListAgentFullName` = 'Dana Olejniczak' ,`ListOfficeName` = 'Martha Turner Sotheby\'s International Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.034856' ,`Longitude` = '-95.176985' ,`PhotoCount` = '49' ,`PostalCode` = '77339' ,`RoomCount` = '12' ,`ListPrice` = '980000.00' ,`Status` = 'Active' ,`StreetName` = 'Twin Greens' ,`StreetNumber` = '3' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4532' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great location just across the street from the golf course and within close proximity to heart of Kingwood\'s entertaining and shopping areas. With 2 Primary bedrooms down, this home shows beautifully! Lovely traditional elements throughout with rich hardwood floors, crown moulding, plantation shutters, and nice built-ins. Elegant dining room near entry with fireplace. Open kitchen with upgraded appliances, extensive counter and cabinet space, center island, granite counters, and breakfast bar. Large family room with gas log fireplace, expansive windows, and access to back patio. Primary bedroom has a sitting area with private door to the covered patio and pool area. Luxurious primary bath with enormous walk-in closet, double sinks, tub, and expansive shower. Large game room on second floor is ideal flex space with builtins and balcony. This large back yard with a pool is perfect for entertaining a multitude of friends and family.' ,`Acres` = '0.3964' ,`Area` = '32' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Kingwood West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 BLK 5 KINGWOOD GREENS VLG 3 PAR R/P' ,`LotDesciption` = 'Cul-De-Sac,In Golf Course Community,Subdivision Lot' ,`LotSize` = '17269' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '950' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'GREENTREE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KINGWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'CREEKWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Kingwood Greens Village' ,`TaxAmount` = '18114' ,`TaxRate` = '2.5839' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665936124' WHERE `Matrix_Unique_ID` = '213688831' --> 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','213722091','1665936125','213722091','2022-10-16T09:16:54.273','65938006','Sherrie Dawson','The Professional Landlords','','','29.678828','-95.329724','23','77033','3','140000.00','Active','Southford','5950','Street','Houston','1','0','3','1284','Single-Family','Great investors Opportunity! This 3 bedroom, 1 bath has great option for a 4 bedroom. Needs some TLC but not far from rent ready. Great location as neighborhood is nice and up and coming. Siding replaced Mar 2017. \r\nThe foundation was repaired July 2018 and the attic air handler replaced in September 2018. Interior water lines replaced Feb 2019','0.1806','3','','','','','Sellers Disclosure','','','','Medical Center South','Central Gas','0','LT 4 BLK 32 SOUTHCREST SEC 4','Other','7866','Appraisal District','','','0','','0','','0','','','','','Other','27 - Houston','KELSO ELEMENTARY SCHOOL','STERLING HIGH SCHOOL (HOUSTON)','ATTUCKS MIDDLE SCHOOL','Appointment Required,Lockbox Front,Vacant/Unoccupied','Appraisal District','1','Traditional','Southcrest Sec 04','1887','2.3307','Public Sewer,Public Water','1950','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-16T08:58:42.813' ,`MLSNumber` = '4200364' ,`ListAgentFullName` = 'Emily Dominey' ,`ListOfficeName` = 'Promed Realty Services, LLP' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.198920' ,`Longitude` = '-95.432143' ,`PhotoCount` = '30' ,`PostalCode` = '77385' ,`RoomCount` = '7' ,`ListPrice` = '275000.00' ,`Status` = 'Active' ,`StreetName` = 'Glen Jay' ,`StreetNumber` = '9929' ,`StreetSuffix` = 'Court' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1776' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home is nestled in a quiet cul de sac street with updated kitchen and bathrooms, large backyard and pool. Functional open concept floor plan for entertaining and everyday living. Close to restaurants, shopping and more with easy access to I-45! Schedule your showing today!' ,`Acres` = '0.2011' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'S533003 - GLENEAGLES 03, LOT 12' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '8758' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'SUCHMA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'OAK RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'IRONS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Gleneagles 03' ,`TaxAmount` = '4625' ,`TaxRate` = '2.6088' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1981' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665936125' WHERE `Matrix_Unique_ID` = '213725006' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-16T09:52:15.553' ,`MLSNumber` = '72861643' ,`ListAgentFullName` = 'Valery Smith-Blank' ,`ListOfficeName` = 'RE/MAX Integrity' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.031408' ,`Longitude` = '-95.526561' ,`PhotoCount` = '6' ,`PostalCode` = '77379' ,`RoomCount` = '7' ,`ListPrice` = '210000.00' ,`Status` = 'Active' ,`StreetName` = 'Ten Curves' ,`StreetNumber` = '17610' ,`StreetSuffix` = 'Circle' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1728' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great opportunity for Investors or anyone who wants some sweat equity! This home has a beautiful floorplan with Living Room and Formal Dining, as well as a Family Room. The Living Room has a beautiful brick fireplace. Kitchen is spacious and has great storage and is open to the Family Room. There is a Covered Porch and a large back yard situated on a cul-de-sac lot. No carpet, laminate and tile floors. Most fencing is new in back yard. Oakwood Glen is conveniently located with easy access to Hwy 249; Beltway 8 & Grand Parkway, as well as I-45. Great Schools in Klein ISD. This home needs some TLC, but has a lot of potential to make it your own. NO FLOODING! SOLD AS IS' ,`Acres` = '0.2296' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 40 BLK 2 017*O0118825-001-002-040 OAKWOOD GLEN SEC 1' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '10000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'EHRHARDT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN HIGH SCHOOL' ,`SchoolMiddle` = 'KLEB INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Oakwood Glen Sec 01' ,`TaxAmount` = '4829' ,`TaxRate` = '2.5085' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665936125' WHERE `Matrix_Unique_ID` = '213729581' --> 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','213732261','1665936125','213732261','2022-10-16T09:03:20.100','78460500','Laya Zachariah','Realty Associates','','','29.421006','-95.285322','26','77511','6','232900.00','Active','County Road 180','1848','','Alvin','2','0','3','1836','Single-Family','Come see this completely remodeled 3 bedroom/2 full bath/1836 sq. ft. manufactured home. Built in 2006, this double wide sits on 2-acre fenced and gated lot with no restrictions. New paint interior and exterior. New soft carpet in all bedrooms. Modern premium vinyl plank flooring in living room, kitchen, dining room and den. Island kitchen with new cabinets and granite countertops with backsplash. Large living room is perfect for family gatherings with a fireplace to keep warm during winter season. Bring your horse or farm animals on this ready to move-in unrestricted property. Don\'t miss the opportunity for country living at its finest. Survey available upon request.','2','5','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','Alvin North','Central Electric','0','BLUM (A0474 H T & B R R ) LOT 24B ACRES 2.0 S# 125011008A00H','Wooded','87120','Appraisal District','','','0','','0','Electric Oven','0','','','Electric Range','','Composition','3 - Alvin','NELSON ELEMENTARY SCHOOL (ALVIN)','ALVIN HIGH SCHOOL','FAIRVIEW JUNIOR HIGH SCHOOL','Appointment Required,Lockbox Front,Vacant/Unoccupied','Appraisal District','1','Ranch','Blum','2018','2.2174','Septic Tank','2006','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','213732964','1665936125','213732964','2022-10-16T09:00:43.777','31773089','Tista Nelson','Texas Real Estate Junkie','','','29.499311','-95.500872','25','77459','5','490000.00','Active','Kent','3522','Knoll','Missouri City','2','1','4','3188','Single-Family','Stunning one and half story in the desirable Sienna Village of Shipmans Landing on a large corner lot. This beautiful home has all bedrooms down and a huge game room upstairs for family fun and entertainment. Staged like a model, the home features wood floors, recent paint, high ceilings, granite countertops and much, much more! The primary suite boasts of plenty of space for rest and relaxation with a primary bath fit to unwind in the jetted tub or sit and steam in the shower. Lush landscaping for outdoor living with an oversized covered patio. Sienna is packed with amenities as well as a full calendar of recreational activities for the whole family to enjoy. Welcome home!','0.286','38','','','Gas Dryer Connections,Washer Connections','','Exclusions,Mud,Sellers Disclosure','1','Gas Connections','1','Sienna Area','Central Gas','1','SIENNA VILLAGE OF SHIPMANS LANDING SEC 22-A, BLOCK 2, LOT 13','Corner,In Golf Course Community,Subdivision Lot','12456','Appraisal District','','1307','0','','2','Gas Oven','0','','','Gas Cooktop','','Composition','19 - Fort Bend','SCANLAN OAKS ELEMENTARY SCHOOL','RIDGE POINT HIGH SCHOOL','THORNTON MIDDLE SCHOOL (FORT BEND)','Appointment Required,Leave Business Card,Request Online Appointment,Supra Keybox','Appraisal District','1.5','Traditional','Sienna Vlg Shipman\'s Lndg','8899','2.6079','Water District','2005','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213735060','1665936125','213735060','2022-10-16T08:47:00.137','29524573','Ashley Davis','Results Real Estate','','','30.430272','-94.906598','0','77327','6','715000.00','Active','Fm 223','1397','Road','Cleveland','4','0','5','3960','Single-Family','The Future you\'ve dreamed of awaits you. Coffee under the front porch watching the deer stroll casually as the sun rises, and a fishing rod and an adult beverage watching the sun go down. The breathtaking homefr4ont offers 12+/- Acres of fenced property ready for the horses, cattle, goats or whatever brings you happiness. Big farewell to deed restrictions and pricey HOA\'s, there\'s none of that here. The custom-built farmhouse presents you with just under 4,000 sqft and enormous amounts of outdoor living space, built with family in mind! located in the coveted Tarkington ISD, this one offers it all so come look at it yourself!','12.185','52','','','','','Sellers Disclosure','','','','Liberty County East','Central Electric','0','000155 A CHERRY, TRACT 4, ACRES 12.185','Cleared','530779','Appraisal District','','','0','','2','','0','','','','','Aluminum','102 - Tarkington','TARKINGTON PRIMARY SCHOOL','TARKINGTON HIGH SCHOOL','TARKINGTON MIDDLE SCHOOL','Appointment Required','Appraisal District','2','Ranch','A Cherry','9129','1.5226','Septic Tank,Well','2011','Seller'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213735523','1665936125','213735523','2022-10-16T09:28:23.067','65795950','Susanna Sanmiguel','Realty Preferred Clear LakeSte #180-111','','','30.048588','-95.389265','5','77373','6','265000.00','Active','Timberbrook','23306','Drive','Spring','2','0','4','1258','Single-Family','Save, save, save on your electric bill and benefit from your energy-efficient home! When you arrive, the solar panels greet you with years of green energy and an abundant resource. Placed in 2020 the solar energy can save you hundreds per month and eliminate your electric bill. It is even possible to earn money from surplus power transferred to the grid! Interior qualities include tankless water heater, recent ac, all solid wood door/frames, windows with lifetime warranty, kitchen remodel with several new appliances, fresh paint and jetted bathtub. The garage has been converted into extra living space. Exterior features include new roof, new backyard fence, new siding, fresh paint and updated electrical panel. Let\'s cool down with a dip in the saltwater pool! Step out into your neighborhood to enjoy evening walks hiking the trails and soaking in nature. In the oil field? Exxon Mobile Headquarters is just a 13 minute drive. Schedule today!','0.1398','12','','','Electric Dryer Connections','','Mud,Sellers Disclosure','0','Gas Connections','1','Spring East','Central Electric','1','LT 17 BLK 46 TIMBER LANE SEC 7','Subdivision Lot','6090','Appraisal District','','398','0','','0','Electric Oven','1','In Ground,Salt Water','','Electric Cooktop','','Composition','48 - Spring','PEARL M HIRSCH ELEMENTARY SCHOOL','SPRING HIGH SCHOOL','TWIN CREEKS MIDDLE SCHOOL','Accompany,Appointment Required,Controlled Access','Appraisal District','1','Traditional','Timber Lane Sec 07','3767','3.0268','Public Sewer,Public Water','1983','Appraisal District'); --> New record created successfully