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-30T09:53:38.457' ,`MLSNumber` = '62023086' ,`ListAgentFullName` = 'Tyrone Hamilton' ,`ListOfficeName` = 'Hamilton Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.739228' ,`Longitude` = '-95.355601' ,`PhotoCount` = '8' ,`PostalCode` = '77004' ,`RoomCount` = '2' ,`ListPrice` = '215000.00' ,`Status` = 'Active' ,`StreetName` = 'Gray' ,`StreetNumber` = '3016' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1056' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Located on a quiet street close to downtown, The open floor concept offers lots of natural light, a large living room, a brick fireplace, and wood flooring! The home is conveniently located next to downtown with easy access to downtown, UH, TSU, and the Medical Center.' ,`Acres` = '0.1148' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'University Area' ,`HeatSystem` = 'Window Unit' ,`HOAMandatory` = '0' ,`Legal` = 'LT 4 BLK 4 PIERCE COURT' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BLACKSHEAR ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'YATES HIGH SCHOOL' ,`SchoolMiddle` = 'CULLEN MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Accompany,Appointment Required,Call Occupant' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Pierce Court' ,`TaxAmount` = '2357' ,`TaxRate` = '2.5144' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1930' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1667145726' WHERE `Matrix_Unique_ID` = '200253280' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T08:48:53.350' ,`MLSNumber` = '43652994' ,`ListAgentFullName` = 'Caroline Billipp' ,`ListOfficeName` = 'Greenwood King Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.738185' ,`Longitude` = '-95.420095' ,`PhotoCount` = '15' ,`PostalCode` = '77098' ,`RoomCount` = '6' ,`ListPrice` = '1349000.00' ,`Status` = 'Active' ,`StreetName` = 'Lake' ,`StreetNumber` = '3014' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3365' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New property offered by Lake Street Homes located in Upper Kirby. Walkability to some of Houston’s finest restaurants, shopping, grocery and night life. 3014 is a free standing brick residence with generous two car garage and private driveway. Details like a painted wood door and copper gas lanterns welcome guests into the home with 12 foot ceilings, gorgeous wood moldings, natural hardwood flooring and grand spiral staircase. The kitchen opens to the den with gas log fireplace and large sliding doors to backyard. Dining has a wine room adjacent and powder bath and mudroom on main floor. 3 large bedrooms including primary suite up with ensuite baths, walk in closets and a large Laundry. Elevator capable. Pre-wired for security and sound. All per Seller' ,`Acres` = '' ,`Area` = '16' ,`BuilderName` = 'Lake Street Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Upper Kirby' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 1 Block 1, David Crockett Second Replat Partial Replat' ,`LotDesciption` = 'Patio Lot' ,`LotSize` = '4557' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '100' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'POE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LANIER MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'David Crockett' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667145726' WHERE `Matrix_Unique_ID` = '204114136' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T09:08:45.597' ,`MLSNumber` = '89109446' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.402582' ,`Longitude` = '-95.508158' ,`PhotoCount` = '29' ,`PostalCode` = '77318' ,`RoomCount` = '13' ,`ListPrice` = '499963.00' ,`Status` = 'Active' ,`StreetName` = 'Gray Pine Grove' ,`StreetNumber` = '160' ,`StreetSuffix` = 'Way' ,`City` = 'Willis' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3002' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Savannah, Elevation A) One Story. 4 bedrooms. 3 full baths. Family Room and Informal Dining/Breakfast Room adjacent to the island Kitchen. Living Room/Study and Game Room. Covered patio and attached 2 car garage. The Woodlands Hills is located 13 miles north of The Woodlands in Conroe and Willis, Texas. It is a 2,000-acre forested master planned community, featuring 112 acres of open space, 20 neighborhood parks, a 17-acre Village Park and an activity center with event space and fitness facility. The community will also include an extensive amount of trails for hiking and biking in addition to dedicated bike lanes.' ,`Acres` = '0.1644' ,`Area` = '39' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'BLOCK 2, LOT 32' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7160' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '995' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'W. LLOYD MEADOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERT P. BRABHAM MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'The Woodlands Hills' ,`TaxAmount` = '1428' ,`TaxRate` = '3.2823' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667145727' WHERE `Matrix_Unique_ID` = '205381641' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T08:58:55.020' ,`MLSNumber` = '90701906' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.200163' ,`Longitude` = '-95.337626' ,`PhotoCount` = '38' ,`PostalCode` = '77302' ,`RoomCount` = '16' ,`ListPrice` = '584987.00' ,`Status` = 'Active' ,`StreetName` = 'Berry Brook' ,`StreetNumber` = '15020' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3425' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Preston III, Elevation IS) CURRENTLY BEING BUILT. Two Story. 4 bedrooms, 3.5 baths. Private Primary Suite with spacious walk-in closet downstairs. Formal Dining Room and Study with Spacious Kitchen and breakfast area open to Family Room. Spacious Game Room upstairs with private Media Room. Covered patio and attached 2 car garage. Artavia, a master-planned community, will thrill you with endless possibilities just minutes from your home in Conroe, Texas. You’ll enjoy wide, outdoor spaces great for an active lifestyle and its convenient location. Onsite school is currently under construction! Stop by the Westin Homes model home today to find out more about Artavia!' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 9 BLK 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8059' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '985' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'SAN JACINTO ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CANEY CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MOORHEAD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Artavia' ,`TaxAmount` = '' ,`TaxRate` = '3.26' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667145727' WHERE `Matrix_Unique_ID` = '206383449' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T09:09:38.310' ,`MLSNumber` = '59938963' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.397654' ,`Longitude` = '-95.506295' ,`PhotoCount` = '30' ,`PostalCode` = '77318' ,`RoomCount` = '18' ,`ListPrice` = '649457.00' ,`Status` = 'Active' ,`StreetName` = 'Stellar Hills' ,`StreetNumber` = '130' ,`StreetSuffix` = 'Court' ,`City` = 'Willis' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3891' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Carter XL, Elevation GP) Two Story. 5 bedrooms, 4.5 baths. Private Primary Suite with spacious double walk-in closets downstairs. Formal Dining Room and Study with Spacious Kitchen and breakfast area open to Family Room. Spacious Game Room upstairs with private Media Room. Extended covered patio and attached 2 car garage. The Woodland Hills is located 13 miles north of The Woodlands in Conroe and Willis, Texas. It is a 2,000-acre forested master planned community, featuring 112 acres of open space, 20 neighborhood parks, a 17-acre Village Park and an activity center with event space and fitness facility. The community will also include an extensive amount of trails for hiking and biking in addition to dedicated bike lanes. Stop by the Westin Homes model to learn more about The Woodland Hills!' ,`Acres` = '0.2112' ,`Area` = '39' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'BLOCK 1, LOT 22' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9198' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '995' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'W. LLOYD MEADOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERT P. BRABHAM MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'The Woodlands Hills' ,`TaxAmount` = '952' ,`TaxRate` = '3.2823' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667145727' WHERE `Matrix_Unique_ID` = '206938291' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T09:33:22.183' ,`MLSNumber` = '75261274' ,`ListAgentFullName` = 'Sandra Tsui' ,`ListOfficeName` = 'Keller Williams Realty -SW' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.704495' ,`Longitude` = '-95.418003' ,`PhotoCount` = '24' ,`PostalCode` = '77030' ,`RoomCount` = '8' ,`ListPrice` = '720000.00' ,`Status` = 'Active' ,`StreetName` = 'Gramercy' ,`StreetNumber` = '2526' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2767' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful home is located on a large corner lot (9520 sqft) at Gramercy and Kirby. Minutes to medical center, rice village, and Herman Park. This timeless single story home boasts 3 large bedrooms, extremely spacious living and family rooms along with formal dining. The home boasts an outstanding open kitchen, updated granite counter tops in kitchen, dryer, dishwasher, furnaces, and refrigerator. Alon with wood flooring in family, kitchen, and breakfast.' ,`Acres` = '0.2185' ,`Area` = '17' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Rice/Museum District' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 18 & TR 19A BLK 27 BRAESWOOD' ,`LotDesciption` = 'Corner' ,`LotSize` = '9520' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ROBERTS ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Braeswood' ,`TaxAmount` = '13450' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667145727' WHERE `Matrix_Unique_ID` = '207773613' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T09:10:07.887' ,`MLSNumber` = '26741072' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.397611' ,`Longitude` = '-95.506315' ,`PhotoCount` = '27' ,`PostalCode` = '77318' ,`RoomCount` = '13' ,`ListPrice` = '639838.00' ,`Status` = 'Active' ,`StreetName` = 'Stellar Hills' ,`StreetNumber` = '114' ,`StreetSuffix` = 'Court' ,`City` = 'Willis' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3328' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Lorraine II, Elevation D) One Story. 4 bedrooms, 3.5 baths. Study as well as spacious island kitchen open to Family Room and Dining room. Primary suite with large walk-in closet. Covered patio and attached 3 car tandem garage. The Woodland Hills is located 13 miles north of The Woodlands in Conroe and Willis, Texas. It is a 2,000-acre forested master planned community, featuring 112 acres of open space, 20 neighborhood parks, a 17-acre Village Park and an activity center with event space and fitness facility. The community will also include an extensive amount of trails for hiking and biking in addition to dedicated bike lanes. Stop by the Westin Homes model to learn more about The Woodland Hills!' ,`Acres` = '0.2214' ,`Area` = '39' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'BLOCK 1, LOT 18' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9646' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '995' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'W. LLOYD MEADOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERT P. BRABHAM MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'The Woodlands Hills' ,`TaxAmount` = '952' ,`TaxRate` = '3.2823' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667145727' WHERE `Matrix_Unique_ID` = '207783235' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T09:50:21.273' ,`MLSNumber` = '16343606' ,`ListAgentFullName` = 'Octavio Figueroa' ,`ListOfficeName` = 'La Palma Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.837888' ,`Longitude` = '-95.392687' ,`PhotoCount` = '8' ,`PostalCode` = '77022' ,`RoomCount` = '5' ,`ListPrice` = '209990.00' ,`Status` = 'Active' ,`StreetName` = 'Mercedes' ,`StreetNumber` = '4927' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1411' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Very nice home, partial remodeled 12 months ago.' ,`Acres` = '0.1715' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 18 BLK 4 GLENBURNIE SEC 3' ,`LotDesciption` = 'Other' ,`LotSize` = '7470' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'KENNEDY ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WASHINGTON HIGH SCHOOL' ,`SchoolMiddle` = 'WILLIAMS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Glenburnie Sec 03' ,`TaxAmount` = '2685' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1667145728' WHERE `Matrix_Unique_ID` = '207999719' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T09:08:33.540' ,`MLSNumber` = '37928846' ,`ListAgentFullName` = 'Charlotte Williams' ,`ListOfficeName` = 'Keller Williams Arlington' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '32.306616' ,`Longitude` = '-95.252570' ,`PhotoCount` = '50' ,`PostalCode` = '75707' ,`RoomCount` = '13' ,`ListPrice` = '949900.00' ,`Status` = 'Active' ,`StreetName` = 'Lakemont' ,`StreetNumber` = '3504' ,`StreetSuffix` = 'Drive' ,`City` = 'Tyler' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4558' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'IMPECCABLE Mediterranean home located in the The Woods of Tyler. This gorgeous stucco home on almost 0.9 acres is distinctly European countryside. With 4 bedroom and 3.5 baths and touches like marble countertops, travertine and saltillo tile, and multiple gas-log fireplaces, this home is a MUST SEE! The grand foyer opens to expansive formal living and formal dining areas capped by soaring coffered ceilings. Retreat to the ivy-covered outdoor haven with welcoming patio and marvelous outdoor fireplace. The Chef’s kitchen comes complete with gas range with griddle and 6 burners and multiple amenities and is open to an inviting family room anchored by floor-to-ceiling windows. The stately Master Suite will be a private sanctuary with his-and-hers separate sinks, soaking tub, and walk-in shower! Guest bedrooms feature hardwood floors and slate tile bathrooms. An extra-large utility room is a wonderful bonus. This exquisite Mediterranean home is an entertainer’s paradise. Call today!' ,`Acres` = '' ,`Area` = '84' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Reports Available' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '3' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'BLOCK 1441-B LOT 5-B U-1 STOREY LAKE ESTATES' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '258 - Chapel Hill (Smith)' ,`SchoolElementary` = '' ,`SchoolHigh` = '' ,`SchoolMiddle` = '' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Mediterranean' ,`Subdivision` = 'Storey Lake Estates' ,`TaxAmount` = '10752' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667145728' WHERE `Matrix_Unique_ID` = '208112531' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T09:39:37.983' ,`MLSNumber` = '19260885' ,`ListAgentFullName` = 'Thomas Heilman' ,`ListOfficeName` = 'Zion Premier Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.791758' ,`Longitude` = '-95.096860' ,`PhotoCount` = '28' ,`PostalCode` = '77360' ,`RoomCount` = '5' ,`ListPrice` = '234000.00' ,`Status` = 'Active' ,`StreetName` = 'Brown' ,`StreetNumber` = '114' ,`StreetSuffix` = 'Avenue' ,`City` = 'Onalaska' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1188' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Motivated Seller!!! Contributions toward closing costs will be considered. Come take a look at this unique property on interior, corner lots just under 2/3 ac.& less than 1/4 mile from Lake Livingston. Subdivision is outside the city limits and neighborhood borders the lake. This is NOT a mobile home! Rustic/cabin feel with open living area, large 40 x 30 workshop/living area with full bathroom, sleeping quarters and kitchen, 10 x 16 screened porch, fenced back yard with an above ground pool. 15 x 11 screened in rear porch, 11 x 10 rear deck. Nearby boat launch. Virtual walk-through tour is available for you to walk through the property. Just click the movie reel and let your mouse be your feet! Please Note: Hot tub is not included with the sale.' ,`Acres` = '0.6483' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'STOWAWAY BAY LOT 18 & 19' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '28239' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Above Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Aluminum,Composition' ,`SchoolDistrict` = '104 - Onalaska' ,`SchoolElementary` = 'ONALASKA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ONALASKA JR/SR HIGH SCHOOL' ,`SchoolMiddle` = 'ONALASKA JR/SR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Stowaway Bay' ,`TaxAmount` = '3293' ,`TaxRate` = '2.054' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667145728' WHERE `Matrix_Unique_ID` = '208434134' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T09:00:50.850' ,`MLSNumber` = '95005303' ,`ListAgentFullName` = 'Lily Ling' ,`ListOfficeName` = 'Lily H. Ling, REALTOR' ,`SellingAgentFullName` = 'Elliott Spruce' ,`SellingOfficeName` = 'Stanfield Properties' ,`Latitude` = '29.568456' ,`Longitude` = '-95.560215' ,`PhotoCount` = '20' ,`PostalCode` = '77459' ,`RoomCount` = '8' ,`ListPrice` = '369000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Talia Wood' ,`StreetNumber` = '3519' ,`StreetSuffix` = 'Court' ,`City` = 'Missouri City' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2410' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Very conveniently located along Highway 6 and FM 1092/Murphy/University Blvd. Walking distance to two parks as well as Krogers, Target, Lowes, and other shops and restaurants. Rare floorplan of 3 out of the 4 bedroom suites( master bath and Hollywood bath between 2nd and 3rd bedroom) + study+ powder room are ALL ON 1ST FLOOR. Game room + 4th bedroom suite are on 2nd floor. Gorgeous stucco/stone/brick exterior. Lush landscaping. Corner lot. Built in 2015 close by Quail Valley Gulf club. Open and high ceiling. red oak hardwood. marble backsplash. custom cabinets. nice countertop. Chandeliers, Porcelain tiles. Pre-wired security. Energy Star. exterior gas connection in back yard close to back door. Samsung refrigerator, washer and dryer will stay. If you like to have a one story home with extra space upstairs, This house will be your best option. This Property and entire neighborhood (Talia Wood) did not flood in Harvey.' ,`Acres` = '0.1018' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'TALIA WOOD PATIO HOMES, BLOCK 2, LOT 13' ,`LotDesciption` = 'Corner' ,`LotSize` = '4435' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'QUAIL VALLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ELKINS HIGH SCHOOL' ,`SchoolMiddle` = 'QUAIL VALLEY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Back,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Talia Wood Patio Homes' ,`TaxAmount` = '6249' ,`TaxRate` = '2.33' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667145728' WHERE `Matrix_Unique_ID` = '209164775' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T09:07:33.260' ,`MLSNumber` = '29643591' ,`ListAgentFullName` = 'Pablo Guerrero' ,`ListOfficeName` = 'Lucky Money Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.151543' ,`Longitude` = '-95.535447' ,`PhotoCount` = '30' ,`PostalCode` = '77389' ,`RoomCount` = '13' ,`ListPrice` = '1490000.00' ,`Status` = 'Active' ,`StreetName` = 'Johnathan Landing' ,`StreetNumber` = '27' ,`StreetSuffix` = 'Court' ,`City` = 'Spring' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4496' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Located in Carlton Woods Fazio, this residence offers great open spaces to entertain friends and family. Hardwood flooring, four fireplaces, a formal dining room, open-plan gourmet kitchen with stainless steel appliances and granite island. The living room has double height ceilings and white bay windows with motorized drapery and french doors opening out to the backyard patio with a heated pool and spa and a separate dining area with grill. The house has four bedrooms, a media room, a library and lots of storage. The bedroom on the main level has french doors to the backyard and pool. The master bedroom is located on the second level and has a built-out walk-in closet, fireplace, and a balcony with a nice view. The master bath has a double shower and a spa-tub. The two other bedrooms upstairs have their own bathroom and closet. Downstairs, the library with floor to ceiling bookshelves can be used as a home-office. This house has an independent full-size room w/bathroom in the garage.' ,`Acres` = '0.2258' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '4' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 2 BLK 3 THE WOODLANDS CARLTON WOODS CREEKSIDE 6 IN THE VI' ,`LotDesciption` = 'Waterfront' ,`LotSize` = '9838' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Slate' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'TIMBER CREEK ELEMENTARY SCHOOL (Tomball)' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'CREEKSIDE PARK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'The Woodlands Carlton Woods Creekside 06' ,`TaxAmount` = '33485' ,`TaxRate` = '2.6895' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667145728' WHERE `Matrix_Unique_ID` = '209392417' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T09:54:46.847' ,`MLSNumber` = '39457657' ,`ListAgentFullName` = 'Cindy Watson' ,`ListOfficeName` = 'Woodlands Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.989956' ,`Longitude` = '-95.505454' ,`PhotoCount` = '44' ,`PostalCode` = '77069' ,`RoomCount` = '6' ,`ListPrice` = '287770.00' ,`Status` = 'Active' ,`StreetName` = 'Cashel Castle' ,`StreetNumber` = '4726' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2250' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Desirable floorplan, 4 bedroom (Primary & additional bedroom down), 3 full bath (2 full baths down), 2 car garage on a corner lot! July 2022- All new Primed Hardi Plank, w/ LE Housewrap- Radiant Barrier & exterior paint, professionally done by Houston Siding Company and comes with warranty. *Brand new- front double doors, & new doors throughout house including door leading into garage. *Master bath completely remodeled w/ all the bells and whistles, including surround sound, & wiring for TV, 10x20 primary closet w/ barn door *Fresh paint throughout inside *All bedrooms equipped with ceiling fans & have spacious closets; New attic door installed, Tall ceilings in living room. Garage has added 220 Volt outlets (can hold 2 electric cars), wireless garage door opener w/ battery back-up. Community pool & Tennis Courts just across the street. Ring Doorbell w/ 4 additional cameras, (2) Nest, and Washer/ Dryer and Refrigerator ALL stay. FRONT YARD MAINTENANCE DONE BY HOA ONCE A WEEK.' ,`Acres` = '0.161' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'TR 12B VBLK 10 017*C0362900-002-010-012 CASHEL FOREST SEC 2' ,`LotDesciption` = 'Corner' ,`LotSize` = '7011' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '850' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'MITTELSTADT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN HIGH SCHOOL' ,`SchoolMiddle` = 'KLEB INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cashel Forest Sec 02' ,`TaxAmount` = '4821' ,`TaxRate` = '2.61' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1984' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667145728' WHERE `Matrix_Unique_ID` = '209662330' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T09:17:53.310' ,`MLSNumber` = '76607408' ,`ListAgentFullName` = 'Ignacio Avila' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.331776' ,`Longitude` = '-95.514435' ,`PhotoCount` = '35' ,`PostalCode` = '77304' ,`RoomCount` = '4' ,`ListPrice` = '585000.00' ,`Status` = 'Active' ,`StreetName` = 'Fork' ,`StreetNumber` = '4874' ,`StreetSuffix` = 'Boulevard' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3047' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great property with spectacular views.\r\nThe backyard has a beautiful view of the green, creek and wooded area.\r\nThe amount of light welcomes every individual the moment the main door is opened.\r\nThere is a patio that will create unforgettable afternoons and family reunions. \r\nRoom dimensions are approximate. Need validation.' ,`Acres` = '0.2483' ,`Area` = '19' ,`BuilderName` = 'Toch Properties' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S949103 - WEST FORK 03, BLOCK 1, LOT 3, ACRES 0.2483' ,`LotDesciption` = 'Cul-De-Sac,On Golf Course' ,`LotSize` = '10816' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'GIESINGER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'West Fork 03' ,`TaxAmount` = '946' ,`TaxRate` = '2.1863' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667145729' WHERE `Matrix_Unique_ID` = '210080394' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T09:36:07.997' ,`MLSNumber` = '5429421' ,`ListAgentFullName` = 'Rashad Garrett' ,`ListOfficeName` = 'Brooks & Davis Real Estate' ,`SellingAgentFullName` = 'Rashad Garrett' ,`SellingOfficeName` = 'Brooks & Davis Real Estate' ,`Latitude` = '29.444847' ,`Longitude` = '-95.440475' ,`PhotoCount` = '6' ,`PostalCode` = '77583' ,`RoomCount` = '2' ,`ListPrice` = '249999.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Peridot Green' ,`StreetNumber` = '9419' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1659' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.1401' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'STERLING LAKES AT IOWA COLONY SEC 9 (A0289 HT&B) BLK 1 LOT 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6103' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'SANCHEZ ELEMENTARY SCHOOL (ALVIN)' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Temporarily No Showings' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sterling Lakes At Iowa Colony' ,`TaxAmount` = '5989' ,`TaxRate` = '3.4099' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2011' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667145729' WHERE `Matrix_Unique_ID` = '210131416' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T09:56:12.660' ,`MLSNumber` = '39849271' ,`ListAgentFullName` = 'Linda Corona' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.997140' ,`Longitude` = '-95.410829' ,`PhotoCount` = '38' ,`PostalCode` = '77073' ,`RoomCount` = '13' ,`ListPrice` = '399000.00' ,`Status` = 'Active' ,`StreetName` = 'Southship' ,`StreetNumber` = '20906' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '6' ,`SqFtTotal` = '4163' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful, probably the biggest house in this subdivision, Both Formals Dinning and Living areas plus two story ceiling family-room, Master suite downstairs, 5 nice size bedrooms upstairs and a TV/Game room. this home has a fresh coat of paint and brand new carpet. Please verify room measurements. This home is close to I-45 and also to Hardy Toll Road, close to Restaurants and Shopping centers.' ,`Acres` = '0.1831' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Aldine Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 35 BLK 2 NORTHRIDGE PARK WEST SEC' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '7975' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '345' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'EICKENROHT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ANDY DEKANEY H S' ,`SchoolMiddle` = 'RICKY C BAILEY M S' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Northridge Park West Sec 02' ,`TaxAmount` = '7276' ,`TaxRate` = '2.5554' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667145729' WHERE `Matrix_Unique_ID` = '210242846' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T08:29:29.867' ,`MLSNumber` = '48264136' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.094790' ,`Longitude` = '-95.382634' ,`PhotoCount` = '36' ,`PostalCode` = '77386' ,`RoomCount` = '15' ,`ListPrice` = '480000.00' ,`Status` = 'Active' ,`StreetName` = 'Chris Ridge' ,`StreetNumber` = '27502' ,`StreetSuffix` = 'Court' ,`City` = 'Spring' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3579' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to Spring Trails in the highly desired section of Red Bud. This home sits right across the street from a pond and is walking distance to Broadway Elementary. It features 4 bedrooms, and 3.5 bathrooms, and sits on a large corner lot. Downstairs, the gourmet kitchen opens to the family room and dining area, providing the perfect place to entertain. In addition, the downstairs area features a home office with french doors, a formal dining area, the Owner\'s suite, and an additional bedroom. Upstairs you will find a Game Room and Media Room, along with 2 bedrooms and bathrooms. The backyard has a covered patio with grilling area and a spacious yard with lots of opportunity for fun. Roof was replaced in 2021!' ,`Acres` = '0.2119' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S901412 - SPRING TRAILS 12, BLOCK 1, LOT 37' ,`LotDesciption` = 'Corner,Cul-De-Sac,Subdivision Lot' ,`LotSize` = '9229' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '720' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'BROADWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GRAND OAKS HIGH SCHOOL' ,`SchoolMiddle` = 'YORK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Spring Trails' ,`TaxAmount` = '9253' ,`TaxRate` = '2.6137' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667145729' WHERE `Matrix_Unique_ID` = '210519891' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T09:19:40.730' ,`MLSNumber` = '59394855' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'LennarVillageBldr-JaredTurner' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.168270' ,`Longitude` = '-95.191041' ,`PhotoCount` = '10' ,`PostalCode` = '77357' ,`RoomCount` = '9' ,`ListPrice` = '343990.00' ,`Status` = 'Active' ,`StreetName` = 'Camellia Birch' ,`StreetNumber` = '23642' ,`StreetSuffix` = 'Court' ,`City` = 'New Caney' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2289' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Sensational NEW Lennar Homes Wildflower Series, \'\'Larkspur II\'\' Plan with Elevation \'\'B\'\' in beautiful Tavola! Amazing 2 Story 4 bedroom 2.5 bath 2 car garage with Game Room up! Island Kitchen w/ Breakfast Area, Great Appliance Pkg, 36\'\' Designer Cabs & Sparkling Countertops! Large W/I Pantry. Spacious Family Room and a Study! Master Suite down features Shower w/ Seat, Large Walk-in Closet! Extensive Hard Surface Floors; Covered Patio, Fully Sodded Yard, Landscape Pkg; 16 SEER HVAC System & More!' ,`Acres` = '' ,`Area` = '40' ,`BuilderName` = 'Lennar Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Porter/New Caney East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S921137 - Tavola 37, BLOCK 2, Lot 35' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'TAVOLA ELEMENTARY SCHOOL (NEW CANEY)' ,`SchoolHigh` = 'NEW CANEY HIGH SCHOOL' ,`SchoolMiddle` = 'KEEFER CROSSING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Tavola' ,`TaxAmount` = '' ,`TaxRate` = '3.5826' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667145729' WHERE `Matrix_Unique_ID` = '210723608' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T09:46:15.750' ,`MLSNumber` = '68633194' ,`ListAgentFullName` = 'Fernando Rodriguez' ,`ListOfficeName` = 'RE/MAX Northwest, REALTORS' ,`SellingAgentFullName` = 'Heather Daniel' ,`SellingOfficeName` = 'Rogers Healy & Associates' ,`Latitude` = '30.010732' ,`Longitude` = '-95.196768' ,`PhotoCount` = '41' ,`PostalCode` = '77346' ,`RoomCount` = '8' ,`ListPrice` = '179900.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Swiftbrook' ,`StreetNumber` = '19903' ,`StreetSuffix` = 'Drive' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1764' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful floorplan. 1 story home with large front and back yard. 3 Bed 2 Full Bath \r\n\r\nThis home is ready to be customized perfectly to fit your family and still won\'t be above value for the subdivision. All about the imagination. Kitchen has been completely gutted so you may customize it how you want.' ,`Acres` = '0.1925' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Atascocita North' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 35 BLK 3 ATASCOCITA NORTH SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8386' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'OAKS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ATASCOCITA HIGH SCHOOL' ,`SchoolMiddle` = 'TIMBERWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Atascocita North Sec 02' ,`TaxAmount` = '4041' ,`TaxRate` = '2.613' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667145730' WHERE `Matrix_Unique_ID` = '210772266' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T08:06:42.027' ,`MLSNumber` = '48866261' ,`ListAgentFullName` = 'Guillermo Corona' ,`ListOfficeName` = 'B & W Realty Group LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.799938' ,`Longitude` = '-95.712176' ,`PhotoCount` = '20' ,`PostalCode` = '77084' ,`RoomCount` = '6' ,`ListPrice` = '200000.00' ,`Status` = 'Active' ,`StreetName` = 'Leafwood' ,`StreetNumber` = '19410' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1384' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 19410 Leafwood Ln. This single story, 3 bedroom 2 bath is located in the Westlake subdivision in Katy TX. This home is conveniently located just minutes away from I-10 with quick access to shopping and entertainment. This property is perfect as a starter home or fix and flip project.\r\nCall today to schedule your private tour.' ,`Acres` = '0.1865' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 3 BLK 6 WESTLAKE SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8125' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '475' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'MAYDE CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAYDE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MAYDE CREEK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Westlake Sec 01' ,`TaxAmount` = '3949' ,`TaxRate` = '2.4758' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1972' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667145730' WHERE `Matrix_Unique_ID` = '211312206' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T08:44:15.703' ,`MLSNumber` = '43882609' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'LennarVillageBldr-JaredTurner' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.194336' ,`Longitude` = '-95.210414' ,`PhotoCount` = '26' ,`PostalCode` = '77357' ,`RoomCount` = '7' ,`ListPrice` = '245000.00' ,`Status` = 'Active' ,`StreetName` = 'Birchfield Grove' ,`StreetNumber` = '22219' ,`StreetSuffix` = 'Lane' ,`City` = 'New Caney' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1683' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW Cottage Series \'\'Camellia II\" Elevation-C by Lennar in amazing Pinewood at Grand Texas!!! The wonderful single story Camellia floor plan has a smart layout. The front door leads to an open concept living area that is ideal for daily activities and entertaining guests with a modern kitchen, dining room and family room, all side by side. Three bedrooms share a hall bathroom at the front of the home, while the owner’s suite is tucked into the back with a private bathroom and large walk-in closet.' ,`Acres` = '' ,`Area` = '40' ,`BuilderName` = 'Lennar Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Porter/New Caney West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Sec 02, BLOCK 1, Lot 048' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '47 - Splendora' ,`SchoolElementary` = 'TIMBER LAKES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPLENDORA HIGH SCHOOL' ,`SchoolMiddle` = 'SPLENDORA JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Pinewood at Grand Texas' ,`TaxAmount` = '' ,`TaxRate` = '3.35' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667145730' WHERE `Matrix_Unique_ID` = '211745948' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T08:38:25.940' ,`MLSNumber` = '78345965' ,`ListAgentFullName` = 'Sally Harris' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = 'Kelty Ferguson' ,`SellingOfficeName` = 'Martha Turner Sotheby\'s International Realty' ,`Latitude` = '30.098223' ,`Longitude` = '-95.399215' ,`PhotoCount` = '38' ,`PostalCode` = '77386' ,`RoomCount` = '11' ,`ListPrice` = '335000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Connordale' ,`StreetNumber` = '28543' ,`StreetSuffix` = 'Lane' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2665' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'OFFER has been accepted- awaiting checks to be delivered. Price Adjustment to $335K! Incredible opportunity to purchase this beautiful 1.5 story in highly desirable Spring Trails- 28543 Connordale Ln! Charming property offers 3-4 bedrooms, 2 full bathrooms, study/office, dining room, spacious family room opens to kitchen & breakfast room on first floor with game room & 1 half bathroom upstairs. New AC system installed 2022- 4 zones. Lovely natural light & excellent storage. Stainless steel appliances & granite in this kitchen- SS refrigerator stays with the property. Beautiful landscaping in front & backyards. Covered back patio. Spring Trails Amenities: clubhouse, pool, parks, basketball & tennis courts, miles of walking/jogging trails, sidewalks throughout community. Ideal location to Grand Pkwy 99, Hardy Toll, Aggie Freeway, I-45 & The Woodlands. Close to shopping, dining, movie theaters & more! Zoned to exemplary rated CISD-Broadway Elementary School located within the community.' ,`Acres` = '0.1593' ,`Area` = '40' ,`BuilderName` = 'Darling' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S901405 - SPRING TRAILS 05, BLOCK 2, LOT 57' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '6940' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '720' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'BROADWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GRAND OAKS HIGH SCHOOL' ,`SchoolMiddle` = 'YORK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Spring Trails 05' ,`TaxAmount` = '6987' ,`TaxRate` = '2.6137' ,`WaterSewer` = 'Other Water/Sewer,Water District' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667145730' WHERE `Matrix_Unique_ID` = '211834091' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T09:46:52.050' ,`MLSNumber` = '67242169' ,`ListAgentFullName` = 'Beverly Bradley' ,`ListOfficeName` = 'Weekley Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.279590' ,`Longitude` = '-95.568047' ,`PhotoCount` = '26' ,`PostalCode` = '77316' ,`RoomCount` = '7' ,`ListPrice` = '450000.00' ,`Status` = 'Active' ,`StreetName` = 'Bungalow' ,`StreetNumber` = '183' ,`StreetSuffix` = 'Drive' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2408' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to the classic comfort and contemporary design combination of The Ziegler luxury home plan. Each upstairs bedroom provides a great place to grow and its own walk-in closet. The sunlit open floor plan is suited for daily life and hosting special occasions, and offers a beautiful backyard view. Easily prepare family meals and party spreads in the streamlined kitchen. Enjoy the outdoors from the comfort of your generous covered patio. Your owner\'s retreat gives you a beautiful place to begin and end every day in luxury with a deluxe bathroom with super shower and walk-in closet. The upstairs retreat and downstairs study and dining areas provide FlexSpace for you to design the specialty rooms you\'ve been dreaming of. Build your future together in this splendid new home plan.' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'David Weekley Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 5 Block 3' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '5250' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1300' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'STEWART ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'OAK HILL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Woodforest' ,`TaxAmount` = '' ,`TaxRate` = '3.356' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667145730' WHERE `Matrix_Unique_ID` = '211867131' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T09:44:41.697' ,`MLSNumber` = '58671152' ,`ListAgentFullName` = 'Colby Hearn' ,`ListOfficeName` = 'Keller Williams Woodlands' ,`SellingAgentFullName` = 'Michele Harmon' ,`SellingOfficeName` = 'RE/MAX Universal' ,`Latitude` = '30.174715' ,`Longitude` = '-95.611561' ,`PhotoCount` = '45' ,`PostalCode` = '77354' ,`RoomCount` = '12' ,`ListPrice` = '995000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Champions Ridge' ,`StreetNumber` = '28515' ,`StreetSuffix` = 'Road' ,`City` = 'Magnolia' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4525' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Private, country living, yet close to The Woodlands! Spacious, updated home on 5-acre lot. LIGHTLY RESTRICTED/NO HOA, LOW TAX RATE! NOT IN FLOOD ZONE/NEVER FLOODED! POOL/SPA. Open floor plan, great for entertaining, updated kitchen with built-in, extra-large subzero refrigerator, separate built-in ice maker, and brand new energy star appliances. Step into luxury in a completely remodeled primary bathroom with walk-in granite shower, complete with LED Mirror and chandelier! Primary bedroom downstairs. Large, covered patio that wraps around the multi-room, air-conditioned shop/private workspace. Fully fenced-in property and automatic privacy gate. Gorgeous, picture windows give way to backyard view of pool/spa and large open green space. New double paned, energy efficient windows (exception-picture windows). Main house AC units replaced within last 5 years. Brand new 2022 carpet, never lived in, throughout most of home. Per MCAD-Total Sq. footage includes detached shop.' ,`Acres` = '5' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Propane' ,`HOAMandatory` = '0' ,`Legal` = 'ASCOT FARMS 03, BLOCK 3, LOT 13' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '217800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'CEDRIC C. SMITH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Ascot Farms 03' ,`TaxAmount` = '11375' ,`TaxRate` = '1.8587' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667145731' WHERE `Matrix_Unique_ID` = '212093950' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T08:16:29.330' ,`MLSNumber` = '59688794' ,`ListAgentFullName` = 'James Polomsky' ,`ListOfficeName` = 'Red Door Realty & Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.929497' ,`Longitude` = '-95.075197' ,`PhotoCount` = '25' ,`PostalCode` = '77532' ,`RoomCount` = '8' ,`ListPrice` = '240000.00' ,`Status` = 'Active' ,`StreetName` = 'Lighthouse' ,`StreetNumber` = '17006' ,`StreetSuffix` = 'Drive' ,`City` = 'Crosby' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1806' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Lovely 3 bedroom 2 full bath one story. Open concept home with split floor plan. Crown molding, recessed lighting and granite in the kitchen and bathrooms. Walk -in closets. Granite Island with breakfast bar. Double paned windows and fully fenced backyard. Make your appoint today.' ,`Acres` = '0.1567' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Crosby Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 7 BLK 8 NEWPORT SEC 3' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot' ,`LotSize` = '6825' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '12 - Crosby' ,`SchoolElementary` = 'NEWPORT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CROSBY HIGH SCHOOL' ,`SchoolMiddle` = 'CROSBY MIDDLE SCHOOL (CROSBY)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Newport' ,`TaxAmount` = '4775' ,`TaxRate` = '2.7105' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667145731' WHERE `Matrix_Unique_ID` = '212095019' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T08:26:44.180' ,`MLSNumber` = '59069567' ,`ListAgentFullName` = 'Suzanne Heber' ,`ListOfficeName` = 'Kingdom First Realty LLC' ,`SellingAgentFullName` = 'Stephanie Sallick' ,`SellingOfficeName` = 'Coldwell Banker Realty' ,`Latitude` = '30.012453' ,`Longitude` = '-95.562270' ,`PhotoCount` = '38' ,`PostalCode` = '77379' ,`RoomCount` = '8' ,`ListPrice` = '279500.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Galston' ,`StreetNumber` = '9703' ,`StreetSuffix` = 'Lane' ,`City` = 'Spring' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '6' ,`SqFtTotal` = '2864' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Incredible 6 bedroom, 3 bath home ready for your family and friends. Many recent updates include kitchen cabinets, granite countertops throughout, appliances, vinyl laminate flooring, and a complete new interior paint job. The entire HVAC system is only three years old. A brand new fence encloses the backyard providing plenty of privacy. Your family and friends will enjoy the spacious game room upstairs. You don\'t want to miss this home priced to sell. Property owner is related to listing broker.' ,`Acres` = '0.1591' ,`Area` = '13' ,`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` = 'Champions Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 6 BLK 22 017*G4555400-002-022-006 GLENLOCH SEC 2' ,`LotDesciption` = 'Cleared' ,`LotSize` = '6930' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '340' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'KRAHN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN CAIN HIGH SCHOOL' ,`SchoolMiddle` = 'DOERRE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Glenloch Memorial Chase' ,`TaxAmount` = '6165' ,`TaxRate` = '2.4965' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1973' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667145731' WHERE `Matrix_Unique_ID` = '212386460' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T09:19:35.173' ,`MLSNumber` = '10126675' ,`ListAgentFullName` = 'Kristin Kubala' ,`ListOfficeName` = 'Texas Local Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.938149' ,`Longitude` = '-95.688161' ,`PhotoCount` = '44' ,`PostalCode` = '77433' ,`RoomCount` = '14' ,`ListPrice` = '650000.00' ,`Status` = 'Active' ,`StreetName` = 'Dawn River' ,`StreetNumber` = '10914' ,`StreetSuffix` = 'Court' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3345' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Exceptional Village Builders rare Marseille floorplan found on one of the largest lots in Riverbend section of Towne Lake with top of the line finishes and upgrades throughout. All bedrooms are located on first floor with a gameroom, media room and powder bath on second floor. The open concept living areas boast a stunning kitchen with Electrolux appliance package, reverse osmosis system, high level granite & gorgeous pendant lighting. This nicely opens to the formal dining space & the living room for ease of entertaining. The peaceful primary retreat is separated from the secondary bedrooms and also has a light & bright, breathtaking ensuite. Framed mirrors and higher level granite found in each bathroom, no carpet in the entire home & an easily maintainable wood look tile through all of first floor. Top of the line water softener, full gutters around home & sprinkler system. Texas sized porch & backyard that is ready for a pool and more. Walking distance to pocket park & the lake!' ,`Acres` = '0.3768' ,`Area` = '25' ,`BuilderName` = 'Village Builders' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 73 BLK 3 TOWNE LAKE SEC 46' ,`LotDesciption` = 'Cul-De-Sac,In Golf Course Community,Subdivision Lot' ,`LotSize` = '16415' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1699' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'RENNELL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'ANTHONY MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Mediterranean' ,`Subdivision` = 'Towne Lake' ,`TaxAmount` = '17166' ,`TaxRate` = '3.471' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667145731' WHERE `Matrix_Unique_ID` = '212414340' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T08:31:03.653' ,`MLSNumber` = '26940051' ,`ListAgentFullName` = 'Victoria Mora' ,`ListOfficeName` = 'Full Circle Texas, LLC' ,`SellingAgentFullName` = 'Joe Rodriguez' ,`SellingOfficeName` = 'eXp Realty, LLC' ,`Latitude` = '30.077923' ,`Longitude` = '-95.181496' ,`PhotoCount` = '25' ,`PostalCode` = '77345' ,`RoomCount` = '5' ,`ListPrice` = '399000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Wildwood Valley' ,`StreetNumber` = '3810' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2880' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning home in the heart of Kingwood. Traditional style 5 bedroom, 3 full bath on a quiet cup-de-sac that shares the greenbelt with Mills Branch Park. This charming home is ideal for entertaining and boasts a lovely patio with a lush yard filled with mature landscaping. Primary suite is located down with an additional bedroom with full bath...could also be an office. Custom trim carpentry throughout with sweeping stair case that holds 180 degree view of park with custom oak built-in book cases. Kitchen with bay windows will not disappoint and has honey oak cabinets, GE oven, electric cooktop and built in microwave with eat-in breakfast bar. Entire home has Culligan water softener with sink delivered reverse osmosis water filtration. Landscaping is full of heirloom perennial greenery and fruit bearing tress including plum, fig, lemon, lime and nectarines while in season. Roof (2015) Water Heaters (2019) Exterior Paint (2019). Easy access to the Grand Parkway and 35 minutes to Downtown' ,`Acres` = '0.199' ,`Area` = '32' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Kingwood East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 25 BLK 3 MILLS BRANCH VILLAGE SEC 5' ,`LotDesciption` = 'Cul-De-Sac,Greenbelt,In Golf Course Community,Subdivision Lot,Wooded' ,`LotSize` = '8669' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '440' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'HIDDEN HOLLOW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KINGWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'CREEKWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Back,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Mills Branch Village Sec 05' ,`TaxAmount` = '6747' ,`TaxRate` = '2.5839' ,`WaterSewer` = 'Public Sewer,Public Water,Well' ,`YearBuilt` = '1993' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667145732' WHERE `Matrix_Unique_ID` = '212419725' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T08:57:19.987' ,`MLSNumber` = '45581617' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Fruge Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.827899' ,`Longitude` = '-95.688365' ,`PhotoCount` = '19' ,`PostalCode` = '77084' ,`RoomCount` = '8' ,`ListPrice` = '238500.00' ,`Status` = 'Active' ,`StreetName` = 'Glen Briar' ,`StreetNumber` = '18522' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1348' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Rare opportunity in a Gem of a subdivision!! Three large bedrooms, 2 baths and attached garage with opener. Ceramic tile flooring- no carpet here! Kitchen recently updated with granite countertops and has large breakfast/dining area. High ceilings in den with fireplace and plenty of natural light. Primary bedroom offers a large walk-in closet and En-suite bath. Secondary bath was recently updated and has a shower with extra wide entrance and seating. Landscaped yard is completely fenced in with black, wrought iron gate for entrance. Interior lighting has been updated. Area pool with green space. Schedule your appointment today!' ,`Acres` = '0.1364' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 22 BLK 4 WOOD FERN SEC 1 R/P' ,`LotDesciption` = 'Patio Lot,Subdivision Lot' ,`LotSize` = '5940' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '440' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'SCHMALZ ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAYDE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'CARDIFF JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Wood Fern' ,`TaxAmount` = '4666' ,`TaxRate` = '2.587' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667145732' WHERE `Matrix_Unique_ID` = '212481352' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T08:37:33.057' ,`MLSNumber` = '68751406' ,`ListAgentFullName` = 'Trisha Salinas' ,`ListOfficeName` = 'Lucky Money Real Estate' ,`SellingAgentFullName` = 'Elsa Rae Anspach' ,`SellingOfficeName` = 'Keller Williams Woodlands' ,`Latitude` = '30.054362' ,`Longitude` = '-95.377863' ,`PhotoCount` = '20' ,`PostalCode` = '77373' ,`RoomCount` = '8' ,`ListPrice` = '265000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Allendale Garden' ,`StreetNumber` = '2414' ,`StreetSuffix` = 'Lane' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2152' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to your SMART home 2414 Allendale Garden Lane!! This gorgeous 2-story home features 2,152 square feet with 4 bedrooms, 2.5 bathrooms, game room, sprinkler system, full gutters, and energy efficient stainless steel appliances. You\'ll love the perfect entertainers layout with an open concept between the living room, dining room, and kitchen. Primary suite has a spacious walk-in closet and ensuite bathroom with dual vanity. This home is just a few minutes away from the community pool/recreational area. Super close to shopping/dining and IAH/Toll/GrandParkway. This home is a true gem. Come and take a look for yourself!' ,`Acres` = '0.1345' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Spring East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 BLK 2 BRECKENRIDGE WEST SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5860' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'GLORIA MARSHALL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'RICKY C BAILEY M S' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Breckenridge West' ,`TaxAmount` = '6689' ,`TaxRate` = '3.0268' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667145732' WHERE `Matrix_Unique_ID` = '212486521' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T09:25:19.057' ,`MLSNumber` = '76505865' ,`ListAgentFullName` = 'Karen Scott' ,`ListOfficeName` = 'Fathom Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.861909' ,`Longitude` = '-95.723097' ,`PhotoCount` = '24' ,`PostalCode` = '77449' ,`RoomCount` = '5' ,`ListPrice` = '296000.00' ,`Status` = 'Active' ,`StreetName` = 'Horse Prairie' ,`StreetNumber` = '5811' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1888' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Well cared for 1 story 4 bedroom 2 bathroom home in Eagle Ranch. The main living space is open concept with an eat-in kitchen space. Dining table and living room space are open to the kitchen, this space is versatile and can accommodate larger furniture as well. The kitchen has great space and enough for a moveable kitchen island. There is plenty of counter, cabinet and pantry space for storage All tile flooring and open concept is perfect for entertaining. Primary bedroom has an en-suite bathroom with dual sinks and shower/tub combo. Great interior lot in quiet section of Eagle Ranch, though convenient to stores, restaurants, 99 freeway, and 529. Plenty of backyard space for games, grilling or gardening. Original owners have maintained and cared for this home since building.' ,`Acres` = '0.1802' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 32 BLK 4 EAGLE RANCH WEST SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7850' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'HEMMENWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS PARK HIGH SCHOOL' ,`SchoolMiddle` = 'ROWE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Eagle Ranch West Sec 01' ,`TaxAmount` = '5483' ,`TaxRate` = '2.831' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667145732' WHERE `Matrix_Unique_ID` = '212613726' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T08:54:54.330' ,`MLSNumber` = '19140535' ,`ListAgentFullName` = 'Joy Samuel' ,`ListOfficeName` = 'Prompt Realty & Mortgage, Inc' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.531733' ,`Longitude` = '-95.472538' ,`PhotoCount` = '30' ,`PostalCode` = '77545' ,`RoomCount` = '4' ,`ListPrice` = '519999.00' ,`Status` = 'Active' ,`StreetName` = 'San Bernard' ,`StreetNumber` = '2727' ,`StreetSuffix` = 'Drive' ,`City` = 'Fresno' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2889' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Loan assumable. Never lived, ready to move in, 2022 built One of a kind spacious single story Ashton woods Hanover model. No more lots available to build this model. 40k upgrades. Incredible energy efficient 4-bedrooms 3.5 bath, tandem three car garage, 8ft doors everywhere. High ceiling. Full Bricks around with stone front. Wow huge kitchen island opens to family room, Formal dining. 42\" cabinets, pull out double trash can under the countertop, remote controlled fireplace, large utility room, 2 bathrooms with standing showers, primary bath with Jacuzzi & shower. Gameroom/media room, bedrooms and family rooms are with carpet, entry dining etc. with tiles. Covered patio with gas line, hot/cold water line for outside kitchen, sprinkler system, garage door opener, 2\" fox wood blinds for all windows. This Gem has it all, see to believe.........! Easy access to Hwy 6 and Fort Bend Toll. Fort bend School district and utilities even though in Fresno.' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'AW' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures,Owner/Agent' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 7, Block 2 Shipman\'s Cove sec-2' ,`LotDesciption` = 'Patio Lot' ,`LotSize` = '7500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'GOODMAN ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'HIGHTOWER HIGH SCHOOL' ,`SchoolMiddle` = 'LAKE OLYMPIA MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Shipman\'s Cove' ,`TaxAmount` = '' ,`TaxRate` = '3.29' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667145732' WHERE `Matrix_Unique_ID` = '212968717' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T08:49:10.790' ,`MLSNumber` = '72690392' ,`ListAgentFullName` = 'Joy Samuel' ,`ListOfficeName` = 'Prompt Realty & Mortgage, Inc' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.586755' ,`Longitude` = '-95.575299' ,`PhotoCount` = '30' ,`PostalCode` = '77459' ,`RoomCount` = '6' ,`ListPrice` = '375000.00' ,`Status` = 'Active' ,`StreetName` = 'Ring' ,`StreetNumber` = '2511' ,`StreetSuffix` = 'Court' ,`City` = 'Missouri City' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2578' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Wow!!!!!! Huge Cul-de- sac lot for swimming pool etc.!!!! Enjoy the Pecan trees at the backyard. NEVER FLOODED! Very tenderly cared 4-bedroom 3 bath High elevation overlooking to Oyster Creek and walk trail. Iron fence, contemporary interior, crown molding, huge primary room with two closets, jetted tub and standing shower.\r\none bedroom downstairs. All bedrooms are with new carpet. All modification has done in timely manner. Fort Bend\'s rated school zone and in First colony. Elementary school within the subdivision. All the amenities are with in 5 minutes of distance. All the measurements are approximate. Please verify upon visit. WASHER/DRYER/REFRIGERATOR AND SECURITY CAMERA SETS ARE INCLUDED.' ,`Acres` = '0.3388' ,`Area` = '29' ,`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` = 'Missouri City Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'PLANTATION CREEK SEC 2-A, BLOCK 2, LOT 3' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '14760' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '812' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'LEXINGTON CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DULLES HIGH SCHOOL' ,`SchoolMiddle` = 'DULLES MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Plantation Creek Sec 2-A' ,`TaxAmount` = '7996' ,`TaxRate` = '2.71' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1993' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667145733' WHERE `Matrix_Unique_ID` = '213090594' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T08:04:29.523' ,`MLSNumber` = '46652944' ,`ListAgentFullName` = 'Brittany Trebus' ,`ListOfficeName` = 'TexasRenters.com, LLC' ,`SellingAgentFullName` = 'Keeyan Sabz' ,`SellingOfficeName` = 'Intero Real Estate Services' ,`Latitude` = '29.946758' ,`Longitude` = '-95.678543' ,`PhotoCount` = '15' ,`PostalCode` = '77433' ,`RoomCount` = '4' ,`ListPrice` = '385000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Cardinal Hills' ,`StreetNumber` = '11718' ,`StreetSuffix` = 'Court' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2507' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful home on a massive culdesac lot! Fresh paint throughout on this 4 bedrooms, 3.5 baths plus dining room and large game room! The kitchen features granite countertops and ceramic tile backsplash. The kitchen is open to the 2 story high living room with window wall. Large primary suite with dual vanities, and separate tub and shower. 2 more bathrooms upstairs as well as the additional spacious bedrooms. The home has a large covered patio in addition to the HUGE yard! There is plenty of space for a pool and to put your stamp on the backyard! Don\'t miss this wonderful home!' ,`Acres` = '0.2674' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Seller may be subject to foreign tax and Buyer withholding per IRS,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 22 BLK 3 ALDER TRAILS SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11646' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'WOODARD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'SPILLANE MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Alder Trails' ,`TaxAmount` = '7799' ,`TaxRate` = '2.711' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667145733' WHERE `Matrix_Unique_ID` = '213153354' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T09:54:04.120' ,`MLSNumber` = '38356169' ,`ListAgentFullName` = 'Chelsea Boone' ,`ListOfficeName` = 'Fathom Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.506701' ,`Longitude` = '-95.061601' ,`PhotoCount` = '32' ,`PostalCode` = '77573' ,`RoomCount` = '8' ,`ListPrice` = '599900.00' ,`Status` = 'Active' ,`StreetName` = 'Austin' ,`StreetNumber` = '2604' ,`StreetSuffix` = 'Street' ,`City` = 'League City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2206' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Meticulously maintained custom 3-bedroom 2-bathroom home on almost an acre. The kitchen has window seating, oversized pantry, island w/ seating, white cabinetry & natural stone countertops! The kitchen is open to the living room w/ wood burning fireplace (never used). The home also has central vac w/ dustpan. The primary bedroom has over 21 adjustable shelves! The primary bath has his & hers sinks w/quartz countertops & a jetted tub w/separate shower. With separate walk-in closets! There is also an additional two bedrooms and bathroom. The back of the property has a spacious backyard w/ 40x40 Whirlwind building! The building has an RV dump w/ lift station! There is also a well house & freshly painted propane tank located on the property. The private well is 145ft deep w/ a 75-gallon tank w/ water softener. Cost effective Aerobic Septic system w/ sprinklers on property! Completely fenced in backyard, concrete patio w/ fire pit! Taxes with homestead exemption come out to $2504.85! ' ,`Acres` = '0.98' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Propane' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 18 M MULDOON SUR TR II SAUNDERS SUB' ,`LotDesciption` = 'Other' ,`LotSize` = '44550' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '8' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'GOFORTH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'LEAGUECITY INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Saunders Sub Tract II' ,`TaxAmount` = '7443' ,`TaxRate` = '2.0697' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667145733' WHERE `Matrix_Unique_ID` = '213201754' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T08:47:40.937' ,`MLSNumber` = '70054634' ,`ListAgentFullName` = 'Brooke Wier' ,`ListOfficeName` = 'Van Slyke Real Estate, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.549316' ,`Longitude` = '-95.674737' ,`PhotoCount` = '42' ,`PostalCode` = '77479' ,`RoomCount` = '9' ,`ListPrice` = '559000.00' ,`Status` = 'Active' ,`StreetName` = 'Shady Way' ,`StreetNumber` = '7730' ,`StreetSuffix` = 'Drive' ,`City` = 'Sugar Land' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3158' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Well maintained and updated beautiful home in Greatwood Trails on a nice cul-de-sac lot! Home features large primary bedroom downstairs, game room upstairs with pool table and furniture, LTV flooring all throughout downstairs except carpet in the primary bedroom and all new carpet upstairs and stairway, recent updated bathrooms. Backyard feels like paradise with a gorgeous with heated pool, hot tub, mosquito misting system, mature trees and ivy brick back fence perfect for relaxing weekends and ending your day on the patio. LCISD with great schools. NEVER FLOODED.' ,`Acres` = '0.2239' ,`Area` = '30' ,`BuilderName` = 'Perry Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'GREATWOOD TRAILS SEC 4, BLOCK 2, LOT 22' ,`LotDesciption` = 'Cul-De-Sac,In Golf Course Community,Subdivision Lot,Wooded' ,`LotSize` = '9751' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '910' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'DICKINSON ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'GEORGE RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'RYON/READING JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Greatwood Trails Sec 4' ,`TaxAmount` = '8834' ,`TaxRate` = '2.3013' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1994' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667145733' WHERE `Matrix_Unique_ID` = '213241955' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T09:11:51.983' ,`MLSNumber` = '29274423' ,`ListAgentFullName` = 'Melissa Siems' ,`ListOfficeName` = 'Taylor Real Estate Group, Inc.' ,`SellingAgentFullName` = 'Yolanda Ames' ,`SellingOfficeName` = 'Keller Williams Realty - Memorial' ,`Latitude` = '29.556883' ,`Longitude` = '-95.436897' ,`PhotoCount` = '16' ,`PostalCode` = '77584' ,`RoomCount` = '7' ,`ListPrice` = '435000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Pebble Falls' ,`StreetNumber` = '13920' ,`StreetSuffix` = 'Lane' ,`City` = 'Pearland' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2635' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This is a Gorgeous home built Perry Homes. The home is all brick and very open concept with tons of storage. Nice study with double glass doors. Wide entry hallway with wall space for painting and or photos. 4 bedrooms with large walk closets. Open DR with tons of natural lighting. granite island kitchen w/ SS appliances, open to LR. Spacious Primary Bedroom with high Ceiling and faux wood blinds throughout home. Primary Bathroom has double sinks, shower with separate tub. Huge walk-in closet with built-ins- Yard has Irrigation system, backyard has extended covered patio with ceiling fans. \r\n2 car garage with epoxy coated floors. Home shows beautifully!' ,`Acres` = '0.1989' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'SHADOW CREEK RANCH SF-56 REPLAT NO 1, BLOCK 1, LOT 31' ,`LotDesciption` = 'Corner' ,`LotSize` = '8665' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop,Gas Range' ,`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,Call Occupant,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Split Level,Traditional' ,`Subdivision` = 'Shadow Creek Ranch Sf-56 Rep 1' ,`TaxAmount` = '9220' ,`TaxRate` = '3.2123' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667145733' WHERE `Matrix_Unique_ID` = '213293118' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T09:10:05.407' ,`MLSNumber` = '65223318' ,`ListAgentFullName` = 'Monica Rodriguez' ,`ListOfficeName` = 'City Brix Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.792153' ,`Longitude` = '-95.163908' ,`PhotoCount` = '38' ,`PostalCode` = '77015' ,`RoomCount` = '4' ,`ListPrice` = '299000.00' ,`Status` = 'Active' ,`StreetName` = 'Wadebridge' ,`StreetNumber` = '14530' ,`StreetSuffix` = 'Way' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2370' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come see this beautifully renovated home in Woodforest Subdivision. It will not disappoint! Located on a large oversized corner lot! 4 bedroom, 3 bath home with tons of wonderful features that will WOW you from the moment you walk thru the door. This home is spacious with a modern flare! Move in ready! Primary bedroom is oversized and secluded from additional bedrooms. Attached 2 car garage! Newly installed patio deck, perfect for this fall weather. Take a look at the gorgeous vaulted ceiling through out the living room and fabulous bar to entertain your guests! Excellent location, within walking distance of Elementary & Middle School. Shopping, dinning, & entertainment all nearby. LOW tax rate/HOA fee. Make an appointment to view today!' ,`Acres` = '0.1928' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 18 BLK 19 WOODFOREST SEC 15' ,`LotDesciption` = 'Corner' ,`LotSize` = '8400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '21 - Galena Park' ,`SchoolElementary` = 'NORTH SHORE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTH SHORE SENIOR HIGH SCHOOL' ,`SchoolMiddle` = 'NORTH SHORE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Left Side,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodforest Sec15 Reserve E' ,`TaxAmount` = '5341' ,`TaxRate` = '2.5294' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1976' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667145734' WHERE `Matrix_Unique_ID` = '213389035' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T09:53:30.890' ,`MLSNumber` = '11628662' ,`ListAgentFullName` = 'Laura Bolieu' ,`ListOfficeName` = 'Keller Williams Elite' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.646202' ,`Longitude` = '-95.119125' ,`PhotoCount` = '45' ,`PostalCode` = '77505' ,`RoomCount` = '12' ,`ListPrice` = '400000.00' ,`Status` = 'Active' ,`StreetName` = 'Rainbow Bend' ,`StreetNumber` = '7715' ,`StreetSuffix` = 'Drive' ,`City` = 'Pasadena' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2731' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this beautiful 4 bedroom 2.5 bath home located in sought after Village Grove East subdivision. 3 car detached garage nestled on a cul-de-sac. Primary suite downstairs w/double sinks and storage in the primary bath. Grand foyer,Open concept living w/high vaulted ceilings, formal dining oversized flex space situated on an oversized lot.in Deer Park ISD. Community pool and parks. Walking trails nearby and close to shopping, dining and Bltwy 8 for commute.' ,`Acres` = '0.281' ,`Area` = '6' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pasadena' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 3 BLK 3 VILLAGE GROVE EAST SEC 2' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '12240' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '16 - Deer Park' ,`SchoolElementary` = 'JP DABBS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DEER PARK HIGH SCHOOL' ,`SchoolMiddle` = 'FAIRMONT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Village Grove East' ,`TaxAmount` = '8038' ,`TaxRate` = '2.8798' ,`WaterSewer` = 'Public Water,Water District' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667145734' WHERE `Matrix_Unique_ID` = '213430271' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T08:26:36.087' ,`MLSNumber` = '12397451' ,`ListAgentFullName` = 'Fadimata Diallo' ,`ListOfficeName` = 'Coldwell Banker RealtyREALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.044178' ,`Longitude` = '-95.468651' ,`PhotoCount` = '36' ,`PostalCode` = '77388' ,`RoomCount` = '12' ,`ListPrice` = '462500.00' ,`Status` = 'Active' ,`StreetName` = 'Big Cypress' ,`StreetNumber` = '18715' ,`StreetSuffix` = '' ,`City` = 'Spring' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3170' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This STUNNING 4 bed 3.5 bath home that has been COMPLETELY REMODELED is the find of a lifetime! Walk in and you\'re greeted by an elegant formal dining room great for dinner parties and family gatherings. Opposite the dining room are a formal living and family room with an open concept floorplan, BRAND NEW engineered wood flooring, a fireplace with brick surround, and plenty of natural lighting. The absolutely gorgeous kitchen is equipped with NEW quartz countertops, an extra-large island with a built-in cooktop, plus a new dishwasher, oven, cooktop and microwave. All new carpet, doors and paint in the home. Huge 1st floor owners retreat with a luxurious bathroom showcasing a custom tiled walk-in shower and an expanded closet. All bathrooms have new cabinets, countertops, flooring and wall tile. 2nd floor has a large game room, a guest suite, and 2 more bedrooms! Backyard features \r\nprofessional landscaping and a large covered patio great for outdoor entertaining. Must see to believe!!!' ,`Acres` = '0.22' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 11 BLK 3 Thicket at Cypresswood' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '703' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'HAUDE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN COLLINS HIGH SCHOOL' ,`SchoolMiddle` = 'STRACK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Thicket At Cypresswood' ,`TaxAmount` = '7726' ,`TaxRate` = '2.6273' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1994' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667145734' WHERE `Matrix_Unique_ID` = '213518582' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T08:53:16.753' ,`MLSNumber` = '30092823' ,`ListAgentFullName` = 'Brooke Wier' ,`ListOfficeName` = 'Van Slyke Real Estate, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.750682' ,`Longitude` = '-95.599298' ,`PhotoCount` = '29' ,`PostalCode` = '77077' ,`RoomCount` = '8' ,`ListPrice` = '409500.00' ,`Status` = 'Active' ,`StreetName` = 'Attlee' ,`StreetNumber` = '12322' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2056' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**BACK ON THE MARKET** Beautifully updated and immaculately kept home with a pool in the Energy Corridor! You can tell a designer got a hold of this home...such great detail! Fresh paint inside & out - ALL painted, Kitchen has new range, hood & dishwasher, freshly painted cabinets, stainless appliances; the Primary Bathroom...dreamy...it feels like you\'ve stepped into a spa with a soaker tub, separate shower, double sinks, all new tile & butcherblock counters; home updated with copper wiring; new blinds throughout; new wood panel flooring; all new fixtures, chandeliers & fans throughout; all new duct work, ALL NEW!!! Great community pool is walking distance. Close to Terry Hershey Park with trails for biking/running. NEVER FLOODED DURING HARVEY.' ,`Acres` = '0.1818' ,`Area` = '31' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Energy Corridor' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 18 BLK 14 ASHFORD SOUTH SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7920' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ASHFORD/SHADOWBRIAR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'WEST BRIAR MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Ashford South Sec 02' ,`TaxAmount` = '6534' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667145734' WHERE `Matrix_Unique_ID` = '213543730' --> 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','213604581','1667145734','213604581','2022-10-30T08:09:41.923','88228345','Josalyn J. Cano','Keller Williams Realty - Memorial','','','29.712392','-95.584858','24','77072','12','315000.00','Active','Logan Ridge','11721','Drive','Houston','2','1','4','3261','Single-Family','Biggest home in the neighborhood! Victorian style facade. Private neighborhood. Income producing property for investors / buyer who doesn\'t need to immediately move in. HOA fee covers water bill, trash pickup 2x a week, and grounds maintenance- neighborhood streets are private- not city. Next to very popular Arthur Storey Park and Chinatown! Endless options for dining, coffee, shopping and community events. Easy commute to & from Westpark tollway and Beltway 8. Less than 20 mins to Houston Baptist University, 30 min to Texas Medical Center. Call today to schedule your showing appointment!','0.0932','28','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure,Tenant Occupied','1','Gas Connections','1','Alief','Central Electric','1','LT 10 BLK 1 HIGH STAR PLACE','Subdivision Lot','4058','Appraisal District','','1850','0','','2','Electric Oven,Single Oven','0','','','Electric Range','','Composition','2 - Alief','CHANCELLOR ELEMENTARY SCHOOL','AISD DRAW','ALIEF MIDDLE SCHOOL','Appointment Required,Lockbox Left Side,Request Online Appointment,Supra Keybox','Appraisal District','2','Victorian','High Star Place','5803','2.4411','Public Water','2005','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T09:22:01.313' ,`MLSNumber` = '11037475' ,`ListAgentFullName` = 'Becky Evans' ,`ListOfficeName` = 'RE/MAX Integrity' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.943834' ,`Longitude` = '-95.206912' ,`PhotoCount` = '40' ,`PostalCode` = '77346' ,`RoomCount` = '9' ,`ListPrice` = '345000.00' ,`Status` = 'Active' ,`StreetName` = 'Cambus Bend' ,`StreetNumber` = '12103' ,`StreetSuffix` = 'Drive' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2094' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful one story home on a corner lot with NO BACK NEIGHBORS!!! FOUR SIDES BRICK!!! Large open kitchen to prepare all your gourmet meals. Home boasts a spacious covered patio and expansive backyard to make many memories with your friends and loved ones. BACKYARD IS LARGE ENOUGH FOR A POOL!!! Primary bath has DOUBLE SINKS!!! Home is MOVE-IN READY including washer, dryer, and refrigerator. \r\n\r\nJust minutes from the BW, and located in the Master-Planned community of Balmoral that is home to amenities like the Crystal Clear Lagoon, Sand Beach, Cabanas, Swimming Pool, Tennis Court, Basketball Court, Playgrounds, Green-belt Paths, Splash Pad and More! Come visit your new home today! \r\n\r\n***All room measurements are approximate. ***Verify Schools Independently.' ,`Acres` = '0.1508' ,`Area` = '1' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Summerwood/Lakeshore' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1 BLK 1 BALMORAL SEC 16' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '6568' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1150' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'RIDGE CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'AUTUMN RIDGE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Balmoral' ,`TaxAmount` = '7402' ,`TaxRate` = '2.9873' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667145734' WHERE `Matrix_Unique_ID` = '213638644' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T09:44:06.410' ,`MLSNumber` = '29347426' ,`ListAgentFullName` = 'Isela Truong' ,`ListOfficeName` = 'Terramont Realty Partners' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.368054' ,`Longitude` = '-95.608529' ,`PhotoCount` = '45' ,`PostalCode` = '77356' ,`RoomCount` = '7' ,`ListPrice` = '420000.00' ,`Status` = 'Active' ,`StreetName` = 'Springs Edge' ,`StreetNumber` = '266' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2448' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stately home sits on a corner, cul-de-sac lot with views of the golf course. Roof is only 6 years old and the home comes with a whole house Generac Generator! Recently updated with New Quartz countertops, backsplash, stove with wifi, pop up exhaust vent, stainless steel sink, fresh paint and carpet, all new faucets and LED lighting. Simply Charming home, light and bright, located on one of the nicest streets in April Sound. Pride of ownership shows in all the surrounding homes. Covered balcony off the primary bedroom with stairs to access the patio below. Kitchen boasts a double bar for additional seating on both ends. Owner is offering $500 towards a home warranty of your choice. Schedule your tour today!' ,`Acres` = '0.3036' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'APRIL SOUND 01, BLOCK 5, LOT 51' ,`LotDesciption` = 'Corner,Cul-De-Sac,In Golf Course Community,On Golf Course,Subdivision Lot,Wooded' ,`LotSize` = '13223' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '234' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'STEWART CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAKE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'OAK HILL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'April Sound 01' ,`TaxAmount` = '5587' ,`TaxRate` = '2.2525' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1984' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667145735' WHERE `Matrix_Unique_ID` = '213668641' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T08:46:08.460' ,`MLSNumber` = '48755142' ,`ListAgentFullName` = 'LaShelle Larson' ,`ListOfficeName` = 'CB&A, Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.084079' ,`Longitude` = '-95.775764' ,`PhotoCount` = '25' ,`PostalCode` = '77447' ,`RoomCount` = '9' ,`ListPrice` = '285000.00' ,`Status` = 'Active' ,`StreetName` = 'Cloverland Field' ,`StreetNumber` = '22522' ,`StreetSuffix` = 'Drive' ,`City` = 'Hockley' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1937' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This Pecos Plan by LGI Homes boasts 4 bedrooms, 2 bathrooms, large walk in closets, and chef ready kitchen complete with granite counters. From the incredible entrance to the awesome park, Bauer Landing is a wonderful place to call home. This community also includes walking trails and with its close proximity to the new Grand Parkway traveling anywhere in the city is a breeze! Low taxes and HOA! Schedule your showing today, this one won\'t last long.' ,`Acres` = '0.1222' ,`Area` = '35' ,`BuilderName` = 'LGI Homes' ,`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 18 BLK 5 BAUER LANDING SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5325' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '475' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'EVELYN TURLINGTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'SCHULTZ JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Bauer Landing' ,`TaxAmount` = '6407' ,`TaxRate` = '2.8556' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667145735' WHERE `Matrix_Unique_ID` = '213728444' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T08:25:16.340' ,`MLSNumber` = '61238866' ,`ListAgentFullName` = 'Salvador Caballero' ,`ListOfficeName` = 'ListWithFreedom.com' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.209427' ,`Longitude` = '-95.586106' ,`PhotoCount` = '25' ,`PostalCode` = '77354' ,`RoomCount` = '8' ,`ListPrice` = '565000.00' ,`Status` = 'Active' ,`StreetName` = 'Miller' ,`StreetNumber` = '9019' ,`StreetSuffix` = 'Road' ,`City` = 'Magnolia' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3489' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'LOCATION, LOCATION, LOCATION! MINUTES to the Woodlands on an acreage retreat! Private, yet convenient. Dont miss the opportunity to see this beautiful home on almost 2 acres! Lovely touches throughout include arched doorways, a 2-story foyer with a grand staircase, formal dining, home office with french double doors, and a 2-car garage PLUS room for covered parking. The kitchen features a large island with seating and lots of room to entertain as well as wooded forest views from the bright and airy breakfast room. Retreat to the downstairs primary bedroom with tray ceiling and en-suite bath showcasing dual vanities and an extra-large walk-in closet! Upstairs game room has room for everyone and a built-in desk for study time. Three more bedrooms up including two that share a jack and jill bath. Dont miss the backyard with a spacious covered patio and 1.78 heavily treed acres for a forest-like feel and room for a pool! Close to shopping, dining, and schools.' ,`Acres` = '1.781' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'MILLERS CROSSING 01, BLOCK 2, LOT 57' ,`LotDesciption` = 'Cleared,Wooded' ,`LotSize` = '77580' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'TOM R. ELLISOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Millers Crossing 01' ,`TaxAmount` = '9295' ,`TaxRate` = '1.8587' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1667145735' WHERE `Matrix_Unique_ID` = '213733200' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T09:50:26.267' ,`MLSNumber` = '89354415' ,`ListAgentFullName` = 'Jennifer Meier' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = 'Anne Buckmaster' ,`SellingOfficeName` = 'RE/MAX Space Center-Clear Lake' ,`Latitude` = '29.331758' ,`Longitude` = '-95.088356' ,`PhotoCount` = '33' ,`PostalCode` = '77510' ,`RoomCount` = '9' ,`ListPrice` = '547000.00' ,`Status` = 'Option Pending' ,`StreetName` = '33rd' ,`StreetNumber` = '12515' ,`StreetSuffix` = 'Street' ,`City` = 'Santa Fe' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1624' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'OPEN HOUSE October 22, Saturday 1-2:30PM!!! Come see it for yourself! Welcome to nearly 5 ACRES of country living at 12515 33rd Street! This immaculate property features a 2 bed, 2 bath home with a PORCH around two sides, a 60\' X 36\' BARN, a 32\' X 28\' detached garage, RV PARKING with hookups, a chicken coop, a PEACH ORCHARD, a grafted PECAN and a POND stocked with bluegills. Zoned to Santa Fe ISD. Cross-fenced. 2 water heaters. 2 water wells. 2 AC units. Country living just close enough to shopping, dining out, trips to Galveston, and fishing in the nearby bay, bayous, and canals. What are you waiting for? Call today for an appointment to see this beautiful spread!' ,`Acres` = '4.905' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Stove' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Santa Fe' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 47 L CRAWFORD SUR PT OF OUTLOT 251 (251-5) ALTA LOMA OU' ,`LotDesciption` = 'Cleared,Corner' ,`LotSize` = '213662' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '45 - Santa Fe' ,`SchoolElementary` = 'DAN J KUBACAK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SANTA FE HIGH SCHOOL' ,`SchoolMiddle` = 'SANTA FE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Alta Loma Outlots' ,`TaxAmount` = '4229' ,`TaxRate` = '2.0881' ,`WaterSewer` = 'Aerobic,Septic Tank,Well' ,`YearBuilt` = '1977' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667145735' WHERE `Matrix_Unique_ID` = '213744052' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T08:23:17.903' ,`MLSNumber` = '7750942' ,`ListAgentFullName` = 'Kandace Graves' ,`ListOfficeName` = 'Encore Feature Properties, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.753741' ,`Longitude` = '-94.955757' ,`PhotoCount` = '6' ,`PostalCode` = '77521' ,`RoomCount` = '3' ,`ListPrice` = '143000.00' ,`Status` = 'Active' ,`StreetName` = 'Kettering' ,`StreetNumber` = '2808' ,`StreetSuffix` = 'Drive' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1696' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Investors, this one is for you! Don\'t miss out on your chance to turn this home into your next great investment. This property is on a quiet street in the heart of Baytown and has a lot of potential. Perfect home for a flip or rental investment. This home needs improvement and is priced accordingly. Being sold as-is. Property has never flooded!' ,`Acres` = '0.245' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 174 BLK 10 FAIR PARK SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10671' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'JAMES BOWIE ELEMENTARY SCHOOL (GOOSE CREEK)' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (GOOSE CREEK)' ,`SchoolMiddle` = 'CEDAR BAYOU J H' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Fair Park' ,`TaxAmount` = '4190' ,`TaxRate` = '2.97' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1965' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667145736' WHERE `Matrix_Unique_ID` = '213754497' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T09:05:19.557' ,`MLSNumber` = '67183483' ,`ListAgentFullName` = 'Marlena Wyckoff' ,`ListOfficeName` = 'Clearstone Realty' ,`SellingAgentFullName` = 'Marlena Wyckoff' ,`SellingOfficeName` = 'Clearstone Realty' ,`Latitude` = '29.691355' ,`Longitude` = '-95.537633' ,`PhotoCount` = '12' ,`PostalCode` = '77036' ,`RoomCount` = '6' ,`ListPrice` = '225000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'La Roche Lane' ,`StreetNumber` = '7915' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1700' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'HURRY, This best buy will not last long! Great floor plan with 3/2/2. A/C was replaced in 2019, new composition roof in 2016 and exterior painted May 2022. All 4 sides brick. Spacious kitchen with lots of counter space. Large breakfast area. Family huge family room. Front room can be used for formal dining, formal living, office space, or a game room the options are endless! Primary bedroom has his and her closets . Huge and beautiful back yard. Plenty of room for a pool. Premium location with easy access to I59 and Beltway 8. This home just needs some TLC. Be in your new home for the holidays !' ,`Acres` = '0.1845' ,`Area` = '21' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sharpstown Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'TRS 3A & 4 BLK 51 SHARPSTOWN COUNTRY CLUB TERRACE SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8035' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WHITE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SHARPSTOWN HIGH SCHOOL' ,`SchoolMiddle` = 'SUGAR GROVE MIDDLE SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sharpstown Country Club Terrac' ,`TaxAmount` = '4723' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1967' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667145736' WHERE `Matrix_Unique_ID` = '213754981' --> 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','213765141','1667145736','213765141','2022-10-30T08:20:37.180','85845383','Adriana Evans','TWG Realty','','','29.946333','-95.129679','24','77532','3','289000.00','Active','Deep Anchor','2827','Way','Crosby','2','0','3','1795','Single-Family','Beautiful 3/2 home on a corner lot located in shadow lake subdivision in Crosby near Lake Houston. Community offers amenities such as boat ramp, pool, playground and a tennis court. Home offers you an open concept with high ceilings allowing you plenty of space to entertain friends and family, as well plenty of space in the back yard to enjoy your morning coffee. Call for your private showing!','0.1928','1','','','','','Owner/Agent,Sellers Disclosure','','','1','Crosby Area','Central Electric','1','LT 1 BLK 6 LAKE SHADOWS SEC 5','Corner,Subdivision Lot','8400','Appraisal District','','127','0','','2','','0','','','','','Composition','12 - Crosby','NEWPORT ELEMENTARY SCHOOL','CROSBY HIGH SCHOOL','CROSBY MIDDLE SCHOOL (CROSBY)','Accompany,Appointment Required,Supra Keybox','Appraisal District','1','Traditional','Lake Shadows','','','Public Sewer,Public Water','1993','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T08:29:41.940' ,`MLSNumber` = '79939286' ,`ListAgentFullName` = 'Lisa Trom' ,`ListOfficeName` = 'Zarco Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.696479' ,`Longitude` = '-95.668025' ,`PhotoCount` = '20' ,`PostalCode` = '77083' ,`RoomCount` = '9' ,`ListPrice` = '220000.00' ,`Status` = 'Active' ,`StreetName` = 'Sierra Grande' ,`StreetNumber` = '16007' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1762' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'One-story 3-2-2 is located in the well-established neighborhood minutes from Hwy 6, Westpark Tollway, and the Grand Parkway. (per the Appraisal Tax office this home is 3/2 but you will see a 4th bedroom/office off the kitchen area). \r\nCharming clean home with great bones, tiled flooring throughout, and the covered patio off the large backyard is great for entertaining. Roof 10 mths old, new backyard fencing. Near restaurants, grocery, and shopping. Ready for updates/upgrades to make it your own price to reflect those needs.' ,`Acres` = '0.1742' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Mission Bend Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'MISSION BEND SEC 4, BLOCK 50, LOT 9' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7586' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '220' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'MISSION BEND ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BUSH HIGH SCHOOL' ,`SchoolMiddle` = 'HODGES BEND MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Mission Bend' ,`TaxAmount` = '3582' ,`TaxRate` = '2.0847' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667145736' WHERE `Matrix_Unique_ID` = '213768022' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T09:33:52.777' ,`MLSNumber` = '82786496' ,`ListAgentFullName` = 'Amy Bernstein' ,`ListOfficeName` = 'Bernstein Realty, Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.710295' ,`Longitude` = '-95.409142' ,`PhotoCount` = '35' ,`PostalCode` = '77030' ,`RoomCount` = '6' ,`ListPrice` = '1150000.00' ,`Status` = 'Active' ,`StreetName` = 'Goldsmith' ,`StreetNumber` = '2112' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2039' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully picturesque 3 bedroom, 2 bath updated BRICK home in the sought-after neighborhood of Southgate! Lavish landscaping and mature trees enhance this 7,300 sq ft lot, per HCAD. The home is bright & airy as natural light flourishes with large windows in each room and plantation shutters. The living area features a ventless gaslog fireplace, gorgeous hardwood floors and French doors opening onto the covered patio. Graceful formal dining room with wainscoting has a wood wine bar area tucked conveniently nearby. Kitchen is stylishly updated with quartz counters, farm sink, stainless appliances and a glass tile backsplash. 1st floor bedroom features white paneling and a chic accent wall. Primary and secondary bedroom upstairs are both filled with light and features built-in closet systems. Fantastic backyard features a covered patio, built in grill area, large greenspace and mature shade tree. A 2-car detached garage wired for EV charging station also has a large workshop attached.' ,`Acres` = '' ,`Area` = '17' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Rice/Museum District' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TRS 9 & 10A BLK 18 SOUTHGATE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7300' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ROBERTS ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Southgate' ,`TaxAmount` = '18369' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1948' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667145736' WHERE `Matrix_Unique_ID` = '213790673' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T08:22:01.280' ,`MLSNumber` = '47948766' ,`ListAgentFullName` = 'Stacey Fuentes Nelson' ,`ListOfficeName` = 'Coldwell Banker RealtyREALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.044671' ,`Longitude` = '-95.585065' ,`PhotoCount` = '24' ,`PostalCode` = '77375' ,`RoomCount` = '6' ,`ListPrice` = '235000.00' ,`Status` = 'Active' ,`StreetName` = 'Bold River' ,`StreetNumber` = '19346' ,`StreetSuffix` = 'Road' ,`City` = 'Tomball' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1403' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to your new home! This adorable 3 bedroom 2 bath home with recent exterior paint brings it even more warmth to its new owners. Split floor plan with tile flooring throughout the home makes this a must see. Spacious kitchen with beautiful countertops, deep kitchen sink, tile backsplash with upgraded appliances. This would please any cook in the family. Opens up to the living room so you always feel part of the conversation. This home comes complete with wifi swiches to make life easier. Two hallway closets for storage that is always needed. Relax in the garden tub on those long days. Finish your day or start your day with your favorite beverage on this oversized lot with a big backyard.' ,`Acres` = '0.1407' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring/Klein/Tomball' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1 BLK 2 NORTHERN POINT SEC 4' ,`LotDesciption` = 'Corner' ,`LotSize` = '6129' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'KOHRVILLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN CAIN HIGH SCHOOL' ,`SchoolMiddle` = 'ULRICH INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Northern Point Sec 04' ,`TaxAmount` = '3885' ,`TaxRate` = '2.7066' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667145736' WHERE `Matrix_Unique_ID` = '213812025' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T08:38:33.710' ,`MLSNumber` = '77044923' ,`ListAgentFullName` = 'Seema Pirzada' ,`ListOfficeName` = 'PIRZADA VENTURES LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.653418' ,`Longitude` = '-95.695623' ,`PhotoCount` = '31' ,`PostalCode` = '77407' ,`RoomCount` = '9' ,`ListPrice` = '669999.00' ,`Status` = 'Active' ,`StreetName` = 'Fermill' ,`StreetNumber` = '11119' ,`StreetSuffix` = 'Court' ,`City` = 'Richmond' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3182' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'GORGEOUS STUCCO SHOWSTOPPER IN ALIANA THATS BETTER THAN NEW! AMAZING ONE AND A HALF STORY HOME LOCATED IN QUIET QUL-DE-SAC THAT\'S CONVENIENTLY LOCATED ACROSS THE STREET FROM MADDEN ELEMENTARY! TONS OF UPGRADES! BEAUTIFUL FRONT ELEVATION, HIGH CEILINGS AND FORMAL DINING WELCOME YOU HOME. CHEF INSPIRED KITCHEN W/ GRANITE COUNTERTOPS, SS APPLIANCES & HUGE ISLAND OPENS UP INTO LIVING ROOM WITH HIGH CEILINGS AND GORGEOUS STONE FIREPLACE. THIS FLOOR PLAN IS GREAT FOR ENTERTAINING! HUGE MASTER RETREAT W/ SPA LIKE BATH! 4 BEDROOMS LOCATED DOWNSTAIRS, SECOND FLOOR WITH GAME ROOM, LARGE BEDROOM AND FULL BATHROOM. TONS OF STORAGE SPACE! COVERED PATIO AND PRIVATE BACKYARD. ZONED TO GREAT SCHOOLS! EASY ACCESS TO 6, 59, 90, 99, I10, & WESTPARK TOLLWAY! PRICED TO SELL!' ,`Acres` = '0.1604' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land West' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'ALIANA SEC 11, BLOCK 1, LOT 26' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '6988' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1137' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'MADDEN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TRAVIS HIGH SCHOOL (FORT BEND)' ,`SchoolMiddle` = 'GARCIA MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Aliana Sec 11' ,`TaxAmount` = '11901' ,`TaxRate` = '2.9329' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667145737' WHERE `Matrix_Unique_ID` = '213817061' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T08:54:10.667' ,`MLSNumber` = '82914810' ,`ListAgentFullName` = 'Elena Garcia' ,`ListOfficeName` = 'Penny Salter Properties' ,`SellingAgentFullName` = 'Shelly Porter' ,`SellingOfficeName` = 'Compass RE Texas, LLC' ,`Latitude` = '29.807533' ,`Longitude` = '-95.427360' ,`PhotoCount` = '29' ,`PostalCode` = '77008' ,`RoomCount` = '7' ,`ListPrice` = '589900.00' ,`Status` = 'Option Pending' ,`StreetName` = '24th' ,`StreetNumber` = '1532' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2071' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning, Immaculate New Orleans style home with modern flair located in Greater Heights! Inviting open living/dining room with high ceilings, gleaming hardwood floors and lots of windows. Gorgeous kitchen has Calacatta gold porcelain countertops, new Jenn Air appliances, walk-in pantry, kitchen island with seating and wine fridge. The family room off the kitchen has a fireplace and double doors that lead into an extended back patio with gazebo—perfect for entertaining. This home has lush, picturesque front and backyard with sprinkler system. The backyard is large enough for gardening, pool or a play area for kids. The primary suite has a fireplace and door that leads to a balcony. Fantastic location with walking distance to numerous restaurants, parks and bars. Close to Heights HEB and very easy access to 610 Loop. This one has it all!' ,`Acres` = '0.0905' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'TR 8A BLK 1 GEORGETOWN MANOR' ,`LotDesciption` = 'Other' ,`LotSize` = '3943' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SINCLAIR ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Heights' ,`TaxAmount` = '9437' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667145737' WHERE `Matrix_Unique_ID` = '213827367' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T08:55:31.130' ,`MLSNumber` = '91775315' ,`ListAgentFullName` = 'Keeyan Sabz' ,`ListOfficeName` = 'Intero Real Estate Services' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.778075' ,`Longitude` = '-95.324688' ,`PhotoCount` = '16' ,`PostalCode` = '77020' ,`RoomCount` = '5' ,`ListPrice` = '335000.00' ,`Status` = 'Active' ,`StreetName` = 'Dan' ,`StreetNumber` = '1850' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1581' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 1850 Dan St sought-after floorplan with must-have FIRST FLOOR LIVING, backyard for entertaining, flex space upstairs, a private driveway & NO HOA! This recently constructed (2017), award winning home built by Parra Design Group features 3 bedrooms, 2.5 baths, plenty of natural light, high ceilings & tile/hardwood floors throughout (no carpet). The Kitchen has an oversized island with Quartz countertops, stainless steel appliances, and plenty of storage. This open concept floorplan allows you not to miss a second of action when entertaining - extend the entertaining outdoors under your private covered back patio! Upon arrival at the second floor is the flex loft space separating the Primary Bedroom from the secondary bedrooms - this space is perfect for an office area, workout equipment, reading nook or gameroom. Call 1850 Dan yours for that \"1st Floor Lifestyle.\" Washer/Dryer/Fridge STAY. Never flooded.' ,`Acres` = '0.0546' ,`Area` = '2' ,`BuilderName` = 'Parra Design Group' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Denver Harbor' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 2 BLK 1 LYONS REDEV EIGHTEENTH VENTURE' ,`LotDesciption` = 'Patio Lot,Subdivision Lot' ,`LotSize` = '2377' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ATHERTON ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WHEATLEY HIGH SCHOOL' ,`SchoolMiddle` = 'FLEMING MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Other Style,Traditional' ,`Subdivision` = 'Fifth Ward' ,`TaxAmount` = '6452' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667145737' WHERE `Matrix_Unique_ID` = '213829487' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T09:46:03.363' ,`MLSNumber` = '68898923' ,`ListAgentFullName` = 'Beverly Bradley' ,`ListOfficeName` = 'Weekley Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.278701' ,`Longitude` = '-95.567934' ,`PhotoCount` = '31' ,`PostalCode` = '77316' ,`RoomCount` = '8' ,`ListPrice` = '539000.00' ,`Status` = 'Active' ,`StreetName` = 'Bromley Square' ,`StreetNumber` = '312' ,`StreetSuffix` = 'Drive' ,`City` = 'Montgomery' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2649' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Elegance and sophistication combine with the genuine comforts that make each day delightful in this impressive new home in Woodforest – Kingsley Square! The study offers an opportunity to create that work from home office, craft room, or music studio you’ve been dreaming about. With a ceiling that rises to the second floor, the dining room makes a dynamic impression on guests. The kitchen includes a high capacity corner pantry. The spacious laundry room includes a convenient countertop. The master bathroom features a double sink vanity and an expansive walk in closet. Both upstairs bedrooms include their own walk in closets.' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'David Weekley Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan,Mud,No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 8 Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1500' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'LONE STAR ELEMENTARY SCHOOL (MONTGOMERY)' ,`SchoolHigh` = 'LAKE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'OAK HILL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Woodforest - Kingsley Square' ,`TaxAmount` = '' ,`TaxRate` = '2.793' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667145737' WHERE `Matrix_Unique_ID` = '213855514' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T09:22:01.313' ,`MLSNumber` = '84868790' ,`ListAgentFullName` = 'Azalea Marquez' ,`ListOfficeName` = 'Texas Premier Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.921846' ,`Longitude` = '-95.579421' ,`PhotoCount` = '22' ,`PostalCode` = '77064' ,`RoomCount` = '8' ,`ListPrice` = '255900.00' ,`Status` = 'Active' ,`StreetName` = 'Autumn Meadow' ,`StreetNumber` = '10227' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1838' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful two story in White Oak Bend! 3 bedroom 2 full bath. Well kept and clean. Pretty flooring thru-out. Two living areas and high ceilings. Fireplace for cozy cooler weather. Covered patio for a patio table to enjoy the falling leaves. Must see.' ,`Acres` = '0.1446' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Willowbrook South' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 29 BLK 2 WHITE OAK BEND SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6300' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '320' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'BANG ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'CAMPBELL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'White Oak Bend Sec 01' ,`TaxAmount` = '5371' ,`TaxRate` = '2.84' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1981' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667145737' WHERE `Matrix_Unique_ID` = '213858115' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T08:09:31.690' ,`MLSNumber` = '9613741' ,`ListAgentFullName` = 'Janet Schmidt' ,`ListOfficeName` = 'Berkshire Hathaway HomeServices Premier Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.797021' ,`Longitude` = '-95.432427' ,`PhotoCount` = '31' ,`PostalCode` = '77008' ,`RoomCount` = '10' ,`ListPrice` = '575000.00' ,`Status` = 'Active' ,`StreetName` = 'Kury' ,`StreetNumber` = '6543' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2067' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.2124' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Timbergrove/Lazybrook' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 28 BLK 2 TIMBERGROVE MANOR SEC 12' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SINCLAIR ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'BLACK MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Timbergrove Manor' ,`TaxAmount` = '10827' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1964' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667145738' WHERE `Matrix_Unique_ID` = '213864364' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T09:10:25.920' ,`MLSNumber` = '14589731' ,`ListAgentFullName` = 'Linda Harris' ,`ListOfficeName` = 'Keller Williams RealtyNortheast' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.826682' ,`Longitude` = '-95.503120' ,`PhotoCount` = '32' ,`PostalCode` = '77080' ,`RoomCount` = '9' ,`ListPrice` = '298600.00' ,`Status` = 'Active' ,`StreetName` = 'Rannie' ,`StreetNumber` = '8601' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1829' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautifully updated four bedroom located in Spring Branch has been recently updated and MOVE-IN READY! Refinished hardwood oak floors throughout 3 of the bedrooms and family room. New vinyl plank throughout the kitchen, utility room and den. The primary bedroom has new carpet. There is a completely fenced spacious back yard with 4 mature pecan trees. Conveniently located close to major highways for an easy commute! This amazing central location is just minutes from Houston\'s top restaurants, shopping, parks and much more! NO FLOODING. ****COMMERCIAL/ RESIDENTIAL LOT @ 60 X 200****' ,`Acres` = '' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 64 BLK 4' ,`LotDesciption` = 'Corner' ,`LotSize` = '11940' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'EDGEWOOD ELEMENTARY SCHOOL (SPRING BRANCH)' ,`SchoolHigh` = 'NORTHBROOK HIGH SCHOOL' ,`SchoolMiddle` = 'NORTHBROOK MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Wilson Court' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667145738' WHERE `Matrix_Unique_ID` = '213868443' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T09:10:22.270' ,`MLSNumber` = '81543746' ,`ListAgentFullName` = 'Ray Hunt' ,`ListOfficeName` = 'Offerpad Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.249018' ,`Longitude` = '-95.526175' ,`PhotoCount` = '47' ,`PostalCode` = '77384' ,`RoomCount` = '4' ,`ListPrice` = '419900.00' ,`Status` = 'Active' ,`StreetName` = 'Aspen Valley' ,`StreetNumber` = '14284' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2902' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful home in Fosters Ridge zoned to The Woodlands schools! This spacious ONE story with a game room and three car garage is complete and ready for you! Four bedrooms, three and a half bathrooms on an oversized homesite! Upgraded cream finish on cabinets, hardwood flooring throughout living areas and granite countertops in huge island kitchen are just a few of the upgrades in this home. Covered back patio, sprinkler system,16 SEER Carrier unit, tankless water heater, double paned-windows will keep you warm this winter and cool in the summer! Call for an appointment today!' ,`Acres` = '0.2277' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S516407 - FOSTERS RIDGE 07, BLOCK 1, LOT 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9917' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '850' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'BUSH ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'THE WOODLANDS HIGH SCHOOL' ,`SchoolMiddle` = 'MCCULLOUGH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Fosters Ridge 07' ,`TaxAmount` = '11453' ,`TaxRate` = '3.1488' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667145738' WHERE `Matrix_Unique_ID` = '213873734' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T08:38:43.363' ,`MLSNumber` = '88831428' ,`ListAgentFullName` = 'Monica Burca' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.062155' ,`Longitude` = '-95.214416' ,`PhotoCount` = '14' ,`PostalCode` = '77339' ,`RoomCount` = '7' ,`ListPrice` = '225000.00' ,`Status` = 'Active' ,`StreetName` = 'Silver Falls' ,`StreetNumber` = '2111' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2004' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great home in quiet and safe North Woodland Hills Subdivision. Acclaimed Kingwood schools, this house is within walking distance to tree schools : Woodland Hills Elementary, Kingwood Middle School and KPark High school. \r\nThe house features an open floor plan, high vaulted ceiling in family room, 4 bedrooms and 2 bathrooms, good size backyard on a quiet cul-de-sac street. All of this offered at a great price. \r\nBring your family and make it your home!' ,`Acres` = '0.2231' ,`Area` = '32' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Kingwood West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 12 BLK 46 WOODLAND HILLS VILLAGE SEC 8' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9720' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'WOODLAND HILLS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KINGWOOD PARK HIGH SCHOOL' ,`SchoolMiddle` = 'KINGWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Back' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodland Hills Village Sec 08' ,`TaxAmount` = '4699' ,`TaxRate` = '2.5839' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1977' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667145738' WHERE `Matrix_Unique_ID` = '213917761' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T09:21:00.583' ,`MLSNumber` = '33036346' ,`ListAgentFullName` = 'Joshua Adkins' ,`ListOfficeName` = 'RE/MAX 5 Star Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.502309' ,`Longitude` = '-95.151495' ,`PhotoCount` = '43' ,`PostalCode` = '77546' ,`RoomCount` = '13' ,`ListPrice` = '530000.00' ,`Status` = 'Active' ,`StreetName` = 'Deer Valley' ,`StreetNumber` = '1102' ,`StreetSuffix` = 'Drive' ,`City` = 'Friendswood' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3593' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Christmas in your new home!\r\nThis home has 33 Solar Panels and an EV Charging Station in the 3-car tandem garage. It was built in 2015 and features 4 bedrooms and 3.5 bathrooms. All new carpet and paint throughout the house as of October 2022! Downstairs features an open concept with an oversized breakfast room, spacious kitchen/living room, and a beautiful fireplace. The are two chandeliers you\'ll fall in love with every time you come home. Upstairs has 3 bedrooms, media room, theatre room set up for surround sound, and a Jack and Jill bathroom. All rooms have RJ45 connections for the option to hard wire your internet. Besides the beautiful curb appeal outside, this home sits on a huge lot, no back neighbors, cul-de-sac, has an outdoor kitchen, carver stone patio/walkways, therapeutic swimming spa w/wood deck, a water fountain area to relax at, storage shed, greenhouse, and plenty of extra concrete space to mingle with friends/family. Lots of fruit trees - you\'ll never starve. Ever.' ,`Acres` = '0.3328' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas,Solar Assisted' ,`HOAMandatory` = '1' ,`Legal` = 'LT 41 BLK 1 AUTUMN LAKES SEC 5' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '14495' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'LANDOLT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR SPRINGS HIGH SCHOOL' ,`SchoolMiddle` = 'BROOKSIDE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Autumn Lakes' ,`TaxAmount` = '9102' ,`TaxRate` = '2.2316' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667145739' WHERE `Matrix_Unique_ID` = '213918096' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T08:49:04.630' ,`MLSNumber` = '74007070' ,`ListAgentFullName` = 'Earl Trammell' ,`ListOfficeName` = 'Coldwell Banker RealtyREALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.798798' ,`Longitude` = '-95.320987' ,`PhotoCount` = '36' ,`PostalCode` = '77026' ,`RoomCount` = '7' ,`ListPrice` = '325000.00' ,`Status` = 'Active' ,`StreetName` = 'Lavender' ,`StreetNumber` = '4201' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3244' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This is a must see property with Total 4/5 bedrooms. 2 Large bedrooms 1 Full and 1/2 baths in the Main House and a 2 Bedroom Apartment with a full bath and separate entry. The home also has an office that can be a Bedroom as well. The living area at the entrance is huge with plenty of space can be use as a Living Room, Family room and Dinning room Combo. Kitchen features a 3 Compartment Commercial sink with lots of cabinet space. Huge built in storage units on the back of the house. Additional Storage space throughout the house. Completely fence backyard perfect for out door entertainment. Call now this one will not last. Perfect for an investor, dual family living or use garage apartment as a rental.' ,`Acres` = '0.3444' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LT 317 BLK 18 KASHMERE GARDENS' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '15000' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ISAACS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WHEATLEY HIGH SCHOOL' ,`SchoolMiddle` = 'FLEMING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Kashmere Gardens' ,`TaxAmount` = '3342' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1940' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667145739' WHERE `Matrix_Unique_ID` = '213924325' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T08:09:36.870' ,`MLSNumber` = '11922592' ,`ListAgentFullName` = 'Cassandra Moss' ,`ListOfficeName` = 'MMW Realty Partners' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.633957' ,`Longitude` = '-95.469060' ,`PhotoCount` = '29' ,`PostalCode` = '77085' ,`RoomCount` = '3' ,`ListPrice` = '260000.00' ,`Status` = 'Active' ,`StreetName` = 'Tidewater' ,`StreetNumber` = '5726' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1590' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A must see! This home is a beautiful 2 story with wood and tile floors downstairs and carpet and tile upstairs. Clean open concept with lots of natural lighting. Kitchen opens to the family room making great space for entertainment. Upstairs game room, man cave or bonus room. Backyard has a beautiful covered patio great for family gatherings. This beautiful jewel wont last long, come and see for yourself.' ,`Acres` = '0.1033' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Five Corners' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 12 BLK 4 POST OAK PLACE SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '275' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HINES-CALDWELL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MADISON HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LAWSON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Post Oak Place Sec 02' ,`TaxAmount` = '3993' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667145739' WHERE `Matrix_Unique_ID` = '213942054' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T09:10:54.717' ,`MLSNumber` = '70277044' ,`ListAgentFullName` = 'Kelly Rickard' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.716522' ,`Longitude` = '-95.581899' ,`PhotoCount` = '48' ,`PostalCode` = '77082' ,`RoomCount` = '11' ,`ListPrice` = '1179000.00' ,`Status` = 'Active' ,`StreetName` = 'Montmarte' ,`StreetNumber` = '11606' ,`StreetSuffix` = 'Boulevard' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3610' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This stunning, modern, and updated 1-story GOLF COURSE home is appointed with the very best in finishes, fixtures, and amenities! Thermador, Dornbracht, walnut Benedettini, Alfresco grill, heated pool/spa by Paragon Pools, plantation shutters and marble floors throughout, electric shades on butted windows, pro-engineered house-wide, in-out a/v system, with recently upgraded surveillance system, large kitchen pantry, and large walk-in closet in primary. A/C unit replaced in 2021, fresh interior/exterior paint (including ceilings), all inside/outside doors painted, new sound, TV and light system in back pool area, upgraded garden light system with fresh landscaping (avocado and citrus trees). Relax and enjoy the gorgeous sunsets overlooking the golf course in the perfect resort environment. Large viewing windows are made of impact resistant glass. Move-in ready with so many upgrades! Ask agent for list of upgrades. 2 refrigerators, washer/dryer, and all TVs stay. Furniture is negotiable.' ,`Acres` = '0.2085' ,`Area` = '31' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Westchase Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 27 BLK 1 ROYAL OAKS COUNTRY CLUB SEC 14' ,`LotDesciption` = 'On Golf Course,Subdivision Lot' ,`LotSize` = '9084' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '3130' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '2 - Alief' ,`SchoolElementary` = 'OUTLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AISD DRAW' ,`SchoolMiddle` = 'O\'DONNELL MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Royal Oaks Country Club Sec 14' ,`TaxAmount` = '17191' ,`TaxRate` = '2.6086' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2011' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667145739' WHERE `Matrix_Unique_ID` = '213969191' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T08:34:41.083' ,`MLSNumber` = '12439343' ,`ListAgentFullName` = 'D\'Ann Fleming' ,`ListOfficeName` = 'RE/MAX 5 Star Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.694552' ,`Longitude` = '-95.117506' ,`PhotoCount` = '28' ,`PostalCode` = '77536' ,`RoomCount` = '8' ,`ListPrice` = '309000.00' ,`Status` = 'Active' ,`StreetName` = 'X' ,`StreetNumber` = '610' ,`StreetSuffix` = 'Street' ,`City` = 'Deer Park' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1976' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Home Sweet Home! Location, location, location, in the middle of Deer Park. Recent upgrades: granite, backsplash, paint and opening up the kitchen to living room. Double pane windows with plantation shutters and solar screens. French drains and sprinkler system on a separate water line. Outlet for generator as a bonus and ready when needed. Selling AS IS. Furniture could stay. Great backyard with covered patio for all your entertaining. Make your appointment for your showing today.' ,`Acres` = '0.2314' ,`Area` = '6' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Deer Park' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 334 DEER PARK GARDENS SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10080' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '16 - Deer Park' ,`SchoolElementary` = 'DEER PARK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DEER PARK HIGH SCHOOL' ,`SchoolMiddle` = 'DEER PARK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Deer Park Gardens Sec 05' ,`TaxAmount` = '5750' ,`TaxRate` = '2.8239' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1971' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667145739' WHERE `Matrix_Unique_ID` = '213993870' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T09:16:11.550' ,`MLSNumber` = '37670499' ,`ListAgentFullName` = 'Joshua Olsen' ,`ListOfficeName` = 'Berkshire Hathaway HomeServices Premier Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.553663' ,`Longitude` = '-95.518448' ,`PhotoCount` = '35' ,`PostalCode` = '77459' ,`RoomCount` = '11' ,`ListPrice` = '340000.00' ,`Status` = 'Active' ,`StreetName` = 'Champions Cove' ,`StreetNumber` = '3635' ,`StreetSuffix` = 'Lane' ,`City` = 'Missouri City' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2184' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This well maintained spacious 4 bed, 2.5 bath home sits quietly in a cul de sac with only 1 neighbor! Located in the heart of the Olympia Estates subdivision in Missouri City and Fort Bend ISD. You’ll find a massive open living layout with updated flooring and lighting. Roomy bedrooms with all closets offering ample added storage space. This home is nestled in a central location, with quick access to the Fort Bend Tollway and HWY 6.' ,`Acres` = '0.1795' ,`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` = 'OLYMPIA ESTATES SEC 11, BLOCK 1, LOT 40' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '7821' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '360' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'PALMER ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'HIGHTOWER HIGH SCHOOL' ,`SchoolMiddle` = 'LAKE OLYMPIA MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Olympia Estates' ,`TaxAmount` = '8108' ,`TaxRate` = '3.18' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667145740' WHERE `Matrix_Unique_ID` = '214006282' --> 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','214006757','1667145740','214006757','2022-10-30T08:06:44.540','29992206','Stacy Newton','Weichert,REALTORS-Murray Group','','','30.094634','-95.423893','50','77373','11','459000.00','Active','Hausworth','22902','Court','Spring','3','1','5','3690','Single-Family','Looking for your own private oasis look no further. This immaculate home sits on an oversized lot at the end of a cul-de-sac with a gated driveway for added privacy. Featuring a pebble tech pool and spa (there is a custom pool safety net that will stay), fire pit and an outdoor kitchen space with surround sound. The 3 car garage offers an unfinished bonus room upstairs that is accessible through the garage. Great for storage or can be converted to an apartment. The interior of the home has been completely repainted, new flooring throughout the entire downstairs and the primary bathroom has been updated as well. The home features five full bedrooms and three full baths with a half bathroom downstairs. Upstairs you have not one but two additional living areas. Full home backup generator included. You will fall in love with this property!!','0.2679','12','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Gaslog Fireplace','1','Spring East','Central Gas','1','LT 35 BLK 1 VILLAGES OF NORTHGATE CROSSING SEC 7','Cul-De-Sac','11668','Appraisal District','','655','0','','3','Electric Oven','1','In Ground','','Gas Cooktop','','Composition','48 - Spring','NORTHGATE ELEMENTARY SCHOOL','SPRING HIGH SCHOOL','SPRINGWOODS VILLAGE MIDDLE SCHOOL','Accompany,Appointment Required,Leave Business Card,Lockbox Back,Request Online Appointment','Appraisal District','2','Traditional','Villages Northgate Crossing 07','8455','3.1142','Public Sewer,Water District','2001','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T09:32:22.937' ,`MLSNumber` = '14333485' ,`ListAgentFullName` = 'Michele Uong' ,`ListOfficeName` = 'NB Elite Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.509436' ,`Longitude` = '-95.292058' ,`PhotoCount` = '14' ,`PostalCode` = '77378' ,`RoomCount` = '3' ,`ListPrice` = '285000.00' ,`Status` = 'Active' ,`StreetName` = 'Gale Haven' ,`StreetNumber` = '31' ,`StreetSuffix` = 'Road' ,`City` = 'Willis' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1632' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Conveniently located corner property with country home situated on almost 2 acres of land. 3 bedrooms and a flex/sunroom which could be used as an additional bedroom. There are no restrictions as well as a private water well and septic tank. Fully fenced in with a gated access driveway. Granite counters in kitchen and master bath. Sun room at back of home brings in lots of natural light and has a perfect view of the backyard through recently updated french doors. Beautiful covered patio located in the backyard is perfect for enjoying your morning coffee or afternoon tea. You won\'t want to miss out on this opportunity!' ,`Acres` = '1.7119' ,`Area` = '64' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Coldspring/South San Jacinto County' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'HILLCREEK #5, LOT 8, ACRES 1.7119' ,`LotDesciption` = 'Wooded' ,`LotSize` = '74570' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '101 - Coldspring-Oakhurst Consolidated' ,`SchoolElementary` = 'JAMES STREET ELEMENTARY SCHOOL' ,`SchoolHigh` = 'COLDSPRING-OAKHURST HIGH SCHOOL' ,`SchoolMiddle` = 'LINCOLN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Hillcreek' ,`TaxAmount` = '1876' ,`TaxRate` = '1.6254' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667145740' WHERE `Matrix_Unique_ID` = '214084388' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T09:48:19.503' ,`MLSNumber` = '96221394' ,`ListAgentFullName` = 'Rigoberto Villarreal' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.517159' ,`Longitude` = '-95.751964' ,`PhotoCount` = '24' ,`PostalCode` = '77469' ,`RoomCount` = '11' ,`ListPrice` = '324900.00' ,`Status` = 'Active' ,`StreetName` = 'Pointe Hollow' ,`StreetNumber` = '6531' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2076' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous 1-story home with a brick & stone elevation and beautifully landscaped front yard. Tiled entry leads to a flex room with high ceilings, this room can be used as a second living area, dining or study. Island kitchen and breakfast area feature tile flooring & backsplash, granite counters, gas cooking, stainless steel appliances and opened to the family room. The family room has tile flooring, high ceilings and wall of windows giving this space great natural lighting. Lovely primary suite has high ceilings, double sinks, separate shower, soaking tub and a walk-in closet. 3 spacious secondary bedrooms. Extended covered back patio.' ,`Acres` = '0.1483' ,`Area` = '30' ,`BuilderName` = 'Lennar Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'ROSEHAVEN SEC 1, BLOCK 5, LOT 11, R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6460' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'THOMAS ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'RANDLE HIGH SCHOOL' ,`SchoolMiddle` = 'WRIGHT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Rosehaven' ,`TaxAmount` = '5813' ,`TaxRate` = '2.5848' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667145740' WHERE `Matrix_Unique_ID` = '214098387' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T08:20:46.070' ,`MLSNumber` = '32739049' ,`ListAgentFullName` = 'Trisha Lauter' ,`ListOfficeName` = 'Realm Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.027229' ,`Longitude` = '-95.504630' ,`PhotoCount` = '21' ,`PostalCode` = '77379' ,`RoomCount` = '11' ,`ListPrice` = '292000.00' ,`Status` = 'Active' ,`StreetName` = 'Dayln' ,`StreetNumber` = '5811' ,`StreetSuffix` = 'Court' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2005' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful home in highly acclaimed Cypress Trace, located in a caul-de-sac. Featuring 3 large bedrooms and 2 large bathrooms. The Owner\'s Bedroom has an additional bedroom with closet that can be used as a nursery or could be another separate bedroom with the addition of another entry door if desired. Huge Kitchen with large island, gas range, granite countertops, and lots of storage - open to the Breakfast room and Living Area. Great for entertaining!!! Lovely Formal Dining area that could be used for another Living Area or Game Room. The A/C and tankless gas water heater is approximately 1 year old. Zoned to Klein schools and centrally located to I-45, HWY 249, and the Grand Parkway for easy access to anywhere you need to go. Very well maintained and never flooded, even during Harvey. This is a beautiful home and will not last long!! The PERFECT place to call HOME!' ,`Acres` = '0.1239' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 45 BLK 2 CYPRESS TRACE SEC 2' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '5395' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '425' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'BENFER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN HIGH SCHOOL' ,`SchoolMiddle` = 'STRACK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cypress Trace Sec 02' ,`TaxAmount` = '5300' ,`TaxRate` = '2.5965' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667145740' WHERE `Matrix_Unique_ID` = '214107280' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T08:44:07.590' ,`MLSNumber` = '62499259' ,`ListAgentFullName` = 'Sandra Holcomb' ,`ListOfficeName` = 'Keller Williams Premier RealtyKaty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.869596' ,`Longitude` = '-95.721666' ,`PhotoCount` = '28' ,`PostalCode` = '77449' ,`RoomCount` = '6' ,`ListPrice` = '219500.00' ,`Status` = 'Active' ,`StreetName` = 'Patriot Park' ,`StreetNumber` = '20525' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1233' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming starter or downsizing home with 3 bedroom, 2 bathroom and low maintenance, fenced back yard with attached garage with access from the rear alley. Freshly painted with tile and new laminate floors throughout - NO CARPET. Open concept with kitchen open to living room and dining. Updated GE Slate gray appliances, 5 burner gas range. Fridge, washer and dryer stay with the house. HOA mows the front yard, home is move in ready, now the only thing missing is YOU.' ,`Acres` = '0.0587' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 22 BLK 2 LAKEVILLE SEC 6' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '2556' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '599' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'HEMMENWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS PARK HIGH SCHOOL' ,`SchoolMiddle` = 'ROWE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakeville' ,`TaxAmount` = '4393' ,`TaxRate` = '2.831' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667145741' WHERE `Matrix_Unique_ID` = '214111335' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T08:51:58.520' ,`MLSNumber` = '56015648' ,`ListAgentFullName` = 'Randall Ver Ploeg' ,`ListOfficeName` = 'Woodlands Preferred Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.133666' ,`Longitude` = '-95.409397' ,`PhotoCount` = '30' ,`PostalCode` = '77386' ,`RoomCount` = '10' ,`ListPrice` = '269900.00' ,`Status` = 'Active' ,`StreetName` = 'Invermere' ,`StreetNumber` = '2015' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1608' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'HARD to find SINGLE STORY, 4 BEDROOM, split floorplan w/ formal dining room! Home has Nest iPhone compatability! Recent upgrades include fresh paint inside and out. ALL NEW CARPET. Appliances include a 5 burner gas stove with griddle, dishwasher, SS sink & microwave. REFRIGERATOR, WASHER & DRYER INCLUDED! Also replaced water heater, blinds, fixtures, electrical outlets and switches. Granite in kitchen & bathrooms. Updated vessel bowl sinks in both baths! Fresh landscaping. Home has a sprinkler system and fully guttered (also repainted). Shopping center less than a mile away! Less than 10 minutes to The Woodlands mall & amenities. Make an appt. today!' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'IMPERIAL OAKS 03, BLOCK 20, LOT 48' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '7200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'KAUFMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'OAK RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'IRONS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Imperial Oaks 03' ,`TaxAmount` = '3987' ,`TaxRate` = '2.487' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1992' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667145741' WHERE `Matrix_Unique_ID` = '214122141' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T08:58:50.620' ,`MLSNumber` = '67072434' ,`ListAgentFullName` = 'Soniya Raju' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.014477' ,`Longitude` = '-95.306574' ,`PhotoCount` = '32' ,`PostalCode` = '77338' ,`RoomCount` = '4' ,`ListPrice` = '289999.00' ,`Status` = 'Active' ,`StreetName` = 'Atwood Hills' ,`StreetNumber` = '7902' ,`StreetSuffix` = 'Lane' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2302' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to Kenswick Trace! This adorable 1.5 story home sits on an oversized lot with no back neighbors AND is in a cul-de-sac. This 4-bedroom/2-bath home features a granite countertops throughout, carpet in bedrooms, tile/laminate flooring in main living areas, open concept kitchen and living w/ soaring ceilings in the living area, and a spacious game room/2nd living area overlooking the first floor. Along with the interior features, the extended patio and massive back yard make this home perfect for entertaining! Schedule your appt today!' ,`Acres` = '0.2372' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Humble Area West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 24 BLK 2 KENSWICK TRACE' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '10332' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '417' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'JONES ELEMENTARY SCHOOL (ALDINE)' ,`SchoolHigh` = 'NIMITZ HIGH SCHOOL (ALDINE)' ,`SchoolMiddle` = 'JONES MIDDLE SCHOOL (ALDINE)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Kenswick Trace Sec 01' ,`TaxAmount` = '5750' ,`TaxRate` = '2.7433' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2010' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667145741' WHERE `Matrix_Unique_ID` = '214140974' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T09:54:03.353' ,`MLSNumber` = '52756376' ,`ListAgentFullName` = 'Maria Zuniga' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.676892' ,`Longitude` = '-96.644117' ,`PhotoCount` = '34' ,`PostalCode` = '77979' ,`RoomCount` = '9' ,`ListPrice` = '299900.00' ,`Status` = 'Active' ,`StreetName` = 'High Bluff' ,`StreetNumber` = '221' ,`StreetSuffix` = '' ,`City` = 'Port Lavaca' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '3000' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Calling All Sunset Lovers, This Is Unique Barndominium Waterfront Style Living At Its Best. Additional Living Areas Could Easily Be Added By Converting From The Oversized Garage. Bring Your Boat, RV, OR Both! All It Needs: Your Unique Touches To Convert Into Your Full-Time Oasis On The Bay Or Your Weekend Retreat. 1Bed/1Bath Guest house W/Kitchenette Could Be Income Producing Or A Wonderful AirBnB W/Breathtaking Views! It has Its Own Private Entrance that Could Be Accessed From The Main House. Cement RV Pad W/Hook-Ups, Wrap Around Party Deck, Cat Walk & Fish Cleaning Station, Ready For Fishing, Grilling, Entertaining Or Just Enjoying The Un-Obstructed Views, Stamped Concrete Floors, A/C, Flex Room, Soo Many Possibilities, Only 4miles From Boat Launch, Built To Withstand 200 Mile Winds, Double Insulated Living Areas, No Restrictions, No Permitting, Lowest Tax Rate. No Flood Ins. Req. Priced Well Below Waterfront Property On The Market Today. Allowing You To Fulfill Your Own Dream Oasis' ,`Acres` = '0.75' ,`Area` = '65' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'Lot 12' ,`LotDesciption` = 'Water View,Waterfront' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '169 - Calhoun County' ,`SchoolElementary` = 'JACKSON-ROOSEVELT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CALHOUN HIGH SCHOOL' ,`SchoolMiddle` = 'TRAVIS MIDDLE SCHOOL (CALHOUN COUNTY)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Barndominium' ,`Subdivision` = 'Shoreline Acres' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667145741' WHERE `Matrix_Unique_ID` = '214146688' --> 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','214153668','1667145741','214153668','2022-10-30T09:06:33.110','51703912','Les Strech','Keller Williams Premier RealtyKaty','','','29.768412','-95.742644','26','77450','7','268500.00','Active','Park Wick','21414','Lane','Katy','2','1','3','2168','Single-Family','Welcome to 21414 Park Wick located on an a Quiet street in the desirable, established Memorial Parkway. This home has a great floor plan for large gatherings of friends and family with 2 living areas...both located downstairs. The flooring in the entire home has been recently installed (October 2022). The 2 full bathrooms and 1/2 bath have been updated. The entire interior has also been recently painted. Double Pane, Insulated windows are throughout the home. The backyard is a blank slate and ready for your personal touch. Call today for an appointment! This won\'t last long!!!','0.1637','36','','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Freestanding,Wood Burning Fireplace','1','Katy - Southeast','Central Gas','1','TR 10 BLK 11 MEMORIAL PARKWAY SEC 2','Subdivision Lot','7130','Appraisal District','','435','0','','2','Double Oven','0','','','Gas Cooktop','','Composition','30 - Katy','MEMORIAL PARKWAY ELEMENTARY SCHOOL','TAYLOR HIGH SCHOOL (KATY)','MEMORIAL PARKWAY JUNIOR HIGH SCHOOL','Appointment Required,Lockbox Left Side','Appraisal District','1','Traditional','Memorial Pkwy Sec 02','4471','2.3283','Water District','1976','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T09:14:16.533' ,`MLSNumber` = '55063108' ,`ListAgentFullName` = 'Fafu Zeng' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.219426' ,`Longitude` = '-95.323786' ,`PhotoCount` = '24' ,`PostalCode` = '77302' ,`RoomCount` = '4' ,`ListPrice` = '169800.00' ,`Status` = 'Active' ,`StreetName` = 'Wrangler' ,`StreetNumber` = '16256' ,`StreetSuffix` = 'Avenue' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1344' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 3 bedroom 2 bath and 1 car garage home with a huge almost half acre lot!. Fantastic neighborhood! House has been newly renovated with new AC system, new flooring and new lights/fans. Newly painted throughout and new fences! New appliances. Community has a park with walking trails, playground, and basketball court. Centrally located, close to shopping centers and minutes to I-45, I-59, and The Grand Parkway! This property won\'t last at this price! Schedule your show today.' ,`Acres` = '0.3997' ,`Area` = '19' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Southeast' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LONE STAR RANCH 03, BLOCK 4, LOT 2, MH SERIAL # TXFLY12A8418' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '17413' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '330' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'SAN JACINTO ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CANEY CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MOORHEAD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front,No Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Lone Star Ranch 03' ,`TaxAmount` = '1813' ,`TaxRate` = '1.8488' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667145741' WHERE `Matrix_Unique_ID` = '214157118' --> 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','214158213','1667145742','214158213','2022-10-30T09:54:25.567','16880760','Robert Griffin','Texas United Realty','','','29.636985','-95.439349','14','77045','5','340000.00','Active','Brookston','4122','Street','Houston','2','1','3','1646','Single-Family','Come see this Gem before it\'s gone.. This New Construction home sitting on a corner lot is designed for entertaining and the heart of the home is a large gathering room with the kitchen at the back of the home. This is a 3 bedrooms, 2.5 bathrooms, and a 2-car garage that\'s Conveniently located within minutes of the world renowned Houston Medical Center, Hermann Park, Museum District and more. The kitchen has a large island with granite countertops, custom tile back splash, and ceramic tile flooring. Master Suite complete with double sinks, walk in shower and tons of space. Last but not the least, this home offers a charming covered porch that greets you as you arrive at the front door.','0.1798','18','Garcia Builders','','Washer Connections','','No Disclosures','1','Freestanding,Gaslog Fireplace','1','Five Corners','Central Electric','1','LT 10 BLK 12 BRENTWOOD SEC 2','Corner','7830','Appraisal District','','500','1','Never Lived In','2','Convection Oven','0','','','Gas Cooktop','','Composition','27 - Houston','HOBBY ELEMENTARY SCHOOL','MADISON HIGH SCHOOL (HOUSTON)','LAWSON MIDDLE SCHOOL','Appointment Required','Builder','1','Ranch','Brentwood Sec 02','606','2.3307','Public Sewer,Public Water','2022','Builder'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T08:51:53.997' ,`MLSNumber` = '43388214' ,`ListAgentFullName` = 'Stacey Faucheux' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = 'Kymberly DeRick' ,`SellingOfficeName` = 'Coldwell Banker RealtyREALTORS' ,`Latitude` = '30.049645' ,`Longitude` = '-95.167176' ,`PhotoCount` = '12' ,`PostalCode` = '77345' ,`RoomCount` = '11' ,`ListPrice` = '403900.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Golden Pond' ,`StreetNumber` = '2306' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3009' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '*Home is under contract and no showings are being accepted at this time.*\r\nWelcome Home! Custom built One Story 4bd/3.5ba home in Fosters Mill, backs to Greenbelt and is steps away from Community Park/Pool/Playground. Beautifully landscaped private back yard, deck, patio & hot tub - making this home perfect for family living & entertaining. Walking distance to the community pond. Located on a greenbelt that makes schools, restaurants & shopping just a bicycle ride away. Master suite w/study, nursery or exercise room. Village is surrounded by Deerwood premier golf course.' ,`Acres` = '0.259' ,`Area` = '32' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Kingwood East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 29 BLK 9 FOSTERS MILL VILLAGE SEC 1' ,`LotDesciption` = 'Greenbelt,In Golf Course Community' ,`LotSize` = '11280' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '550' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Built Up' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'DEERWOOD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KINGWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'RIVERWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Fosters Mill Village Sec 01' ,`TaxAmount` = '7989' ,`TaxRate` = '2.5839' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '1981' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667145742' WHERE `Matrix_Unique_ID` = '214195113' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T09:41:35.997' ,`MLSNumber` = '83846842' ,`ListAgentFullName` = 'Denise Kane' ,`ListOfficeName` = 'RE/MAX Elite Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.874992' ,`Longitude` = '-95.704467' ,`PhotoCount` = '30' ,`PostalCode` = '77449' ,`RoomCount` = '6' ,`ListPrice` = '244000.00' ,`Status` = 'Active' ,`StreetName` = 'Chantalle' ,`StreetNumber` = '6650' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1440' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 6650 Chantelle Drive! This charming 3 bedroom 2 bath home has been recently updated with new luxury vinyl flooring, carpet and paint throughout. As you enter this home you will find two guest bedrooms and a full bath. Off the entry is a private hall leading to the primary suite and primary bathroom. Primary suite is large and bath has separate tub and shower, dual sinks and a huge walk-in closet. Den is spacious with a corner gas fireplace and wall of windows overlooking the backyard. Off the den you will find the kitchen/breakfast combo. Kitchen has been updated with new luxury vinyl tile flooring, stainless steel dishwasher and new black/stainless range and microwave. New oil rubbed bronze light fixture in the breakfast room and new backdoor leading to the backyard. Backyard is huge offering plenty of room for kids and pets. New roof 2021! No flooding! Zoned to excellent Cy-Fair ISD and close to shopping. Come see this beautiful home today!!' ,`Acres` = '0.1326' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 37 BLK 4 STRATHMORE SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5775' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single 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` = 'KAHLA MIDDLE SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Strathmore Sec 01' ,`TaxAmount` = '4639' ,`TaxRate` = '2.69' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667145742' WHERE `Matrix_Unique_ID` = '214202876' --> 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','214217841','1667145742','214217841','2022-10-30T09:19:49.090','40782116','Bintuan Zhu','Great Wall Realty, LLC','','','29.685615','-95.480239','15','77096','9','458000.00','Active','Grape','5415','Street','Houston','2','0','4','2017','Single-Family','Never flooded. Masterful renovation. Massive living areas in this home are highlighted with brand new energy-efficient windows plus recessed lighting. Features include wood floors, new trim and doors, gourmet kitchen cabinets with pantry, Quartz countertops, modern island, Stainless Steel appliances, new water heater, new PEX water pipe, new AC duct and new insulation. The open concept living is perfect for entertaining. Conveniently located minutes from Texas Medical Center, galleria mall, exemplary elementary school, and Bellaire high school. Newly additional 320 sqft building in backyard with ACcan be use as a gym, or play area. This make total area 2337 sqft.','0.1894','20','','','','','Owner/Agent,Sellers Disclosure','1','','','Meyerland Area','Central Gas','0','LT 7 BLK 7 BRAES VIEW TERRACE','Other','8250','Appraisal District','','','0','','2','Electric Oven','0','','','Electric Range','','Composition','27 - Houston','HEROD ELEMENTARY SCHOOL','BELLAIRE HIGH SCHOOL','FONDREN MIDDLE SCHOOL','Appointment Required,Supra Keybox','Appraisal District','1','Traditional','Braes View Terrace','8854','2.5304','Public Sewer,Public Water','1960','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','214217906','1667145742','214217906','2022-10-30T09:50:37.920','62307217','Erwin Nicholas','Mr. Real Estate','','','29.641883','-95.377403','15','77051','3','125000.00','Active','Sunnydale','3126','Drive','Houston','1','0','3','1066','Single-Family','Unfinished Remodel opportunity.','0.1389','3','','','','','No Disclosures','','','','Medical Center South','No Heating','0','LT 15 BLK 11 SUGAR VALLEY','Cleared','6050','Appraisal District','','','0','','1','','0','','','','','Composition','27 - Houston','REYNOLDS ELEMENTARY SCHOOL (HOUSTON)','WORTHING HIGH SCHOOL','ATTUCKS MIDDLE SCHOOL','Appointment Required','Appraisal District','1','Other Style','Sugar Valley','3383','2.3307','Public Sewer,Public Water','1955','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','214217930','1667145742','214217930','2022-10-30T09:58:37.380','32218875','Carol Davis','Almost Home Properties','','','30.096763','-95.545381','14','77375','5','239900.00','Active','Willow Forest','8202','Drive','Tomball','2','0','4','1694','Single-Family','Nice 4 bedroom home features granite counters in kitchen and bath, open floor plan with a high ceiling in living room, fireplace and non-carpeted flooring, breakfast nook, and covered patio. New stainless steel dishwasher, sinks and faucets. Formal dining is large enough for dining, playroom, office, or combo. Home is move-in ready. Walk-in closets in every room. Room dimensions are approx and should be verified. Buyer agent to confirm with KJR mgmt, incl updated and current info on HOA transfer fees.','0.1515','14','','','Electric Dryer Connections','','Mud,Owner/Agent,Sellers Disclosure','1','Wood Burning Fireplace','1','Spring/Klein/Tomball','Central Electric','1','LT 104 BLK 4 017*W3465200-001-004-104 WILLOW FOREST SEC 1 R/','Subdivision Lot','6600','Appraisal District','','498','0','','2','Electric Oven','0','','','Electric Cooktop','','Composition','32 - Klein','SCHULTZ ELEMENTARY SCHOOL','KLEIN OAK HIGH SCHOOL','HILDEBRANDT INTERMEDIATE SCHOOL','Appointment Required,Lockbox Front','Appraisal District','1','Traditional','Willow Forest Sec 01 R/P','5077','2.8765','Water District','1978','Appraisal District'); --> New record created successfully